Use the Impact window to view the results of data changes in a scenario planning workbook.
The following information is displayed:
Key Metrics—Key metrics associated with an analysis type and scenario. Click a value to go to that cell in the worksheet. If a measure value appears on more than one worksheet, select a worksheet destination.
Key Assumptions—Key assumptions associated with an analysis type and scenario. Click a value open a report sheet containing key assumption data.
Impact Details
If the details are calculating, a set of spinning arrows displays next to Fixed Exceptions, Introduced Exceptions, and Baseline Exceptions.
The system refreshes the window every 30 seconds. The interval is defined in ISServer.properties as
spreadsheet.impact.refresh.interval=30000
Modify the .properties file to meet specific requirements. Oracle recommends that you keep this value at a minimum of 30 seconds.
Fixed Exceptions—Number of exceptions that are resolved due to data changes in the planning workbook. Click Show to view cell locations, and then click a location to go to that cell.
Introduced Exceptions—Number of exceptions introduced by a data change in the planning workbook. Click Show to view cell locations, and then click a location to go to that cell.
Baseline Exceptions—All the exceptions in Integrated Operational Planning up to 50.
Cell Comments—Number of cells in the workbook with comments. Click Show to view comments, cell locations, user names, and time stamps for the comments, and then click a location to go to that cell.
Data Changes—Number of data changes made in the planning workbook. Click Show to view data changes, cell locations, user names, and time stamps for the changes, then click a location to go to that cell.