How to: View the Formula for a Time Series Model (Analysis Services - Data Mining)
The Microsoft Time Series viewer in Data Mining Designer provides the easiest way to view the details of the regression equation used in a time series model.
You can extract the regression formula for a time series model by querying the model content. However, to view the complete ARTxp or ARIMA formula, we recommend that you use the Mining Legend of the Microsoft Time Series Viewer, which presents all the constants in a readable format.
ARIMA and ARTxp share the same model parent, but the structures in the ARIMA and ARTxp parts of a mixed model are very different. One important difference is that ARTxp represents an actual tree structure, but ARIMA does not. Therefore, although the two representations are presented in one model for convenience, they should be treated as two independent models. The equations are also completely different and cannot be combined or compared.
You can also view time series models by using the Microsoft Generic Content Tree Viewer. However, in a mixed model the information is complex and can be difficult to interpret. For more information about the content of a time series model, see Mining Model Content for Time Series Models (Analysis Services - Data Mining).
To view the ARTxp regression formula for a time series model
In SQL Server Management Studio, select the time series model that you want to view, and click Browse.
-- or --
In Business Intelligence Development Studio, select the time series model, and then click the Mining Model Viewer tab.
Click the Model tab.
If the model contains multiple trees, select a single tree from the Tree drop-down list.
Note
A model will always have multiple trees if you have more than one data series. However, you will not see as many trees in the Time Series viewer as you will see in the Microsoft Generic Content Tree Viewer. That is because the Time Series viewer combines the ARIMA and ARTxp information for each data series into a single representation.
Click any leaf node in the tree.
Nodes that are labeled as Data Series are always leaf nodes and can contain an equation. If an (All) node has no child nodes, it can also contain an equation.
If the Mining Legend is not available, right-click the node, and select Show Legend.
The ARTxp formula is displayed in the first half of the Mining Legend, as the Tree node equation.
To view the ARIMA formula for a time series model
In SQL Server Management Studio, select the time series model that you want to view, and click Browse.
-- or --
In Business Intelligence Development Studio, select the time series model, and then click the Mining Model Viewer tab.
Click the Model tab.
If the model contains multiple trees, select a single tree from the Tree drop-down list.
Note
The model will always have multiple trees if you include more than one data series.
Click any node in the tree.
The ARIMA formula is displayed in the second half of the Mining Legend, as the ARIMA equation.
If the Mining Legend is not available, right-click the node, and select Show Legend.