Direct links to schedules in BO 4.2 SP3

building reports webintelligence
1

I’m creating a tool with the BO REST API which will help my team to manage all of our scheduled reports.

It queries the CMS database and shows all instances, and allows us to filter and sort the list multiple ways to enable us to find errors and schedules/reports we’ve to take a look at (multiple recurring instances, long run times, big file size, etc), and also plots the instances in a graph to show how many schedules were running at the same time (which will help us leveling out the server load)

The tool already provides:

  • Links to the report and particular instances (using “/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=”)
  • Links to the report folder in which the report could be found (using “BOE/BI?startFolder=”)

But I’m still searching for a way to create links that will link directly to a specific recurring schedule or the instance history of a report, to make it easy to modify existing recurring schedules.

In BO XI2 I was able to use links like “http://{server}/businessobjects/enterprise115/desktoplaunch/InfoView/CrystalEnterprise_Webi/history.do?objId={ID}” to link directly to the history for a certain report, but I haven’t been able to find anything so far that works in BO4.2 SP3.

Most promising one so far was

  • https://{server}/BOE/portal/{portal id}/AnalyticalReporting/jsp/Shared_History/history.faces?cafWebSesInit=true&appKind=InfoView&service=/InfoView/common/appService.do&ctx=standalone&actId={ID}&objIds={ID}

but it seems to work only if you’re already logged onto BO… and none of the actions work…

Any help is highly appreciated

4Tune (BOB member since 2017-12-16)

2

Investigate the OpenDocument functionality within Business Objects (google will help you)
As a start you can right-click a report in BI Launchpad and select “Document Link”. An OpenDocument link is generated for you that links to that report
You can link to a report or an instance if required
basic URL

http://<server>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=<documentID>&amp;sIDType=CUID

buzz :australia: (BOB member since 2005-08-12)

3

Hi Buzz,

thanks for your reply, as far as I know, openDocument won’t help me as I’m looking for a direct link to a schedule, or the list with last instances for a report (like when selecting the “History” link in the menu)

OpenDocument opens the report itself

4Tune (BOB member since 2017-12-16)

4

If to you want to link to the most recent instance of a base report, use the base report’s CUID in the “iDocID” parameter, and append “&sInstance=Last”.

If, however, you want to link to a specific instance, it’s a little more tricky. You need the CUID or the instance, but neither BI launchpad nor CMC display the ID or CUID of instances.

You can use Query Builder to get it. The following query will display all child instances of document 265388, including the CUID and run time. You could then drop the appropriate CUID into your openDocument link, and link directly to that instance.

select si_cuid,si_update_ts from ci_infoobjects where si_parentid = 265388 and si_schedule_status = 1 order by si_id desc

joepeters :us: (BOB member since 2002-08-29)

5

Hi joepeters,

Thanks your reply, I think my question was not completely clear, I’m looking for a link that links directly to an existing recurring schedule so that the schedule could be editied, or the history list for a report that shows last instances, but also the recurring ones.

I’ve editied my post, hopefully it’s now more clear.

4Tune (BOB member since 2017-12-16)

6

Ok, now I understand what you’re after.

I don’t think there’s a direct way to do that. The closest you can get is to link to the folder that the document is in, but the user would still need to locate the document and click “History”.

See here for linking to a folder: https://blogs.sap.com/2014/03/31/direct-links-to-folders-41-sp3/

joepeters :us: (BOB member since 2002-08-29)