SELECT FROM <model>.DIMENSION_CONTENT (DMX)
A mining model can be used as a dimension in an OLAP cube, where each node in the model is represented as a member of the dimension. The SELECT FROM <model>.Dimension_CONTENT statement returns the content of the model that pertains to its usage as a dimension.
Algorithm providers define which content is returned, and how to organize it. For example, the provider might limit the number of nodes that are described in the dimension content.
The following table lists the columns that can be queried for the dimension content, and the function that each column performs as a data mining dimension.
CONTENT rowset column
Function in data mining dimension
CaptionColumn for Key attribute.
RelatedAttribute for Key attribute (ParentAttribute in parent-child hierarchy).
The example selects all columns from the [TM Decision Tree] model content that pertain to using the model as a dimension.