Linking Presentations is a sample application that demonstrates how to link
queries and selections between views (for example, crosstab, table and
graph). It connects to Oracle9i OLAP (the source of the business data
for the application) and to the BI Beans Catalog (where object definitions,
like crosstabs and graphs, are saved).
The Linking Presentations sample allows the user to control the following options:
What views to link
Crosstabs, tables, and graphs can be linked together in a variety
of combinations
Relationships
Bi-directional
If a view is changed, all other linked views are changed
Master/Detail
If a master view is changed, all detailed views are changed
Changes to the detail view are not reflected in the master
UI Action
Users are allowed to perform Page, Drill, Pivot, and Selection
Change operations
Selections
All Dimensions (i.e. by query)
Specified dimensions (i.e. by selection)
If you have not already done so, you must perform several installation
and configuration tasks, then open the workspace javaclient\javaclient.jws
under the samples
directory within JDeveloper. All the necessary
files for this sample can be found in the linking_presentations.jpr
project under the javaclient.jws
workspace.
BILinking provides a menu with access to a simple connection dialog that prompts a user for security credentials. It then makes the two connections described above.
After the connection is established, various combinations of linked views can be created from the 'Views' menu option. All linked views currently default to Bi-Directional/All dimensions. The Views menu contains the following choices:
Crosstab-Table
Crosstab-Graph
Graph-Table
Crosstab-Table-Graph
The view menu also supports the ability to toggle the first selection associated with Master dataview between various types of steps (for example, AllStep or FirstLastStep). This is useful for generating 'Selection Change' UI Actions described below.
The right mouse button can then be used to select various link options based
on the dimensions chosen:
To help simplify the ability to see the relationships defined between between various dimension, we apply an italic font if the dimension is linked and add a bold font if the link is bi-directional or part of the master view.
Issues:
Formatting with rule bundles is supported only in Table and Crosstab, but not in Graph
Measures associated with the Table cannot be formatted
The following table shows the expected behavior of different combinations of Relationships, UI Actions and Selections:
Relationship: Bi-Directional
UI Action |
Selections |
|
---|---|---|
All Dimensions [Linked by Query - Default] |
Selected Dimensions [Linked by Selection(s)] |
|
Page |
Changes are automatically sent to all views by shared Query |
Master page operation is performed on all detail views by simply applying
the Master's current page slice to each Detail view. |
Drill |
Changes are automatically sent to all views by shared Query |
Drill is performed on all views for linked dimensions |
Pivot |
Changes are automatically sent to all views by shared Query |
Ignored |
Selection Change |
Changes are automatically sent to all views by shared Query |
Selection is applied to all views for linked dimensions |
Note: Since linked by Query, any changes made to one view are automatically
reapplied to (i.e. re-synced with ) others. |
Note: A QueryListener must listen for events associated with each linked
dimension UI Action and be able to apply them to each linked view. |
Relationship: Master/Detail
UI Action |
Selections |
|
---|---|---|
All Dimensions [Linked by Query] |
Selected Dimensions [Linked by Selection(s)] |
|
Page |
Master page operations are performed on all detail views for all dimensions |
Master page operation is performed on all detail views for linked dimensions
by attempting to find the Dimension/Dimension member chosen in each detail
view. |
Drill |
Master drills are performed on all detail views for all dimensions |
Master drill is performed on all detail views for linked dimensions by
applying master selection without clearing drill steps. |
Pivot |
Master pivot operations are performed on all detail views for all dimensions |
Ignored |
Selection Change |
Master selection is applied to all detail views for all dimensions. |
Master selection is applied to all detail views for linked dimensions. |
Note: Detail views are disabled. |
Note: Changes to Detail views do not affect the master. |
Relationship: Remove (None)
Each view's query is cloned to remove any existing links
This table shows the QueryListener events that are fired for different combinations of Views and UI Actions
View: Crosstab
Page |
Drill |
Pivot |
Selection |
---|---|---|---|
viewDataChanged (DataChangedEvent) |
drillRequesting (DrillRequestingEvent) |
layoutChanged (LayoutChangedEvent) |
selectionChanged (SelectionChangedEvent) |
DataChangedEvent.PAGE_CHANGE |
drillRequested (DrillRequestedEvent) |
viewDataChanged (DataChangedEvent) |
viewDataChanged (DataChangedEvent) |
viewDataChanged (DataChangedEvent) |
DataChangedEvent.PIVOT_CHANGE |
DataChangedEvent.SEL_CHANGE |
|
DataChangedEvent.DRILL_CHANGE |
View: Table
Page |
Drill |
Pivot |
Selection |
---|---|---|---|
viewDataChanged (DataChangedEvent) |
N/A (not available for relational projections) |
layoutChanged (LayoutChangedEvent) |
selectionChanged (SelectionChangedEvent) |
DataChangedEvent.PAGE_CHANGE |
viewDataChanged (DataChangedEvent) |
viewDataChanged (DataChangedEvent) |
|
DataChangedEvent.PIVOT_CHANGE |
DataChangedEvent.SEL_CHANGE |
View: Graph
Page |
Drill |
Pivot |
Selection |
---|---|---|---|
viewDataChanged (DataChangedEvent) |
drillRequesting (DrillRequestingEvent) |
N/A (only available through layout panel) |
selectionChanged (SelectionChangedEvent) |
DataChangedEvent.PAGE_CHANGE |
drillRequested (DrillRequestedEvent) |
viewDataChanged (DataChangedEvent) |
|
viewDataChanged (DataChangedEvent) |
DataChangedEvent.SEL_CHANGE |
||
DataChangedEvent.DRILL_CHANGE |
Graph
No ability to add layout panels directly through graph (for example, cannot display Series and Group)
Default 'Paging Item' controls and drilling off
Does not support pivoting of 'Page Items'
Formatting
Does not support rule bundles
Crosstab and Table
Formatting
Crosstab (cube) and Table (relational) measure QDRs differ
This affects the ability to apply rule bundles (for example, bold or italic) to measure dimension members within a table
To run the BILinking example within JDeveloper, simply right click on the file BILinking.java and choose Run BILinking.java. From the File Menu in the application, choose Connect and enter the username and password of the user that owns the BI Beans Catalog (e.g. BIBCAT).
![]() |
|
---|---|
Copyright © 2002, 2003 Oracle. All Rights Reserved. |
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. |