Dashboards

CubeView and BI Viewer Components

CubeView and BI Viewer components are the primary data display components in OneStream dashboards. CubeViews render tabular reports directly from a stored CubeView definition. BI Viewers provide a richer analytics experience with charts, pivot tables, and interactive filters — powered by the BI Designer.

CubeView Component

A CubeView component renders a stored CubeView on a dashboard. The component is bound to a CubeView-type data adapter, which references the stored CubeView by name. The CubeView's POV (Point of View) can include |!Param!| syntax so the report changes dynamically based on user selections.

Properties

PropertyDescription
Data AdapterMust be a CubeView-type adapter referencing a stored CubeView
DisplayFormatControls the visual presentation of the report
IsVisibleShow or hide the component. Supports |!Param!| for conditional visibility
IsEnabledEnable or disable user interaction with the report
Action propertiesSame action model as Buttons — server tasks, UI actions, DashboardsToRedraw

CubeView Example

A revenue report driven by dashboard parameter selections.
CubeView Adapter — RevenueAdapter:
  • CubeView Name: RevenueSummary
  • POV: E#|!EntityParam!|:S#|!ScenarioParam!|:T#|!TimeParam!|
When the user changes the Entity ComboBox (bound to EntityParam), the dashboard refreshes, the POV resolves with the new entity, and the CubeView re-renders with updated data.
diagramCubeView Data Pipeline

Loading diagram...

ℹ️Info
The stored CubeView defines the row and column structure (which accounts, which time periods, what layout). The dashboard parameters only affect the POV dimensions that filter the data. This separation means you can reuse the same CubeView in multiple dashboards with different parameter configurations.

BI Viewer Component

The BI Viewer is a more powerful data visualization component that supports charts, pivot tables, grids, and interactive filters. It works with multiple adapter types and provides a drag-and-drop BI Designer interface for configuring the visual layout.

Adapter Binding

The BI Viewer supports all adapter types:
Adapter TypeUse Case
CubeViewStandard CubeView data for simple charts and grids
CubeViewMDMulti-dimensional data with flattened hierarchies for pivot analysis
SQLCustom SQL queries for relational data visualization
CustomBusiness Rule-driven data for complex or computed datasets

Parameter Integration

The BI Viewer has two parameter-integration mechanisms:
  • Inbound — Component Properties → Parameter Name Value Pairs. Passes dashboard parameter values into the BI Viewer's internal data source configuration.
  • Outbound — Action Name Value Pairs / Bound Parameter. When a user clicks on a chart element or grid row, the BI Viewer writes the selected value to a BoundParameter or triggers an action.

BI Designer

The BI Designer is a drag-and-drop interface for configuring what the BI Viewer displays. Within the BI Designer, you can add:
  • Charts — Bar, line, pie, area, scatter, and other chart types
  • Pivot tables — Multi-dimensional data with draggable row/column/filter fields
  • Grids — Tabular data display with sorting and filtering
  • Filter elements — ComboBox, ListBox, and TreeView filters internal to the BI Viewer (distinct from dashboard-level components)
💡Tip
The filter elements within a BI Viewer are independent from dashboard-level ComboBoxes and ListBoxes. BI Viewer filters only affect the data within that specific BI Viewer — they do not write to dashboard parameters. Use dashboard-level ComboBoxes when you need the selection to affect multiple components.

BI Viewer Example

A CubeViewMD adapter feeding a BI Viewer with a pivot grid and chart for entity-level financial analysis.
CubeViewMD Adapter — EntityAnalysisAdapter:
  • References a CubeView that returns multi-dimensional entity data with flattened hierarchies
  • Account, Entity, and Time dimensions become separate columns in the DataTable
BI Viewer — BI Designer configured with:
  • A pivot grid with Entity on rows, Time on columns, and Amount as the value field
  • A bar chart bound to the same data source showing Entity-level comparison
diagramBI Viewer Data Flow

Loading diagram...

Action Properties on Data Display Components

Both CubeView and BI Viewer components support action properties triggered by cell or item selection. This uses the same model as Buttons:
  • A user clicks a cell in a CubeView or a data point in a BI Viewer chart
  • The server task fires (if configured)
  • The UI action executes
  • DashboardsToRedraw refresh
This enables drill-down patterns — clicking a revenue total in a summary CubeView can trigger a server task that sets parameters for a detail dashboard, then opens that dashboard in a dialog.

Related Content

  • Data Adapters — Adapter types, binding, and configuration
  • Configuring Cubes — CubeView POV and member filter syntax in cube context
  • Parameters and Syntax — |!Param!| substitution in CubeView POV
  • Buttons — Shared action property model for component interactions
  • PivotGrid — Standalone drag-and-drop pivot analysis (vs BI Viewer internal pivot tables)
  • Cube View Fundamentals — Standalone Cube View design, object hierarchy, and rendering locations
  • Cube View Calculations — Calculated rows/columns, GetDataCell expressions, CVC/CVR math, and Custom Member Lists