Scope Calculations on Sheets

With the 2024R1 Release we now enable you to improve the performance of sheets. We provide a new tab in the Sheet Properties that enables you to set a start and end time for the calculations on each sheet. The sheet performs better when it has fewer cells to calculate.

Watch the Video:

5m 10s

Scope Tab in Sheet Properties

Release: 2024-03-09

We now enable you to improve the performance of sheets by limiting the time period for calculations. We provide a new Scope tab in the Sheet Properties when you're building cube and modeled sheets in the Modeling area. In the Scope tab we enable you to set a start and end time period for the calculations.

See:

Set the Scope for Calculations in Cube and Modeled Sheets.

Concept: Calculation Scope for Modeled and Cube Sheets.

Dynamic Time Periods for Calculations Scope

Release: 2024-03-09

To improve efficiency, we provide dynamic scope ranges so that the scope of the sheet automatically adjusts based on your version settings. We enable you to offset the range based on the:

Completed Values Through period for Actuals data.

Start of Plan period for Plan versions.

See Set the Scope for Calculations in Cube and Modeled Sheets.

Sheet Cell Colors and Notations for Calculation Scope

Release: 2024-03-09

From the sheet view, we display these indicators for cells of calculated accounts that are outside the range of scope:

A purple triangle to indicate the data is formula-driven.

Gray background to indicate that the cell is read-only because it has a formula.

Blank to indicate that the sheet isn’t calculating the data because it’s out of range.

End of Version Field Changes to End of Plan

Release: 2024-05-10

To better align the scope settings with version settings, we change the name of the End of Version field to End of Plan. The functionality remains the same.