IsDescendant (DMX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Indicates whether the current node descends from the specified node.



Return Type

A Boolean type.


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


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)