Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Dashboard Prompts and BI Publisher

Posted by Venkatakrishnan J on October 19, 2007

One of the common questions that generally come up with regard to BI EE and BI Publisher is “how does one pass parameters to BI Publisher reports in Dashboards?”. Well, there are two methods for achieving this.

1.   Create a BI Publisher Report using BI Answers report as the data source wherein the BI Answers report would have one of the column’s filter clause as “is prompted”.

2.   Create a BI Publisher Report using BI Answers/Database as data source. Create a parameter for the BI Publisher report and then match this parameter name while assigning the presentation variable for the dashboard prompt.

Method1 is straight forward. All we need to do is to create a report in BI Answers first and then assign filter to one of the columns using is prompted clause. In our case we would be creating a simple sales report across multiple regions. And Region is the column which would have the filter.

      

Now go to BI Publisher and use this BI Answers report as a data source. Create a simple template for this report. Check whether this simple report works.

      
     
     

Once this is done lets create a dashboard prompt in answers which would basically refer to the Region Column. In this method, there is no need for setting any presentation variables.

      

Lets create a new Dashboard page and add the prompt and the BI Publisher report. The BI Publisher report would change based on the Region that you select in the dashboard prompt.

      

Method2:

      This method is generally the most used since most of the BI Publisher reports would have database as the data source. In order to test this, lets create a simple BI Publisher report with the data coming in from SH schema of the database. We will be creating a report with the same columns as above to keep it simple. Also create a simple template and check whether the BI Publisher report is working.

      

Now add a parameter to the report. In our case, we will have Region_Prompt as the parameter name. And test the report.

      

      

Then go to the BI Answers and create a dashboard prompt on the same Region column. In this prompt we must set a Presentation Variable, Report_Prompt. Just note the name of the presentation variable. It must exactly match that of BI Publisher parameter name. Include this dashboard prompt and the BI Publisher report into the dashboards. And test it out.

      

      

About these ads

4 Responses to “Oracle BI EE 10.1.3.3/2 – Dashboard Prompts and BI Publisher”

  1. Sunil said

    Hello Mr. Venkatakrishnan,

    I am exporting the xml file from ‘view’ option & then importing it in to rtf file. Please suggest how do i pass date parameters such as from date and to date.

    Thank you and Regards

  2. Matys said

    Hi Sunil ,

    i’m facing the same problem. I cannot pass the date parameter. Did you manage to solve this? Thanks in advance.

    regards

  3. Jiri Pelousek said

    Hello

    I tried method n. 2. It works well but only when the parameter is string type.
    When I use date type, I get null value in publisher.

    Any idea how to solve this?

    Thank you

  4. Jeff said

    For Method 2, to solve the date paramater issue I set the BI Publisher Parameter up as a String then put the to_date() around the parameter declaration in the SQL Query.
    The dashboard prompt was then set up as a Calendar control. You may have to play around with the date formatting to get it to work properly for you.

    Thanks,
    Jeff

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

 
Follow

Get every new post delivered to your Inbox.

Join 151 other followers

%d bloggers like this: