Create a simulation

In the “Simulation” filter, select “New simulation”.

In the pop-up:

• Label: name of the simulation;
• Start date: start of the simulation;
• End date: end of the simulation;
• Diffusion coefficient: allows the different calculations to be weighted (the coefficient is repeated on each product line);
• Take into account data: real (only real data is taken into account for calculations) / real and fictitious (real and fictitious data is taken into account for calculations);
• Take into account sell out/sell in data:
  • of the last X periods (by default, maximum 13, but it is possible to change the maximum by contacting the support service): corresponds to the number of sell out/sell in data which will be taken into account and averaged;
  • between dates: only sell out/sell in data between dates will be taken into account and averaged;

• Create simulation from: select Obj, Acc or Att, then a period. This initializes the scenario strata of each product from the selected item.

After creating and selecting the simulation in the filter, select one or more brands (by default, 16 maximum), then filter.
A first scenario, named "Scenario 1", is created and is set as a default favorite.

Share a simulation

In the simulation creation/modification pop-up, the "Sharing" tab allows you to give read-only access to the simulation to other users.

In the table, select a role so that all linked users are automatically selected, or specifically select the users you want to share the simulation with, then save.

When a first user shares a simulation to a second user, the second can see the shared simulation in the simulations list with the icon

It is then possible for the second user to select it to view the data in read-only mode, no modification is possible:

Edit & delete a simulation

In the "Simulation" filter, click on the button of the simulation you wish to modify. It is then possible to modify the label of the simulation, the start and end dates of the simulation, the number of periods or the start and end dates, as well as the data to be taken into account and to modify the users to whom it is shared.

You can also delete the simulation.

Edit & Create a New Scenario

By hovering over the label of the active scenario, it is possible to click on the button to open the scenario details pop-up. This allows you to modify the scenario label, indicate whether it is a favorite or not and view the number of products whose scenario stratum is different from the current stratum, by brand:

To create a new scenario, click the button located at the top right of the table.
In the pop-up, enter the name of the new scenario, whether it is a favorite or not, then choose from which item to initialize it before saving:

When you create a new scenario from an existing scenario, the new scenario takes over the table state (filters, sorting, grouping, etc.) of the existing scenario.

Working on a scenario

For each brand, it is possible to modify the scenario stratum, the movement date, the DV ranges, the diffusion coefficient. In the list of columns, you also have access to 6 free coefficients, the sales volume, sales value, the DV as well as the brand attributes of the number type. All are modifiable and saved in the scenario.

Make the desired changes (they are then displayed in dark blue, except for the scenario layers), then click on the button to save changes and refresh calculations:

For more details on the Simulation module calculations, see the associated sheet .

Some columns include a color code to allow you to quickly analyze gains and losses: if the value is positive, the cell frame is green, if the value is negative, the cell frame is red:

For the “Scenario Strata” column, if a scenario stratum is different from the current stratum, it is displayed in orange .

Analyze different scenarios

Select multiple products or all products using the check boxes and then click the button
The different scenarios are then compared with the simulation initialization item (e.g. Acc 2024). This allows you to compare the current situation with the different scenarios:

The graphs are made on a base of 100. For each KPI, the best scenario is equal to 100, and the other scenarios are weighted to the best scenario.
The table at the bottom of the screen highlights the best scenario. For each KPI, the best scenario is displayed in green. The left part of the table corresponds to the total for all brands, while the left part allows you to analyze the KPIs by brand.

Apply a scenario

Once the best scenario is chosen, it is possible to apply it to the SEO (Obj, Acc or Att). To do this, select the desired products using the check boxes, then click on the button
Select the relevant brands, then select which reference item to copy the scenario data to.

If you select "Acc", you can then choose to create an agreement:

• Depending on the different start dates entered in the simulation (you just need to enter the wording of each agreement);
• On a date for all products (you must then enter the wording of the agreement and select a date).

Aggregate scenario data

Reporting 3 allows you to aggregate data from different scenarios to compare them to the reference. To do this, select a period, different scenarios in the pop-up as well as the default reference:

Then click the Apply button.
If in the different scenarios selected, some deal with the same brand, it will then be necessary to select for each brand which scenario to take into account:

After loading, a new column "Scenario" is added to the table. It aggregates the data of the different scenarios selected to the default reference:

You can then use the brand breakdown pop-up to analyze a product, or unfold the circuit to see the DN/DV movements on each brand.