Navigating Dimensions
Dimension Details
The Dimension Details button is located on the level 2 header of the Dimension screen. Clicking this button displays a table listing all properties under the selected dimension, along with key details such as Property Name, Description, Type, Link To, Property Members, and Where Used.
When viewing an existing property in a dimension, users can click the Trace button to view a list of metrics where that property is used. This includes usage within the Set function of a formula metric, as a cell reference in a metric formula, or inside the Add function of a formula metric.
Users can see details such as the sheet name, metric name, data type, formula, and related dimension. Additionally, there is an option to open any dependent metric in a new browser tab for easy access.
Property Edit Functions
When right-clicking on the dimension member table column header:
- Edit Property: The dimension name and description can be changed when this button is clicked. Additionally, the dimension property type can be changed. When changing the property type, a warning confirmation from the user is required. Changing the dimension property type will clear all existing dimension values. Please note that the Property Name is non-editable.
- Copy Property: The user can copy an existing dimension.
- Insert Left/Right: This function allows the user to add a property in the desired sequence.
- Sort A to Z: The user can sort a dimension in ascending order (alphabetical order).
- Sort Z to A: The user can sort a dimension in descending order (reverse alphabetical order).
- Move Left / Right: This function allows the user to sequence the sorting of property presentation on the table.
- Delete Dimension: This function allows the user to delete the property. Please note that this function is not available for default properties.
v25.05: Special Operations on Scenario Dimension
Scenario type dimensions offer additional functionalities, including copying data to a different version, creating snapshots of data for the current version, and setting time-dependent restrictions on permissible scenarios. We will walk through each of these in detail.
Copy Data
Copying data involves transferring information into an existing version and recalculating all data for the respective version. To copy data, the user can either navigate to the desired sheet and select the copy option from the level 2 header, or go to the Scenario dimension Masterdata and select the copy option there. In either case, a Copy Scenario pane will open on the right.
In this pane, the user needs to select the sheet to be copied, the source version, and the target version. For a particular time period, the user can choose to copy data from the same period, to the next year, to the next period, or set a custom offset. For example, to copy data from the Gross Sales sheet from the Actual version to the Plan version for the year 2024 to the next year.
After clicking Copy, the system will execute the event to copy the data and display the status in the Task Monitor. The copied data will be visible once the copy process is complete.
Create Snapshot
A snapshot captures the state of data at a particular point in time. Data in a snapshot cannot be changed and will not be recalculated if formulas or parameters are modified.
This works similarly to the Version Copy function, but the system will automatically create a new member in the Scenario/Version Snapshot instead of using an existing Version Master.
Like the copy operation, a snapshot can be created in the Sheet version selection on the level 2 header or from the Version dimension masterdata, under the Snapshot tab, using the level 2 option Add Snapshot. The Snapshot Details pane will open on the left. Enter the Snapshot ID and Description, and select the sheet whose data is to be copied. Set the time and version for which the snapshot is to be created.
Applicable From and To
The Applicable from and Applicable to properties in the Scenario type dimension help restrict data calculations in Sheets. These properties are available by default for any new Scenario dimension linked to a Time Dimension. Restrictions on input and calculation for the scenario will be based on TIMEID. The time members selected in the Applicable from and Applicable to periods will determine the range within which users can perform data actions. Outside of this range, the system will:
Note:
NOT allow any data input.
NOT allow any data upload.
NOT generate any results from metric formulas.
NOT copy data to or from that specific period using the Version Copy and Snapshot Creation functions.
v25.11: Lock Versions
Lock specific versions to prevent users from modifying data. When you lock a version, users cannot enter, update, clear, copy data, or run formulas on that version.
Use version locking to protect finalized data in approved actuals, closed budgets, and historical periods. When users attempt modifications, they receive a warning message and the system blocks the operation.
Version locking is managed through the version master data in scenario-type dimensions using a "Locked?" checkbox property.
To lock a version:
Navigate to Master Data from the Dimensions menu.
Select your version dimension (scenario-type).
Locate the version in the master data grid.
Check the "Locked?" checkbox.
Save your changes.
To unlock a version:
Follow steps 1-3 from the above procedure.
Uncheck the "Locked?" checkbox.
Save your changes.
Note: When a version is locked, all modification attempts fail.
For example, if you try to clear data from a locked Actual version, the system displays "Can not Input as Version is locked."
For new installations, scenario-type dimensions automatically include the "Locked?" property with all versions unlocked by default. For existing installations with pre-created scenario dimensions, you need to add the "Locked?" property through dimension configuration before you can use this feature.