Skip to Content

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

!http://chennaibi.files.wordpress.com/2009/02/op3.gif?w=342&h=289|title=op3|height=289|alt=op3|width=342|class=aligncenter size-full wp-image-96|src=http://chennaibi.files.wordpress.com/2009/02/op3.gif?w=342&h=289!

Right Click the Column State and

Click Hyperlink->New

!http://chennaibi.files.wordpress.com/2009/02/op1.gif?w=480&h=383|title=op1|height=383|alt=op1|width=480|class=alignleft size-full wp-image-99|src=http://chennaibi.files.wordpress.com/2009/02/op1.gif?w=480&h=383!

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!http://chennaibi.files.wordpress.com/2009/02/op22.gif?w=404&h=153|title=op22|height=153|alt=op22|width=404|class=aligncenter size-full wp-image-104|src=http://chennaibi.files.wordpress.com/2009/02/op22.gif?w=404&h=153!

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)
To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Alexander Schuchman
    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?
    (0) 

Leave a Reply