Business Intelligence – Oracle

Oracle BI EE – Presentation Variable in Report Titles

Posted by Venkatakrishnan J on December 12, 2007

I thought of blogging about another pretty common question which keeps getting repeated in the forums. The question is “How do we refer the Presentation Variables in the Title of a report?”. Lets try to achieve that here. To take an example, i have a dashboard page containing a dashboard prompt and a sample report. The sample report will be filtered based on the value chosen in the dashboard prompt. This is achieved using a presentation variable product.




Now, our aim to display in the Title of the Report something like “Product Chosen in the Prompt is: Actual Value Passed in the Prompt“. Now lets go to the report and add a sample dummy column. In that dummy column refer the presentation variable like this ‘@{product}’ including the single quotes and hide the column.




Now go to the narrative view of the report. In the narrative view enter the desired text followed by @n (@ refers to the column and n refers to the column position. In our case we are referring to the hidden presentation variable column). Now go back to criteria. Remove the filter (the reason why we are removing the filter is we would be getting a no data found message and hence we would not be in a position to arrange the narrative view to look like the title view). Once this is done, add the narrative view to look like the title view. And go back to the criteria and add the filter again with the presentation variable. Save the report. Now you would be able to see the filter with a customized message in your title view.




The advantage of the narrative view is that you can format your variables and also can add marquee like scrolling titles using various HTML formatting tags. But if you just want display the filter applied without any custom message you can use the Filter View.


4 Responses to “Oracle BI EE – Presentation Variable in Report Titles”

  1. Bindu said

    If the resultant report has multiple columns, the prompt is repeated in narrative view for each row. It works perfect in filter view.

  2. Venkatakrishnan J said

    In that case, type 1 in the Rows section of the Narrative view. That will restrict it to 1 row.

  3. sikander said

    what if we want to display the results from the column prompt on the report.

    Now the condition is we r choosing two dates in a column prompt and we want the dates to be displayed on top of the report now filter view ll do the trick but it ll show all the other filters applied which we dont want.

  4. sitesh said

    excellent blog…but we can achieve this without using 3rd additonal column…just write the text that u want to display in the narrative view of the report that u want with the suffix @n.and add this narrative view to ur existing view…thats it…if i am wrong somewhere then pls correct me…

Leave a Reply

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

You are commenting using your 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: