Tuesday Apr 30, 2013

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

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.


About

This Blog is for sharing the latest information regarding Exalytics and OBIEE

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today