Cube Views

BrowserUX cube views are flexible reporting artifacts that enable cube data to be presented and customized in numerous ways using various configurations and formatting properties, member formulas, and calculations.

Nearly all cube view features provided in the Windows Client are available to users in BrowserUX. For cube views that utilize features or functionality that has not been delivered, or in the case that variations arise due to technical differences inherent in web applications, there may be configuration changes or other workarounds that can be leveraged until subsequent releases close the functional gaps.

Supported Cube View Functionality

Presentation

  • Cube View and Export Format Configuration Properties

  • Cell Data Types

  • Cell Status Background Colors

  • Row and Column Sharing

  • Nested and Expandable Column and Row Headers

Toolbar Functions

  • Context Menu Dropdown

  • Save and Revert Changes

  • Data Refresh

  • Parameter Selection

Cube View and Cell-Level Context Menu Functions

  • Calculate, Translate, Consolidate

  • Data Attachments

  • Spreading

  • Cell Detail

  • Cell POV Information

  • Data Unit Statistics

  • Cell Status

  • Drill Down

  • Row Suppression

  • Export

  • Cube View and Dashboard Navigation Links

Cube View Navigation

The General Visibility setting in Cube View profiles will be applicable for cube views in BrowserUX and the Windows Client (OnePlace, Workflow, and Dashboards). The Client/Device Visibility setting in Dashboard profiles will also affect access to embedded cube views or data explorer components in Dashboards. See Dashboards.

Cube View Drill Down

The Drill Down interface has been moved from a page tab into a slide-out panel in BrowserUX. You can drill down into cube data from a cell intersection by right-clicking the cell and selecting Drill Down from the cube view context menu. The cube view drill down interface opens in a slide-out panel, which can be resized horizontally.

Currently, only the Open in Panel option is supported. The Open in New Tab option will be considered in a future release.

A context menu was also added to the toolbar on the Drill Down page to consolidate some functionality in a way that better supports different screen sizes and devices.

A hidden context menu for drill down has been implemented to consolidate key drill down functions, such as Load Results for Imported Cell and Audit History for Forms or Adjustment Cells.

User Experience Differentiators

In BrowserUX, row and column virtualization has been implemented to efficiently retrieve and render large datasets for cube views. Row and column virtualization retrieves data to display as the user scrolls vertically or horizontally through cube view pages, improving performance of client-side data rendering and enabling a more seamless data review process. Row virtualization occurs in defined Cube View page boundaries.

Notable Functional Gaps

  • Allocation

  • Autofit

    NOTE: BrowserUX uses column widths specified at design time or a default width of 160 pixels when no specific width is defined for a column, or when an asterisk or "Auto" is used to set the width. OneStream will continue to pursue enhancements that better support automatic column width definitions.