Refreshing Scenario Data

Because the analysis owner and participants can access scenario data simultaneously, data in a planning workbook can become out of date relative to the scenario data. If scenario data is modified by another participant, data in your workbook is updated with the latest scenario data when you switch worksheets or recalculate measure values.

Scenario data also can become out of date relative to the base data in Integrated Operational Planning; for example, when data changes from another scenario are committed to the Integrated Operational Planning database, and if updates to the base data are loaded from your execution database.

When you recalculate measure values, review scenario impact, or submit a scenario for approval, scenario data is checked to determine whether it is out of date. If it is, a warning is displayed. Select an option:

Refresh to See Latest Base Data—Data values in the workbook are updated.
Don't Refresh—Data values in the workbook are updated when you recalculate values. You can continue working with the existing scenario data.

Data changes do not affect the base data in Integrated Operational Planning until the scenario is fully approved.

Tip:	Administrators can schedule batch scripts to run periodically to check if scenario data for In Progress scenarios is out of date relative to base data. Scenario data is then updated, and any necessary calculations are performed.