How to find Number of child members (including all levels) of a Rollup/Parent members of a Dimension

Summary

How to find Number of child members (including all levels) of a Rollup/Parent members of a Dimension

Content

Hi All,

We are looking for a command which can count number of child members of a Rollup/Parent members for Audit purposes.

For Example:

Generation 1 Team

Generation 2      TeamA

Generation 3           Narender

Generation 4                    Geeta

Generation 4                     Gunjan

Generation 4                     Arindam

Generation 5                               Srishty

Generation 2      TeamB

Generation 3           Rohit

Generation 4                Shalini

Generation 5                     Nitish

For above hierarchy, I should get  Count "4" for Narender(Rollup) and "2" for Rohit.

We need solution for both ASO and BSO cubes.

Version: Essbase 11.1.2.3.508.35

I really appreciate for help.

Regards,

Nitish

Message was edited by: 3145931