Extend Dashboard funtionality by using Presentation Variables

It’s possible to extend the functionality of your Oracle BI Dashboard by using Presentation Variables. Nothing new here. For some more details about variables in Oracle BI EE and how to use the please have a look here.

A colleague of mine pointed me to two examples of how to use these variables in your Oracle BI Dashboard. Maybe nothing new as well, but nice to mention anyway.

Add a Presentation Variable to a section heading

If you want, you can add an heading to your section. This is pretty straight forward.

Default, when you add a section to your dashboard, the section is named; ‘Section 1′.

 

 If you want to give this section a maeningful name and add it to your dashboard page, you can rename and display the section.

The dashboard page will show the text acccordingly.

If you like you can make this heading dynamic by using a Presentation Variable. First you will have to make a dashboard prompt to set the Presentation Variable.

 

Secondly you can reference the Presentation Variable. In this case, add; @{PV_SUPPLIER} to the section heading.

Now the dashboard page will show the heading, including the Presentation Variable.

When you change the selection in the dashboard prompt the text will also change.

Using an iFrame to show different views of the same Answer based on Guided Navigation and a Presentation Variable

Picture the following simple requirement:

I have a set of Suppliers. Each Supplier has a Supplier Type.

On my dashboard, there is a prompt on Supplier Type.

When I select ‘Oracle’; show a Pivot table. If ‘Non-Oracle’ is chosen, then there should be a ‘Line Chart’ for ‘Scamander Solutions’. ‘Oracle BI By Bakboord’ will show a ‘Bar Graph’.

You could achieve this by making multiple Answers, Guided Navigation and some hard-coding. Another way of achieving this requirement, is using Guided Navigation, iFrames and a Presentation Variable in combination with an GO Url. iFrames require the use of Presentation Variables, because they cannot capture the values you select in a prompt directly.

Edit a dashboard page and add two sections with Guided Navigation to switch between the views for the Supplier Type. In the section for Supplier Type = ‘Non-Oracle’ add two Text Objects for the iFrames.

Add the folowing code to the Text Object for the iFrame:

<iframe src=
http://localhost:9704/analytics/saw.dll?Go&Path=/shared/OBIBB/Presentation%20Variable%20iFrame&Action=Navigate&P0=2&P1=eq&P2="Dim%20Supplier"."Supplier%20Type"&P3=@{PV_SUPPLIER_TYPE}&P4=eq&P5="Dim%20Supplier"."Supplier%20Name"&P6=Oracle%20BI%20By%20Bakboord&Options=rmf&ViewName=staticchart!1 width=100% height=375 frameborder=none>
</iframe>

 Now I am able to switch between different views, without having to create different Answers

 

About these ads

About Daan Bakboord
I am an Oracle Business Intelligence Consultant with great interest in anything closely related to the Oracle BI Foundation Suite.

Leave a Reply

Please log in using one of these methods to post your comment:

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 701 other followers

%d bloggers like this: