Edition 11 g, you can use links displayed in
map legends to pass parameters to other
views. By doing this, you can make selections by using the map view and use these
to change the values displayed in associated chart, table, and other views.
In this final example, you will use the
Country and State Map you created previously to drive changes in two other views. To
do this, start by creating two additional analyses that you will later link to the map view.
First create an analysis using the
Products.Product Category, Dim Times
.Month, and Fact Sales.Revenue subject
area columns, and display the results
as a horizontal bar chart. Place Dim
Products.Product Category in the Graph
Prompts area of the graph layout, and
save this analysis to the Presentation
Server catalog, naming the analysis
Then create another analysis, this time
based on the Dim Stores.Country and
State Code, Dim Stores.RegionName,
and Fact Sales.Revenue columns.
Using the Table view that is provided
by default for a new analysis, use the
Layout Editor to move Dim Stores
.Country and State Code to the Table
Prompts area. Save this analysis to the
Presentation Server catalog, naming it
Now you can start to add links between
the map and these new analyses, using
the new master-detail linking feature
introduced in Oracle Business Intelligence
Enterprise Edition 11 g.
To make use of master-detail linking for
these examples, first configure the analysis
containing the map to broadcast master-detail event messages for the Product
Category and Country and State Code
columns and then configure individual
views within the last two analyses you
created to listen for these events:
From the common header menu, select
Open -> Open and navigate to where
DOWNLOAD sample data for this column
you saved the Country and State Map.
Then, with the analysis open for editing,
select the Criteria tab to show the list of
columns used in the analysis.
Move your cursor over the
Category column in the Selected
Columns area, and select Column
Properties from the menu. When the
Column Properties dialog box appears,
select the Interaction tab and then
change the Value Primary Interaction
setting to Send Master-Detail Events.
When the Specify Channel setting
appears, enter MDCAT.
Now repeat the above step for the
Stores.Country and State Code column,
this time entering MDSTATE for the
Specify Channel setting. Then, with
these changes made, save the analysis
back to the Presentation Server catalog.
Setting the map analysis to broadcast
master-detail events is the first part of
this process; the second is to configure
individual views within the target analyses to listen for them. To do this, using
the common header menu, select Open
-> Open, navigate to the Chart Detail
analysis, and select the Results tab to
show the bar chart. Click the Edit View
button for the chart view, and then click
Edit Graph Properties.
Then, in the Graph Properties dialog
box, check the Listen To Master-Detail
Events checkbox and enter MDCAT in the
Event Channel text box. Click OK to close
the dialog box, and then save the analysis
back to the Presentation Server catalog.
Now repeat the previous step for the
Table Detail analysis by editing the table
view within the analysis and clicking
the Table View Properties button to
display the Table Properties dialog box.
Check the Listen to Master-Detail Events
checkbox as before, but this time enter
MDSTATE for Event Channel. This will
ensure that this table view responds to
state and country selections made on
the map. Save the analysis back to the
Presentation Server catalog once you
have finished making the changes.
To view the analyses together and check
that the two detail-level analyses respond
to selections made in the map view, select
Dashboard -> My Dashboard from the
common header menu and use the dashboard editor to add the three analyses to
a new dashboard page, with the map displayed in a section just above the two detail-level analyses, as shown in Figure 2.
Save and then run the new dashboard,
which should look like Figure 2. Move your
cursor over the pie chart displayed over
California, and click the legend to display
the action links. Click the Gifts product category, and watch how the bar chart listens
for and displays your product category
selection. Now click the USA_CA link in the
legend, and see how it changes the values
displayed in the table. You can use map
views to display data with a geographic
component and use map selections to drive
filter value changes in other analyses on
Most business intelligence applications
include an element of geographic data,
and the new integrated mapping feature
in Oracle Business Intelligence Enterprise
Edition 11 g makes it easy to visualize this
data in the form of rich, interactive maps.
With master-detail links, users can connect
map views to other views, creating an interactive query environment built around geographic and other data.
Mark Rittman is an
Oracle ACE director,
cofounder of Rittman
Mead Consulting, and
an executive board
member of the Oracle
Development Tools User Group. He writes for the
Rittman Mead blog at rittmanmead.com/blog.
READ more about Oracle Business
Intelligence Enterprise Edition 11g
Oracle Fusion Middleware System Administrator’s
Guide for Oracle Business Intelligence Enterprise
Edition 11g Release 1 ( 11. 1. 1)
Oracle Fusion Middleware Developer’s Guide for
Oracle Business Intelligence Enterprise Edition
11g Release 1 ( 11. 1. 1)