Sunday, October 21, 2007

E-mail report hyperlink

When you create a scheduled report and you want to e-mail the hyperlink of the report in BOE you can configure this in the schedule settings. You include the Viewer Hyperlink by selecting that option in the drop down below the Message box. This selection adds %SI_VIEWER_URL% to the message field which later translates to a valid URL to that report using the openDocument method.



The resulting URL in the e-mail could look something like this (ASP platform):

http://xyz/businessobjects/enterprise115/infoview/scripts/openDocument.aspx?sIDType=CUID&iDocID=BUXpQ_n_fITEsTtHIPe_oXY

The %SI_VIEWER_URL% adds the URL that was specified in CMC->Objects->Object Settings...->Processing Settings->Default viewer URL and translates it to the hyperlink above.

But what if you manually wanted to specify the URL without changing it in the Object Settings? It's easy and it's possible. Just type the URL manually specifying the JSP or ASP path and the openDocument part. Based on settings above (CR document) you would type

'http://xyz/businessobjects/enterprise115/infoview/scripts/openDocument.aspx?sIDType=CUID&iDocID=%SI_CUID%'

in the Message field. The %SI_CUID% adds the unique object id of that document.

If you want to explore the openDocument parameters in detail, look at this document. It describes both the ASP and JSP version of the openDocument syntax.

No comments: