Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server Analysis Services
Indicates whether the current node descends from the specified node.
IsDescendant(<NodeID>)
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 descendants 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)