Open Document Function

March 4, 2009
51 Views

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 […]

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

op3

Right Click the Column State and

Click Hyperlink->New

op1

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 Reportop22

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

You may be interested

How SAP Hana is Driving Big Data Startups
Big Data
298 shares2,887 views
Big Data
298 shares2,887 views

How SAP Hana is Driving Big Data Startups

Ryan Kh - July 20, 2017

The first version of SAP Hana was released in 2010, before Hadoop and other big data extraction tools were introduced.…

Data Erasing Software vs Physical Destruction: Sustainable Way of Data Deletion
Data Management
37 views
Data Management
37 views

Data Erasing Software vs Physical Destruction: Sustainable Way of Data Deletion

Manish Bhickta - July 20, 2017

Physical Data destruction techniques are efficient enough to destroy data, but they can never be considered eco-friendly. On the other…

10 Simple Rules for Creating a Good Data Management Plan
Data Management
69 shares619 views
Data Management
69 shares619 views

10 Simple Rules for Creating a Good Data Management Plan

GloriaKopp - July 20, 2017

Part of business planning is arranging how data will be used in the development of a project. This is why…