Pass Presentation Variable To the Title View Using Dashboard Prompt?

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

Create the report:

• Create an analysis using SampleAppLite repository with following criteria:
• Add a Filter ->Product: Brand and make it 'Is prompted' (we will be making Brand as the presentation variable)

• Click on Result and Edit the Title.
  
• In the 'subtitle' field , Enter the name of presentation variable, say @{Brand}
  
• Save the report as 'Presentation var'

Create the Dashboard prompt

• Create a New Dashboard Prompt (New->Dashboard Prompt)
• Add a Column Prompt: Product ->Brand
• Expand the Options and Set a variable to 'Presentation variable' and Enter 'Brand' in the field below.
  
• Save the dashboard prompt as 'PVprompt'

Create the Dashboard Page

• Create a new board and name it as :PVDashboard
• Drag and drop the Dashboard Prompt created from Section 2 into the dashboard page
• Drag and drop the report created from Section 1 to the dashboard page
• Save the Dashboard page and run it.
• When there is no value selected in the dashboard prompt, the subtitle is displayed as '@{Brand}' 
  
• 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 don't select any value for the Dashboard prompt.
  

  

Reference: https://blogs.oracle.com

Happy Stay. :-)

Dynamic columns in reports / dashboards - OBIEE 11g

I got this requirement from my client, i.e. we can select any of the dimension listed over there and according to that, the report on the dashboard should get changed.

To be more clear, one example I will illustrate on this. The scenario is,

Time, Product,  Offices, etc.  are the dimensions in your repository. On this, there will be three radio buttons having values Year, Product Type, and Office.

There's a report which will be having one table view and bar graph for that. (just for example, it can view)

Now the actual requirement is, when you select any of the value from radio button list, the report's dimension should get changed. 

For example, suppose the default view of the report is "Year" vs. "Revenue".

Now when you select "Product Type" value from the list, the report will get changed as "Product Type " vs. "Revenue".

To achieve this, we can refer the following steps.

• Create one sample report as follows,
  
  
  
• Add bar graph to this analysis.
  
  
• Create one dashboard level prompt.

• Click New to add a new prompt.

• Put the following values as per our example.

• In the display section, you will be having following screenshot.

• Click OK when you finished. Save this prompt.
• Open the previously saved analysis in EDIT mode.
• Go to the Criteria tab.
• Select Column Properties of the "Per Name Year" column.

• Here, you will be setting the presentation variable name as a dimension for the report.

• Save the analysis.
• Now just drag and drop this prompt & report to the dashboard.
• Save the dashboard and click on Run button.

• Here you can see, the default dimension is set to "Time Per Year".

• Now change the dimension value from the list to change the attributes of the reports.

Related links,

Dynamic Column Headers - OBIEE 11g

Double Column Support - OBIEE 11g

Happy stay.. :-)