Running a Scenario Rollup

After you've defined your scenario rollup structure, business cases, and optionally model characteristics, you can run the scenario rollup.

To run a scenario rollup:

  1. From the Scenario Rollups list, select a scenario rollup, select the root node, and then click Run.
  2. On Run Rollup and Data Maps, select the business case or business cases to roll up.

    By default, the currently selected business case is selected. You can also choose to display only the selected business cases.

  3. If you want to run a rollup even if the model is in Ready status, select Force Rollup.

  4. For each selected business case, select Refresh All or Publish All to run the Refresh or Publish data maps associated with the business case:
    • Refresh data maps bring data into scenario rollups from outside sources, such as a Planning cube or Strategic Modeling models that are not part of the rollup. They are run before the scenario rollup if you select Refresh for the business case.
    • Publish data maps push final rolled up data to external targets, for example, Planning, after a scenario rollup is complete if you select the Publish option for the business case.

    Any Before or After data maps that are associated with the scenario rollup run automatically when you run the scenario rollup.

  5. If you mapped the Business Case in Strategic Modeling to Scenario and Version in Planning, when you run the scenario rollup, you have the option to select Overwrite Target Version, which overwrites the Version defined in the data map.

  6. Click Run.

The scenario rollup is submitted to the Job Console, where you can monitor the progress of the scenario rollup. From the Home page, click Application, and then Jobs. If the scenario rollup process includes data maps, they are shown as child jobs to the scenario rollup job.

When the scenario rollup is complete, you can open the parent model and see the data rolled up from child models.

Note:

If a model is checked out to another user (either in Smart View or on the web), it doesn't prevent you from running a scenario rollup that includes the model.

The scenario rollup creates a new version to hold the results of the rollup. The user with the checked-out model can check their model in over the model created for the scenario rollup. Rerunning the scenario rollup regenerates the results.

Backsolving for Input Values

In some cases, Strategic Modeling calculates input values based on output values:

  • Running a scenario rollup
  • Importing data
  • Changing the level of time detail (either spreading or collapsing)

In cases where the output values would produce an unrealistic input value (a scaled absolute value greater than 10,000 percent or one billion), or when the input value can’t be calculated, then Strategic Modeling performs an actual override (##override), as follows:

  1. During reverse calculation of input values from output values, Strategic Modeling sets the input value to the output value with Actual override selected (##override).
  2. During forward calculation, the override causes the input value to be copied to the output value.