SQL Server

United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Analysis Services

Technical Reference

Query and Expression Language Reference

Data Mining Extensions (DMX) Reference

DMX Function Reference

BottomCount

BottomPercent

BottomSum

Cluster

ClusterDistance

ClusterProbability

Exists

IsDescendant

IsInNode

IsTestCase

Lag

Predict

PredictAdjustedProbability

PredictAssociation

PredictCaseLikelihood

PredictHistogram

PredictNodeId

PredictProbability

PredictSequence

PredictStdev

PredictTimeSeries

PredictVariance

RangeMax

RangeMid

RangeMin

StructureColumn

TopCount

TopPercent

TopSum

Minimize

This topic has not yet been rated - Rate this topic

IsDescendant (DMX)

SQL Server 2012

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 descendents of the node that is specified in the IsDescendant function.

SELECT * FROM [TM Decision Tree].CONTENT
WHERE IsDescendant('00000000100')

Reference

Data Mining Extensions (DMX) Function Reference

Functions (DMX)

General Prediction Functions (DMX)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft

Manage Your Profile

|

Site Feedback

© 2013 Microsoft. All rights reserved.