Essbase Member Operation Utility – Count Members 2


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)


About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

2 thoughts on “Essbase Member Operation Utility – Count Members

  • Ashish Bhavnani

    Hi,

    Is there a way to write an Essbase report script that provides a count of the members at a specified generation?

    Thanks

    • Celvin Kattookaran Post author

      I don’t think there is a COUNT command in report script however, there is one in MDX. You can try that one.