Cube Views

Cube views are flexible reporting artifacts that enable cube data to be presented and edited in various ways by utilizing security, configuration, and formatting properties, member formulas, and calculations.

Nearly all cube view features provided in the Windows Application are available to users of the Modern Browser Experience. For cube views that utilize features or functionality that have not yet been implemented, or in cases when variations arise due to technical differences between desktop and web-based applications, there may be configuration changes or workarounds that can be leveraged until functional gaps can be closed.

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 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. 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

Row virtualization has been implemented to efficiently retrieve and render large datasets for cube views. Row virtualization retrieves data to display as the user scrolls vertically 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: The modern browser experience uses column widths specified at design time, or a default width of 160 pixels when no specific width is defined for a column, or will autofit the column when "Auto" is used to set the width.