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:
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 accuracy 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
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)