Business Intelligence – Oracle

Oracle BI EE 10.1.3.4 and Hyperion Web Analysis – Drill from BI EE to Web Analysis – Part 1

Posted by Venkatakrishnan J on February 10, 2009

If you had looked at my blog entry here, i would have shown how to go about drilling from BI EE to HFR. Along the same lines, lets look at another common requirement which is to drill from BI EE to Web Analysis. Again as i have said here before, the fundamental idea is to get the URL parameters for Web Analysis and understand how Web Analysis accepts its parameters. In order to understand this, lets create a simple report using Web Analysis studio as shown below.

       

Our aim is to determine the URL parameters for Web Analysis. So, for one of the measure values add Related Content and just include the same report as shown below

       

       

Now, if you see there are 3 types of links offered by Web Analysis

1. Embedded Link
2. Java Link (The Web Analysis Studio Link)
3. HTML Link

Lets analyze all the 3 links one by one. The first one is the Embedded link.

http://localhost:19000/workspace/index.jsp?module=tools.relatedcontent&repository_uuid=0000011f02bc7ee8-0000-0000-0a0a0a0a&repository_format_id=html&repository_name=Parent%20Report&repository_path=/Users/admin/Reports/Parent%20Report&sso_token=$SSO_TOKEN$&$CONTEXT$&mimetype=application/hyperion-analyzer-report

As you see this has the following parameters

1. module – This is a workspace specific parameter which specifies that the report comes as a related content.
2. repository_uuid – This a constant id for the webanalysis report
3. repository_format_id – Since workspace can embed multiple objects of different mime types, this specifies the output type of the report.
4. repository_name – name of the WebAnalysis report
5. repository_path – path to the actual Web Analysis report
6. SSO_TOKEN – This token is useful for all SSO enabled workspace contents. If this is passed in the URL, the target application is opened automatically without signing in. (If SSO is not enabled then SSO_USERNAME and SSO_PASSWORD can be passed in the URL)
7. CONTEXT – This passes the actual POV of the cell that we have clicked. This is the most important parameter as this would let us know how the parameters are passed to web analysis.
8. mime_type – This determines the application type.

Typically it is recommended to use the Embedded link as the output type is generally driven by the URL parameter itself. The second link is the Java Link. This helps in drilling within the studio itself. This is not generally used a lot unless a person requires the drill to happen within the studio itself.

http://localhost:19000/WebAnalysis/WebAnalysis.jsp?sso_token=$SSO_TOKEN$&report=/Users/admin/Reports/Parent%20Report&$CONTEXT$&sso_token=$SSO_TOKEN$&$CONTEXT$&mimetype=application/hyperion-analyzer-report

The parameters are exactly the same as the one in embedded link. But not every parameter in the Embedded link is supported in the Java Link.

The third type of link is the HTML link. This is used for generic content viewing in HTML. Its URL is shown below

http://localhost:19000/WebAnalysis/servlet/HTMLViewer?sso_token=$SSO_TOKEN$&action=login&postLogin=LoadReport&report=/Users/admin/Reports/Parent%20Report&$CONTEXT$&sso_token=$SSO_TOKEN$&$CONTEXT$&mimetype=application/hyperion-analyzer-report

In all the 3 links above, the most important of all is the $CONTEXT$ parameter. This is what passes down the individual Point of View (POV) values to the target. But to pass this from BI EE, we need to know how this $CONTEXT$ parameter is structured. So, instead of using a report as a related content, lets include a custom link as shown below.

       

Now, launch this URL from within Web Analysis Studio. You would see a new IE window with the actual CONTEXT parameter as shown below

http://sample/?cepversion=1.1.0&applicationtype=WebAnalysis&applicationurl=&applicationversion=11.1.1.1.0.797&dsclass=OLAP&disconnection=ADM&dsurl=&dsprovider=&schema=SH&attribute=Times%2eid%2eTimes&attribute=Promotion%2eid%2eNO+PROMOTION&attribute=Product%2eid%2eProduct&attribute=Measures%2eid%2eMeasures&attribute=Channel%2eid%2eChannel&attribute=Customers%2eid%2eRio+de+Janeiro&attribute=SH%2evalue%2e3%2e0

       

In HFR, the $CONTEXT$ that we saw earlier had a specific format. If you look closely, Web Analysis too follows a similar pattern. To pass down individual member values to the report just use

attribute=<Dimension Name>.id.<Dimension Value>

For example,

attribute=Times.id.2008

There are also other parameters in the URL which are specific to Web Analysis. Now, that we have seen how the URL parameters for web analysis is structured, the integration from BI EE remains the same. The idea is to generate the above URL dynamically (which i have shown in the HFR blog entry). An example is given below

       

2 Responses to “Oracle BI EE 10.1.3.4 and Hyperion Web Analysis – Drill from BI EE to Web Analysis – Part 1”

  1. Paul Dobson said

    If I want to automatically login to Web Analysis from an inhouse application how do I generate a value for $SSO_TOKEN$ so that a link inside my application can automatically open a web analysis view. Assume Workspace is setup as Single Sign On. Is there any documentation you can point me to for single sign on setup and/or SSO_TOKEN.

  2. EnjoyMedia said

    Nice post.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: