Open Document Function

It been a while i have written a  new post in my blog , as promised in my last post here come some information about opendocument function

Open Document Function

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:

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

Structuring an openDocument URL

The next sections explain how to use the openDocument function, and how to construct the URL.

An openDocument URL is generally structured as follows:

“http://<servername>:<port>/OpenDocument/opendoc/<platformSpecific>?<parameter1>&<parameter2>&…&<parameterN>”

The exact syntax of the <platform Specific> parameter depends on your Implementation:

• For Java implementations, use openDocument.jsp in place of the <platform Specific> parameter.
• For .NET implementations, use opendocument.aspx in place of the <platform Specific> parameter.

Implementing OpenDoc function for a Webi report.

First change the Webi preference to “Interactive mode”

1. Construct a default report using Efashion Universe as Follows

Report shows state wise revenue

Right Click the Column State and

Click Hyperlink->New

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

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(””+[State])+”&sWindow=New\” title=\”\” target=\”_self\” nav=\”doc\”>”+[State]+”</a>”

The Code is Explained below

1. DocID= ARAVm7DFcZ9Ak4ceI5HiF9E
2. sIDType=CUID
3. sType=wid(Webi Document)
4. sRefresh=N(No Refresh on Open,if you want you can set it to ‘Y’)
5. lsM=Specify the Multiple Values for prompt
6. lsMEnter%20value(s)%20for%20State%3A=”+URLEncode(””+[State])(The Prompt Given is taken and it point to the column ‘State’)
7. sWindow=New\” title=\”\” target=\”_self\” nav=\”doc\” (Once I click the hyperlink ‘State’,my target report open in new window)

For more info on Open Document Function check out this url Opendocument