Business Intelligence – Oracle

Archive for November 13th, 2007

Oracle BI EE 10.1.3.3.1 – Bookmark and Prompted links – Passing Prompt Values to Dashboards

Posted by Venkatakrishnan J on November 13, 2007

Thanks to Bryan for pointing this out. One other important feature of BI EE 10.1.3.3.1 is that one can have symbolic Bookmark and Prompted links. And this can be generated right from within BI EE. Lets look at what Bookmark and Prompted links are.

Bookmark Links( we have this right from 10.1.3.3.0):

You can find Bookmark Links under Page Options of a dashboard. Basically the bookmark links store the entire session state of a dashboard. So if you are in the process of analyzing your data with say some values in your prompts across the pages in the dashboard and if you want someone else to see this dashboard in the same state, all you need to do is to click on the Bookmark Link and give that link to the other users.

      

A sample BookMark link is given below

http://localhost:9704/analytics/saw.dll?Dashboard&_scid=7QG-YR3Qf6w&PortalPath=%2Fshared%2FSales%20Managers%2F_portal%2FSales%20Analysis&Page=Sales%20Trend&PageIdentifier=s1s0l6apgdf815m7&BookmarkState=tt4bq2ep2rqj4nqudmdq0vn9ue

You can also add the nquser and nqpassword parameters directly to get to the actual report. Basically when we create a bookmark link all the session states are basically stored in the presentation catalog. You can see the bookmark information from the catalog manager.

      

The only disadvantage with this is we cannot use this dynamically to build URLs. Fo that we have Prompted Links.

Prompted Links:

This is one cool feature that i have been trying to track down for some time now. This gives the ability to have Dashboard GO URL and at the same time pass default values to the various prompts in the Dashboard Pages. Lets take an example URL as below.

http://localhost:9704/analytics/saw.dll?Dashboard&nquser=Administrator&nqpassword=Administrator&PortalPath==/shared/Paint%20Demo/_portal/&Page=Date+Marker&Action=Navigate&col1=SALES1.QUANTITY&val1=45000000

As you see above what this basically does is it sets the dashboard prompt (that uses SALES1.QUANTITY) with the value 4500000. A very handy feature.

Posted in All Posts, OBI EE Plus | 13 Comments »