Edit

Share via

IsDescendant (DMX)

  • Article

Applies to: SQL Server Analysis Services

Indicates whether the current node descends from the specified node.

Syntax

  
IsDescendant(<NodeID>)

Return Type

A Boolean type.

Remarks

IsDescendant is only used in SELECT FROM <model>.CONTENT (DMX) and SELECT FROM <model>.DIMENSION_CONTENT (DMX) queries.

Examples

The following example returns all the cases that are descendants of the node that is specified in the IsDescendant function.

SELECT * FROM [TM Decision Tree].CONTENT  
WHERE IsDescendant('00000000100')

See Also

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
General Prediction Functions (DMX)