IsDescendant

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

Reference

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
Mapping Functions to Query Types (DMX)

Help and Information

Getting SQL Server 2005 Assistance