| title | IsDescendant (DMX) |
|---|---|
| description | IsDescendant (DMX) |
| ms.date | 02/17/2022 |
| ms.service | sql |
| ms.subservice | analysis-services |
| ms.topic | reference |
| ms.custom | dmx |
[!INCLUDEssas]
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)