Interactions in Views

You can specify which interactions are available when users:

Click in a data view. See "Click Interactions in Views".
Right-click in a table, pivot table, or trellis view at runtime. See "Right-Click Interactions in Views"

Click Interactions in Views

You can specify which interactions are available when users click (that is, left-click) in a data view. The following types of interactions are available:

None — Specifies that nothing happens when users click the column heading or a value. This option turns off drilling for attribute columns; it does not turn off drilling for hierarchical columns.
Drill — Enables users to drill down to more detailed information. See "Drilling in Views".
Action Links — Enables users to click a hot spot in a data view and then select an action link to execute an action, such as navigating to a saved analysis or invoking an Enterprise Java Bean (EJB). See Chapter 10, "Working with Actions."
Send Master-Detail Events — Sends master -detail events in a master-detail relationship. See "What Is Master-Detail Linking of Views?" and "Linking Views in Master-Detail Relationships".

You specify which left-click interactions are available at the criteria level using the "Column Properties dialog: Interaction tab". These left-click interactions take effect in all data views.

Note:

You specify runtime interactions for views (for example, sort or move) by using the "Analysis Properties dialog: Interactions tab".

How Will Interactions Created in Views in Previous Releases Be Upgraded?

In previous releases (prior to 11g) of Oracle BI EE, you could set up interactions at the view level. In this release, you specify all left-click interactions at the criteria level. For more information, see "Upgrading Interactions in Views" in Oracle Fusion Middleware Upgrade Guide for Oracle Business Intelligence.

Right-Click Interactions in Views

You can specify which interactions are available when users right-click in a table, pivot table, or trellis view at runtime. The following right-click interactions are available:

Drill (when not a primary interaction)
Move Columns
Sort Columns
Add/Remove Values
Create/Edit/Remove Groups
Create/Edit/Remove Calculated Items
Display/Hide Sub-totals
Display/Hide Running Sum
Include/Exclude Columns
Hide Columns

You specify which right-click interactions are available at the analysis level using the "Analysis Properties dialog: Interactions tab". These right-click interactions take effect in table, pivot table, and trellis views at runtime.

Note:

Most right-click interactions are not available for graphs in trellis views (Simple Trellis and Advanced Trellis). You can, however, include actions links as right-click interactions for graphs in trellis views. In addition, right-click on text is allowed, meaning the user can right-click on text in a trellis view in the same manner as in a pivot table view. This includes data cells in an advanced trellis that have Visualization set to Text.

Best Practice:

Include the selection steps view when using right-click interactions to track which steps and constraints have been applied. See "Working with Selections of Data" for additional information.