Merging Scenarios provides flexibility when performing analysis by allowing you to copy data from one or more existing Scenarios into a new or existing Scenario.
You can use this to:
- Actualizing your Forecast by merging your Actuals data into your forecast
- Update the data in your finalized planning and budget Scenarios
Looking to use more of your historical Cube data to generate a scenario? Try out our new AI Smart Forecasting.
Note: Merging scenarios with data over one year may take some time. Cube will email you when the scenario is ready to use.
Merge Scenarios
1. Navigate to Dimensions in the Web portal to open the Dimensions page.
2. Click the +Create button above the Dimensions table, then Scenario Merge.
3. From the Destination Scenario dropdown, select an existing Scenario to merge data into or create a new Scenario by clicking Create New Scenario.
Note: A destination cannot be write protected, write blocked, a formula, or a parent dimension.
4. From the Source Scenario, you will select the Scenario from which you want to copy data. Select any Scenario that is not a formula or a parent dimension.
In the example image below, parent dimensions are gray and cannot be selected, but they can be expanded so you can select a child dimension below it.
5. Select a Date Range for the Source Scenario.
You can select a Time Dimension or choose a custom range to pick a specific start and end date:
Click Add another date range to add any additional date ranges you need.
6. (Optional) Select any additional Source Scenarios by clicking Add another source
7. Click the Save button to process the merge.
Overwrite warning message
8. If there is already data in the Destination Source, you will be prompted with a warning message. Click the Overwrite data button to start the Merge or click the Cancel button to return to the configuration screen.
Email notification when the merge is complete
9. You will receive an email notification after Cube completes the merge process and your updated scenario is ready to use.