Data collection scenarios are similar to a scenarios for what-if analysis, with the addition of data providers. Two workbooks are used in data collection scenarios:
Planning Workbook—Used by the analysis owner, participants, and approvers for what-if analysis to examine the impact of forecast changes sent by data providers. Just as for nondata collection scenarios, you can refresh scenario data, change and recalculate measure values, and review scenario impact.
Data Collection Workbook—Used by data providers for manual entry of updated forecast data. A data collection workbook consists of at least one report worksheet containing current forecast data obtained from the base data in Integrated Operational Planning. Each data provider receives a different version of the workbook that is automatically filtered to display their forecast data.
A data collection workbook includes a hidden load specification used by Integrated Operational Planning to stage and load updated data. Unlike planning workbooks, data collection workbooks cannot be used for what-if analysis. They do not display the Integrated Operational Planning menu, toolbar, or context menus. Data collection workbooks are for manual data entry and updates only.