SELECT FROM <model>.DIMENSION_CONTENT (DMX)
A mining model can be used as a dimension in an OLAP cube, with each node in the model content representing 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.
Syntax
SELECT [FLATTENED] [TOP <n>] <expression list> FROM <model>.Dimension_CONTENT
[WHERE <condition expression>]
[ORDER BY <expression> [DESC|ASC]]
Arguments
- n
Optional. An integer specifying how many rows to return.
- expression list
A comma-separated list of related column identifiers derived from the Content schema rowset.
- model
A model identifier.
- condition expression
Optional. A condition to restrict the values that are returned from the column list.
- expression
Optional. An expression that returns a scalar value.
Remarks
Algorithm providers define which content is returned, and how to organize it. For example, the provider may 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 |
|---|---|
ATTRIBUTE_NAME |
Member property. |
NODE_NAME |
Member property. |
NODE_UNIQUE_NAME |
Key attribute. |
NODE_TYPE |
Member property. |
NODE_CAPTION |
CaptionColumn for Key attribute. |
CHILDREN_CARDINALITY |
Member property. |
PARENT_UNIQUE_NAME |
RelatedAttribute for Key attribute (ParentAttribute in parent-child hierarchy). |
NODE_DESCRIPTION |
Member property. |
NODE_RULE |
Member property. |
MARGINAL_RULE |
Member property. |
NODE_PROBABILITY |
Member property. |
MARGINAL_PROBABILITY |
Member property. |
NODE_SUPPORT |
Member property. |
Examples
Description
The example selects all columns from the [TM Decision Tree] model content that pertain to using the model as a dimension.
Code
Select *
From [TM Decision Tree].Dimension_Content
See Also
Reference
SELECT (DMX)
Data Mining Extensions (DMX) Data Definition Statements
Data Mining Extensions (DMX) Data Manipulation Statements
Data Mining Extensions (DMX) Statement Reference