Setting Data Extraction Preferences

Extracting Data describes how to extract basic Predictive Planning results to a workbook in tabular form. Data extraction preferences enable you to customize which results to extract.

To set data extraction preferences:

1. In the Extract Data dialog, click Preferences.
2. On the Data tab of the Extract Data Preferences dialog, select the type of data to extract:

   • Results Table—Extracts past or future values, or both, for the members selected for data extraction

   • Methods Table—Lists the best time-series forecasting methods plus any of the following statistical data and information about the forecasting methods used:

     • Accuracy—An estimate of the quality of predicted results

     • Errors—Error statistics for predicted results (RMSE, MAD, and MAPE)

     • Parameters—Displays calculated parameters for the basic forecasting methods and transformational lambda and BIC results for ARIMA methods

     • Ranking—Indicates the prediction ranking of displayed methods, where 1 is best

3. On the Options tab, review and, optionally, modify the following:

   • Location—Indicates whether to write results to a new workbook or the current workbook, and the sheet names to use for the Results table and Methods table

   • Formatting—Indicates whether to automatically format results (AutoFormat selected)

4. When all settings are complete, click OK.