@ISDESC

Returns TRUE if the current member is a descendant of the specified member. This function excludes the specified member.

Syntax

@ISDESC (mbrName)
ParameterDescription

mbrName

Any valid single member name or member combination, or a function that returns a single member or member combination.

Example

In the Sample Basic database:

@ISDESC(Market)

Returns TRUE for West, California, Oregon, Washington, Utah, Nevada

@ISDESC(Profit)

Returns FALSE for Measures, Profit, Profit %