X

Exalytics In Memory Machine

  • April 30, 2013

How To Pass Presentation Variable To the Title View Using Dashboard Prompt?

Saresh Namboorissery
Principle Software Engineer

Presentation variable does not pass correctly in title view
when all values are selected in the dashboard prompt.

For eg, when all values are selected,the title is displayed
as @{xxxxx}

When you select a value from the dashboard prompt , the
title is reflected correctly with the selected value in dashboard prompt.

This issue can be reproduced at will using any version of
OBIEE. The test case using OBIEE 11.1.1.7 is demonstrated below:


 Steps:

Section 1: Create the report:

1.1.Create an analysis using sample sales lite rpd with
following criteria:

  • Time: Per Name Year
  • Product: Brand
  • Offices: Department
  • Base Facts: Revenue

Add a Filter ->Product: Brand and make it 'Is prompted' (we will be making Brand as the presentation variable)


1.2.Click on Result and Edit the Title


1.3.In the 'subtitle' field , Enter the name of presentation variable, say @{Brand}


1.4.Save the report as 'Presentation var'

Section 2: Create the Dashboard prompt.
2.1 Create a New Dashboard Prompt (New->Dashboard Prompt)
2.2 Add a Column Prompt: Product ->Brand
2.3 Expand the Options and Set a variable to 'Presentation variable' and Enter 'Brand' in the field below.


2.4Save the dashboard prompt as 'PVprompt'

Section 3: Create the Dashboard Page

3.1 Create a new board and name it as :PVDashboard
3.2 Drag and drop the Dashboard Prompt created from Section 2 into the dashboard page
3.3 Drag and drop the report created from Section 1 to the dashboard page
3.4 Save the Dashboard page and run it.
3.5 When there is no value selected in the dashboard prompt, the subtitle is displayed as '@{Brand}'


3.6 When you select a value for Dashboard prompt : say 'BizTech', it is displayed correctly as BizTech as shown below:


To fix this issue, Do the following:

Edit the Title view from Results tab and add a default value for All selection for eg, 'All Brand' in this case: @{Brand}{All Brand}and Save the title.



Save the Dashboard PVDashboard,and Run it .Now the Presentation Variable is displayed correctly when you dont select any value for the Dashboard prompt.


Join the discussion

Comments ( 4 )
  • guest Tuesday, April 30, 2013

    Excellent posting.

    We were trying to get this working for long time.


  • guest Tuesday, July 21, 2015

    Thank you for the detailed steps on using the presentation variable on reports. Much appreciated

    Is there a possibility of showing up the tables / pivot tables created in the report while using the prompt. In the sense, once prompt being created, it is only section shown up in reports / dashboards, once user select the values then only the rest of sections being displayed on the report

    Thanks

    Srikrishnan


  • guest Friday, September 4, 2015

    Thankyou very much... very useful


  • kalyani Tuesday, July 3, 2018
    Excellent it is working fine
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.