I thought I’ll be adding more fun stuff to this utility and keep it growing.
Rename is still an issue. I’ll update once it is fixed.
For the people who are interested in this utility here is the download link
I’ve added a new option where you can count the number of descendants, level 0 descendants under a parent.
You can create a file as shown below
- Descendants will give you a count of all descendants of that parent.
- Generation (n) will give you the count of all generation (n) members under that parent.
- Level(n) will give you the count of all level (n) members under that parent.
- Shared Descendants will give you the count of shared members under that parent.
Check this post for deleting members from cube.
I’m planning to add more fun stuff like member movement (now that is almost death to load rules)
Is there a way to write an Essbase report script that provides a count of the members at a specified generation?
I don’t think there is a COUNT command in report script however, there is one in MDX. You can try that one.