Business Intelligence – Oracle

Oracle BI EE 10.1.3.3.3/2 – Delivering Prompted Dashboard Pages using iBots – Bookmark links and HTML

Posted by Venkatakrishnan J on May 13, 2008

One very good feature that BI EE does not have currently is the ability to send prompted dashboards to users via iBots. Currently, iBots can only send filtered reports but not dashboards. Lets look at an approach today to send prompted dashboards to end users. Use this approach only if you have no other option. Using the approach one can send the dashboards only in HTML format (PDF would not work). Let us start with the Brand Analysis Dashboard Page that we have in the Paint Dashboard. This page contains 4 prompts and a number of reports. Lets choose some values in all these prompts and run the reports like the one shown below

    

Our aim is to send this page(with the prompt values that we have chosen) via delivers. In order to achieve this lets start with create a Bookmark link to the page. If you are not sure what Bookmark link does, check my previous blog entry here. This bookmark link would give us a dashboard page with the same prompt values that we applied above. Now save this link. Then go to answers and create a simple report. Include a dummy column with the below formula

CASE WHEN 1=0 THEN Markets.Region ELSE 'Dummy' END

    

This is to ensure that the report does not throw out any error. Now, go to the narrative view of this report and enter the below iframe html code.

    

In the above iframe, replace the src= attribute with the bookmark link that you saved in the previous step. Also, ensure that you are adding nquser and nqpassword parameters as shown above. Now, in the compound layout of this report just have this narrative view. Save this report. Now go to delivers and schedule an ibot to send this report to end users. Ensure that you are sending the content only as HTML.

    

Now, your end users would be receiving the prompted dashboards via delivers.

    

Not the best solution, but can be used in certain cases where the requirement is an absolute must. One can add more customizations to this by choosing a single bookmark page from multiple pages.

Advertisements

8 Responses to “Oracle BI EE 10.1.3.3.3/2 – Delivering Prompted Dashboard Pages using iBots – Bookmark links and HTML”

  1. rye said

    Hi Venkat,

    It’s already possible to send dashboard pages. I’m not sure if it was already included from 10.1.3.2 but definitely it is already incorporated in 10.1.3.3.1.

    I forgot which version that was wherein one would have to check all dashboard pages to get to the correct dashboard since the dashboard names (untitled) were all the same but this was fixed with 10.1.3.3.x.

    Rye

  2. Venkatakrishnan J said

    Rye – This blog is not about sending dashboard pages. This is about sending prompted dashboard pages (reports within a dashboard containing some values in the prompts).

  3. Rye said

    My bad Venkat. I stopped reading at “Currently, iBots can only send filtered reports but not dashboards…”.

    What instances would this be useful? Security wise, I wouldn’t want to recommend this especially since the Administrator username and password are included in the URL.

  4. Mike said

    Another option for delivering prompted dashboards via Delivers is to use the BI EE Dashboard ‘Saved Selections’ for this – this can be found in the ‘Page Properties’ button on the top right hand side of the dashboard. Saved selections can be set up for other groups and can also be set as the default for those groups. When Delivers iBots are based on the dashboard then the default saved selection will be used.

  5. Venkatakrishnan J said

    Excellent one Mike. Thanks for sharing this. I have put this as a seperate blog entry since this supports PDF attachments too.

    -Venkat

  6. […] by Venkatakrishnan J on May 21, 2008 If you have looked at my blog entry here, i would have shown you how to go about delivering prompted dashboard pages. But the major drawback […]

  7. Sam said

    Hi Venkat,

    I noticed that the bookmark link URL has the NQUser and Passwords exposed as text. Is there a way in which we can encrypt it?

  8. Maheswar said

    Hi Venkat,

    My requirement is to send the Dashboard URL to non OBI Users through email.
    i can use bookmark URL for this but in this url the user id and password are visible.can you could you please let me know how to get a secured link(encrypting the password) to a dashboard.

    Thanks,
    Maheswar.

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: