Skip to Content
Author's profile photo Former Member

Open Document Function in SAP Business Objects

OpenDocument Function provides URL access to multiple document types by passing a URL string to a BusinessObjects Enterprise server.

You can use openDocument in BusinessObjects Enterprise to create cross-system links to and from the following document types:

    • .rep: Desktop Intelligence documents
    • .rpt: Crystal reports
    • .car: OLAP Intelligence reports


Structuring an openDocument URLFor Java implementations, use openDocument.jsp in place of the For .NET implementations, use opendocument.aspx in place of the First change the Webi preference to “Interactive mode”

1. Construct a default report using Efashion Universe as Follows

Report shows state wise revenue

!|title=op3|height=289|alt=op3|width=342|class=aligncenter size-full wp-image-96|src=!

Right Click the Column State and

Click Hyperlink->New

!|title=op1|height=383|alt=op1|width=480|class=alignleft size-full wp-image-99|src=!

Check the option Link to Document

Click Browse and select the target report here it is “Sales Revenue-Target Report”

You can check some of the options available if you need

“Don’t select the option use complete url it will cause a problem when you change your web server so keep it unchecked”

Once you select the target report it also shows the default prompt available in that report.

Here the default prompt in the target report is “Enter the Values for State”, once it done then you click apply and say ‘OK’

Final Report!|title=op22|height=153|alt=op22|width=404|class=aligncenter size-full wp-image-104|src=!

Code generated is as follows:-

=”<a href=\”../../opendoc/openDocument.jsp?iDocID=ARAVm7DFcZ9Ak4ceI5HiF9E&sIDType=CUID&sType=wid&sRefresh=N&lsMEnter%20value(s)%20for%20State%3A=”URLEncode(””)”&sWindow=New\” title=\”\” target=\”_self\” nav=\”doc\”>””</a>”</p><p> </p><p>The Code is Explained below</p><ol><li>DocID= ARAVm7DFcZ9Ak4ceI5HiF9E</li><li>sIDType=CUID</li><li>sType=wid(Webi Document)</li><li>sRefresh=N(No Refresh on Open,if you want you can set it to ‘Y’)</li><li>lsM=Specify the Multiple Values for prompt</li><li>lsMEnter%20value(s)%20for%20State%3A=”URLEncode(””+)(The Prompt Given is taken and it point to the column ‘State’)

    1. sWindow=New\” title=\”\” target=\”_self\” nav=\”doc\” (Once I click the hyperlink ‘State’,my target report open in new window)

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      The SAP Portal has a Master IView that allows you to launch WebI reports with the latest instance.  This simply passes parameters using the opendoc API, but without having to parse the parameters yourself.
      It works great, except for the "Lastest Instance" parameter isn't passed correctly by SAP.  Our workaround is to use an URL IView with all the opendoc API params passed ourself.
      Wondering if others noticed this as well?