View the Formula for a Time Series Model (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.
If you create a mixed model, the ARIMA and ARTXP analyses are created in separate trees, joined at the root node representing the model. The structures of the ARIMA and ARTXP trees are very different. For example, the ARTXP tree is in fact a tree structure, like a decision tree, whereas the ARIMA tree represents a series of moving averages. 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. 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 SQL Server Data Tools (SSDT), 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 SQL Server Data Tools (SSDT), 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.
See Also
Concepts
Browse a Model Using the Microsoft Time Series Viewer
Time Series Model Query Examples