HIER_CHILD_COUNT

HIER_CHILD_COUNT returns the number of children of either all dimension members in a hierarchy or a particular member. The hierarchy can be either level-based or value-based.

Return Value

NUMBER

Syntax

HIER_CHILD_COUNT( [ member [WITHIN] ]
                  dimension | hierarchy)

Arguments

member is a value of hierarchy whose children are tallied. Otherwise, the children of all members of the hierarchy are tallied.

dimension is the dimension whose members are used in the calculation.

hierarchy is a hierarchy of dimension. Otherwise, the default hierarchy is used.

Example

The following example returns the number of children for each member of the Calendar hierarchy.

HIER_CHILD_COUNT(global.time.calendar)

Example 1
Member	Number of Children
2003	4
Q3-03	3
Jul-03	0

The next example returns the number of children for just one member of the default Fiscal hierarchy.

HIER_CHILD_COUNT('FY-03' WITHIN global.time)

Example 2
Member	Number of Children
FY-03	4