Utility Process - Scenario Copy

[Ben Hill]

Posting the Utility Process for copying data between two scenarios in a cube.

Process Source Code

Notes:

• The target cube must have a Scenario dimension (which is a dimension with a type of Scenario).
• Optionally a Measure can be provided.
• Can be further optimised by turning off formula evaluation for the target cube as long as the same formulas are applying to the source and target scenario.

Often we call this process from another process which runs it for across multiple cubes in a model.

Usage:

• This is great for archiving the current forecast or;
• Setting up a new "What-if" scenario.

 

[Wayne Duran]

If you want to filter by a specific dimension, here is an extended version:

Copy Scenario Process Script - Extended

The dimension must exist on the cube for this to work.