TD_EXTRACT_RESULTS retrieves auxiliary result sets stored in an ART. There are different auxiliary layers available in an ART that can be retrieved using TD_EXTRACT_RESULTS. The auxiliary layers are as follows:
- ARTPRIMARY contains the primary results returned by the function.
- ARTFITRESIDUALS contains the residual series.
- ARTFITMETADATA contains the goodness-of-fit metrics.
- ARTMODEL shows the validation model context.
- ARTVALDATA is used for the internal validation process.
- ARTCPDATA is used to plot the cumulative periodogram.
The time series functions that produce ARTs that have multiple layers are shown in the table.
The primary layer is retrieved using a SELECT statement, or TD_EXTRACT_RESULTS referencing the ARTPRIMARY layer.
| Function | Layers |
|---|---|
| TD_LINEAR_REGR |
|
| TD_MULTIVAR_REGR |
|
| TD_ARIMAESTIMATE |
|
| TD_ARIMAVALIDATE |
|
| TD_SEASONAlNORMALIZE |
|
| TD_CUMUL_PERIODGRAM |
|
| TD_MAMEAN |
|
| TD_SIMPLEEXP |
|
| TD_HOLT_WINTERS_FORECASTER |
|