MEMBER SET FUNCTION

some other Calculation commands

@CHILDREN :

•  Returns all children of the specified member, exculding the specified member.

Syntax

@CHILDREN ( mbrname )

EXAMPLE :

• Essbase sorts the children in ascending order.
• From the above image if  you specify member name @children(sales) it returns unit sales , price.

@DESCENDANTS : 

• Returns all descendants those are down to the specified generation or level.
• Exculding the specified member.

Syntax

@Descandants( mbrname [, genlevnum | genlevname] )

• Generation number defines the positive number.
• Level number starts from zero or negative integer