Cube Views

Linked Cube Views and Navigation

Linked Cube Views enable drill-down analysis — users right-click a data cell to navigate from a summary report to a detail view. This guide covers linking configuration, parameter passing, dashboard navigation, and multi-level drill-down patterns.

What Are Linked Cube Views?

A linked Cube View is a secondary Cube View that opens when a user right-clicks a cell in the primary (source) Cube View and selects it from the context menu. The linked view inherits the POV context from the source cell, providing a seamless drill-down experience.
diagramLinked Cube View Drill-Down

Loading diagram...

Configuration

LinkedCubeViews Property

Set the LinkedCubeViews property on the source Cube View to specify which Cube Views appear in the right-click context menu:
plaintext
1LinkedCubeViews = RevenueDetail, ExpenseDetail, BalanceSheetDrillDown
Multiple linked views are separated by commas. Each name references a Cube View in the same or different Cube View Group.

Linking Scope

You can configure linked views at different levels:
LevelDescription
Entire Cube ViewThe LinkedCubeViews property on the Cube View's general settings — available from any cell
Specific rowSet LinkedCubeViews on a row definition — available only from cells in that row
Specific columnSet LinkedCubeViews on a column definition — available only from cells in that column
Row-level and column-level links override the Cube View-level links for their respective cells.

LinkedDashboards Property

In addition to linking to other Cube Views, you can link to dashboards:
plaintext
1LinkedDashboards = EntityDashboard, DrillDownDashboard
Linked dashboards appear in the same right-click context menu alongside linked Cube Views.

Parameter Passing

When a user drills into a linked Cube View, the source cell's context needs to transfer to the linked view. This is handled by bound parameters.

IncludeDefaultNavLinkParameters

Setting IncludeDefaultNavLinkParameters to True automatically passes the standard POV dimensions from the source cell to the linked view:
  • Entity from the source cell's row/column/POV
  • Scenario from the source cell's row/column/POV
  • Time from the source cell's row/column/POV
  • All other standard dimensions
This is the simplest configuration — no manual parameter mapping required. The linked Cube View receives the full POV context and renders accordingly.

How POV Evaluation Works

When a linked Cube View opens, the engine evaluates the source data cell to determine the POV context:
  1. The user right-clicks a cell at a specific row/column intersection
  2. The engine resolves which member each dimension maps to at that intersection
  3. Those members become the POV for the linked Cube View
  4. The linked view renders with the passed POV
For example, if the user right-clicks a cell in the "Houston" row and "Q1 Actual" column, the linked view receives E#Houston, S#Actual, T#2026Q1 (plus all other POV dimensions from the source).
ℹ️Info
If a dimension member in the linked Cube View's POV conflicts with the passed parameter, the passed parameter takes precedence. The linked view's own POV defaults are overridden by the drill-down context.

Multi-Level Drill-Down

Linked Cube Views can chain — the linked view itself can have its own LinkedCubeViews property, creating a multi-level drill-down path:
  1. Level 1 — Summary by Entity (linked to entity detail)
  2. Level 2 — Entity Detail by Account (linked to account detail)
  3. Level 3 — Account Detail by Month
Each level passes its cell context to the next, allowing users to progressively drill from summary to granular detail.
💡Tip
Design drill-down paths around how users analyze data. A common pattern is: consolidated summary → entity detail → account detail → time detail. Each level adds one dimension of granularity.

Navigation from Cube Views to Dashboards

When LinkedDashboards is configured, the linked dashboard receives parameters from the source cell. The dashboard must have matching parameters (using |!Param!| syntax in its components) to consume the passed values.
The flow:
  1. User right-clicks a cell in the Cube View
  2. Selects a linked dashboard from the context menu
  3. The dashboard opens with parameters set from the source cell's POV
  4. Dashboard components bound to those parameters render with the drill-down context
This bridges the reporting world (Cube Views) with the interactive world (dashboards), allowing users to start in a formatted report and drill into a rich dashboard experience.

Rendering Context Behavior

Linked Cube Views behave slightly differently depending on the rendering context:
ContextLinked View Behavior
Data ExplorerFull drill-down — linked view opens in a new tab or panel with interactive capabilities
Report ViewLimited — linked views are not interactive in PDF-style output
Excel/SpreadsheetLimited — right-click context menu may not be available; drill-down is best used in the client
For Excel/Spreadsheet users who need drill-down capabilities, consider providing linked dashboards that open in the OneStream client rather than within Excel.

Related Content