¶ 1. Overview
Scenario Simulation in T6 is a powerful tool for testing data changes in a controlled way. With it, it is possible to apply variations to existing data in a practical and safe manner, ensuring flexibility in analyses.
However, it is essential to review the parameters before use, as the changes are definitive and directly impact the defined scope.
To prevent errors, when using the simulation tool, make a copy of the scenario you want to simulate and apply the simulation to the copied scenario. After applying the simulation, the data will be changed in the defined scope automatically.
With scenario simulation, we can filter which members will have their data changed, also allowing us to filter the type of attribute of the selected member;
For example:
We can take employee salary values from the year 2025 and simulate a new scenario for the year 2026 where employee salaries have a 10% increase. For this, in the Value step, just add +10% and click Finish;
¶ 1.1. Prerequisites
To use this tool, the user must have the following Manager Feature enabled in Permissions:
It will also be necessary to enable the Preview Feature:
¶ 2. Features
The Scenario Simulation tool allows performing punctual and simulated adjustments to application data. Among its main features, the following stand out:
- Simulation of changes in existing values, with the possibility of adding, subtracting, and applying percentage variations on the data;
- Filtering members (and attributes) of dimensions to apply changes only to specific parts of the data;
- Direct application of modifications in the selected scenario;
¶ 3. Usage
To use scenario simulation, we will follow these steps:
1. In the T6 main menu, expand the Analysis section;
2. In the Analysis section, select the Simulations option;
-
By clicking Simulations, a side panel will open, where we will perform the simulation;
- In the initial step, through a dropdown, we will select the Application in which we will perform the simulation;
- After selecting the Application, the existing dimensions in the selected application will be displayed, where we will perform filtering and/or member restriction;
When defining a member in the Filters/Restrictions step, all other non-defined members will be excluded. If you want the change to be applied to all members, just do not define any member*. This way, the change will be applied to all members of the dimension.
*The Account and Scenario dimensions must necessarily have members defined. It is not possible to proceed without selecting at least 1 member in each dimension;
The aggregation type in the Time dimension must necessarily bring only leaf members;
If the member selection is incorrect, we have different messages to prevent advancement:
After selecting members in the required dimensions, it will be possible to move on to the next step.
3. Click Next to proceed to the next step;
When clicking Next, we will move on to the Value step, where we will make changes to all values within the scope defined in the previous step. We can perform the following actions:
- Addition: To add a value, enter the addition sign (+) followed by the value to be added. For example: +10 to add 10 to the existing values;
- Subtraction: To subtract a value, enter the subtraction sign (-) followed by the value to be subtracted. For example: -10 to subtract 10 from the existing values;
- Percentage Increase: To add a percentage value, enter the addition sign (+) followed by the value to be added, and the percentage sign (%) at the end. For example: +10% to add 10% to the existing values;
- Percentage Decrease: To subtract a percentage value, enter the subtraction sign (-) followed by the value to be subtracted, and the percentage sign (%) at the end. For example: -10% to reduce 10% from the existing values;
In this step, we must necessarily define an operation and a value;
If the value or operation entered is invalid, an informational message will be displayed, preventing progress.
4. After defining the value and operation, click Next to move to the Summary step;
In the summary step, the dimensions will be displayed along with the filters and/or restrictions applied to them, as well as the defined value and operation;
It is important to review the data, as once we click Apply, the changes will be executed.
5. If the simulation execution is successful, a notification will be displayed in the notification panel informing about the processing of the simulation.
- A notification may also be displayed informing about the completion of the execution, but with failures, which can be viewed by expanding the notification message.
In case the simulation execution is taking longer than expected, during the execution process, in the notifications it is possible to cancel the execution by pressing the cancel button next to the progress bar.
The data changed through Simulation can be viewed via Forms within T6.