@ISDESC
The @ISDESC calculation function for Essbase tells whether the current member is a descendant of a specific member.
This function returns TRUE if the current member is a descendant of the specified member. This function excludes the specified member.
Syntax
@ISDESC (mbrName)
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 %