MarcR
VIP

First of all, please note that the solution Scenario Analysis 123 is not intended for full Entity or multiple-hierarchy consolidations spanning multiple periods or years. Therefore, it is mainly designed for power users and accessible via a dashboard instead of the user-workflow.

Want to know how to implement and use Scenario Analysis in  OneStream? We’ll take you through the process in 4 steps:

Step 1. Configure Scenario Analysis 123 in OneStream

Just like most other Market Place solutions, Scenario Analysis requires Ancillary Table access. If you don’t have this set up yet, you can follow the steps described in the setup instructions document. Do you have other solutions running already? Then this is not required anymore.

After downloading the solution as a .zip file from the Market Place, you can import it in your application via Application -> Load/Extract. After that, the Scenario Analysis (SAM) will appear under OnePlace -> Dashboards. Here, you can create the tables and then launch the solution:

 

1.png

Don’t forget to decide who has access to the Scenario Analysis solution. You can do this in the global options. After that, you’re ready to go.

After launching the solution, the homepage contains 3 items: Setup, Execute, and Analyze.

2.png

Each of these items has its own function:

  • Setup: Create and maintain scenario definitions, rule sets, and rules.
  • Execute: Execution and maintenance of calculation jobs.
  • Analyze: Chart and pivot grids to review the results.

Step 2. Set up definitions in OneStream Analysis 123

The next step is to set up the definitions in Analysis 123. You begin by creating a new definition that consists of a Source and Target Scenario for a specific cube and you do this on the setup page.

 

3.png

You can create a new definition via a pop-up with the following fields:

 

4.png

There are a few things to pay attention to during this step. First of all, please note that the checkbox ‘Copy All Rule Sets and Rules from Source’ only applies to Scenario Analysis. For example, this checkbox will not copy member formulas or business rules. Only existing Scenario Analysis definition rule sets and rules are copied.

Also, the selected Source and Target Scenario must have the same settings. It is not (yet) possible to copy from a yearly scenario to a scenario with a predefined period range or one that uses extensibility if the Source scenario doesn’t.

After creating the definition, the scenario is made in the metadata:

 

5.png

However, if you delete the definition, you must manually delete the scenario from the Dimensions.

Using rule sets in OneStream Scenario Analysis 123

A Scenario Analysis Definition contains rule sets. A rule set is a collection of rules that can be applied to the target scenario. You can order a rule set with a sequence and set it active/ inactive. The Collapse Data option will put all data on the Import member in the origin dimension. This feature is useful if overrides via forms are required on the created Target Scenario.

 

6.png

The next level consists of the actual rules that need to be executed. Scenario Analysis Rules are a collection of percentage values tied to a specific dimension and time range. You can apply member filters for each dimension, except for Origin.

 

7.png

Existing rules can be copied as a starting point for a new row, for example, with a new account. There is also an option to apply a fixed percentage for all 24 periods at once. However, this option can be overwritten.

 

8.png

After finalizing the rules, you can apply them to the new target scenario via the apply button:

9.png

Every time a rule is changed, this must be re-applied.

The apply button will create a member formula on the new Target Scenario:

 

11.png

If you are interested in the techniques applied, you will be disappointed: OneStream decided to encrypt all the business rules involved in this solution. However, the solution does include a CustomEventHandler that can be loaded as a business rule to allow some customizations to the solution. This is included in the dashboard files, where it can be saved and then re-imported. You’ll find the required adjustments described in detail in the setup document. The script already contains events where you can enter your customized code.

 

12.jpg

Step 3. Execute definitions in OneStream Analysis 123

After configuring the tool and implementing the definitions, it’s time to execute the definitions. A calculation job needs to be created on the Execute screen within the existing definition to execute the member formula.

The documentation alerts for performance impact, so this is the part where you need to limit your consolidation/ calculation scope. In my case, I executed a 12-month force calculate for 1 entity:

 

13.png

After saving the Calculation Job, you can start it via the run button. After a few moments, the results are ready to be analyzed.

 

14.png

Step 4. Analyze results in OneStream Analysis 123

When the calculation is finished, you can review the results in the included dashboard. Here, you can enter the definition, Entity, Account, and period selection to show different Source and Target Scenario visualizations.

 

15.png

Also, there is an option to do further analysis using the Pivot option:

 

16.png

Conclusion

The new OneStream Scenario Analysis 123 is a great way to create various scenarios to compare against your current figures quickly. It allows a key user to quickly generates different scenario’s and compare them against each other. Unfortunately in this first release it is not yet possible to dynamically calculate the percentages for the future periods from a driver or a calculation. When that is added this is a must have for every planning solution in OneStream.

Pros of OneStream Scenario Analysis 123:
+ Easy and user-friendly way to set up calculated variance scenarios
+ Dashboard and Pivot functionality included
+ Quickly copy Definitions to change your

Cons of OneStream Scenario Analysis 123:
– Not yet possible to use dynamic drivers as input for the percentages

The setup is described in detail in the documentation, and the configuration can be done quickly. Therefore, I classify this solution as Admin Configurable. Please see my earlier post about classifications.