IsDescendant (DMX)
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 descendents 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)