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. :-)

Send Master-Detail Events in OBIEE

Master-detail linking of views:

Master-detail linking of views enables you to establish a relationship between two or more views such that one view, called the master view, drives data changes in one or more other views, called detail views.

For example, suppose you have the following two views:

• A table that shows Dollars by "Per Name Year"
• A graph that shows Dollars by LOB with "Per Name Year" on a section slider

Using the master-detail linking functionality, you can link the two views so that when you click a particular "Per Name Year" in the table, the "Per Name Year" on the section slider of the graph as well as the data in the graph changes to reflect the "Per Name Year" that was clicked on the table. 

For example, clicking 2008 in the table in the "Per Name Year" column, positions the thumb in the section slider on 2008 and updates the data in the graph to the data for 2008.

Note: Master-detail linking is not supported when you click the plot area of a graph.

What Are Master Views actually?

A master view drives data changes in one or more detail views. A view becomes a master when you set up the interaction of a column in the view to send master-detail events on designated channels. This column is known as the master column.

The master column is the column whose values when clicked send a master-detail event, which passes information to update the data in a detail view.

A master view can be in the same analysis as the detail view or in a different analysis. A master view can update data in one or more detail views.

The following types of views can be master views:

• Graph
• Funnel graph
• Gauge Map
• Pivot table
• Table
• Trellis (only the outer edges, not the inner visualizations)

What Are Channels?

A channel links a master view to a detail view. It is the vehicle that carries master-detail events from the master view to the detail view. The same channel must be used for both the master view and the detail view in a master-detail relationship, for example, PassYear. Note that the channel name is case sensitive.

What Are Detail Views?

A detail view is a view that listens for and responds to master-detail events sent by a master view on a specified channel. A view becomes a detail view, when you set up the view to listen to master-detail events.

A detail view includes one or more columns whose values are changed directly by the information passed by a master-detail event. These columns are known as detail columns.

A detail view can:

• listen for master-detail events from multiple master views
• be in the same analysis as the master view or in a different analysis
• not act as a master to another view

Say for example, we'll take above scenario.

• Go to criteria of the above example.
  
• Go to column properties of "Per Name Year"
  
• Move to Interaction tab of the column properties.
  
• In Primary Interaction, select Send Master-Detail Events and Specify Channel name for this master detail event.
  
• Click OK.
• Move to the Results section of the analysis.
• Click an Edit mode of the bar graph view.
• Move "Per Name Year" to Sections and select "Display as Slider".
  
• Now click Edit Graph Properties button of the graph.
  
• Select Master-Detail check box, the Text Box for Event Channels will get enabled.
• Remember the channel we have defined in previous step. i.e. PassYear
  
  
• Click OK.
• Click Done to return to the analysis page.
• Now you can select any of the value for Per Name Year column in this analysis, the corresponding details report i.e. here Bar Graph View will get changed.

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.. :-)