Export (0) Print
Expand All

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.

SELECT [FLATTENED] [TOP <n>] <expression list> FROM <model>.Dimension_CONTENT 
[WHERE <condition expression>]
[ORDER BY <expression> [DESC|ASC]]

n

Optional. An integer that specifies 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.

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

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.

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
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft