Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Multi-Select Levels and Dimensions on Modeled Sheets

Multi-Select Levels and Dimensions on Modeled Sheets

Preview Date: 2026-02-07. Production Date: 2026-03-27.
With this release, we enable end users to select multiple levels and dimensions within a dashboard filter to view an aggregation of data on modeled sheets. Previously, users were limited to viewing 1 level at a time or selecting a high-level parent and scrolling through irrelevant data.

Business Benefits

  • Users can quickly slice and dice data across multiple levels and dimensions without manual input, significantly speeding up the discovery of insights.
  • The ability to select multiple specific dimensions provides greater control over the data displayed, allowing users to tailor dashboards to their exact analytical needs rather than relying on pre-defined views.
  • The improved user experience aligns the behavior of modeled sheets with dashboard graphs, which already support multi-select, providing a consistent and intuitive interface.

Changes

We now enable you to select multiple values in the dashboard filter for:
  • Dimensions.
  • Unlocked levels.
When you select multiple unlocked levels in the filter, we now automatically display:
  • A
    Level
     column on the left side of the sheet to indicate which level a row belongs to.
  • A toast to visually indicate that you selected multiple levels.
When you select 1 or more unlocked leaf levels, we now enable you to edit those rows.
When you include a roll-up level in your multi-selection, we respect the
Allow editing while viewing rollup levels
 setting in your modeled sheet properties. When you include a roll-up level and leaf level together in your multi-selection, we automatically unlock your sheet regardless of this setting.
When you add a new row after selecting multiple values in the filter, we now automatically select the first level within the filter as your default level.

What Do I Need to Do?

To enable your users to edit at roll-up levels, enable the
Allow editing while viewing rollup levels
 setting in your modeled sheet properties.

What Happens if I do Nothing?

If you do nothing, your dashboards will continue to function as they do today. Users can continue to select single levels or dimensions. The multi-select capability will be available whenever they choose to use it.

Change Log

Multi-Select Levels and Dimensions on Modeled Sheets
We update the delivery dates for the Production delivery for this functionality from 2026-03-14 to 2026-03-27.