IsDescendant (DMX)


Updated: March 2, 2016

Indicates whether the current node descends from the specified node.


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')  

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

Community Additions