Utility Process - Scenario Copy

Ben Hill

Administrator
Staff member
Administrator
Joined
Mar 19, 2018
Messages
37
Likes
29
Points
18
#1
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.