Essbase Member Operation Utility – Encryption and find which members to tag as Never Share


I know many of you are using this utility and I had to use that myself at my project.

This was done to properly update a dimension. It had alternate hierarchy and there was member movements too. I had to delete the alternate hierarchy and then load the main hierarchy first and then the alternate.

I didn’t like the idea of exposing the credentials on a production system and had to add encryption.

Here we are, you can now encrypt the options and pass that in the bat file. (Yeah I don’t like just encrypting user name/password only). If you are choosing encryption then you’ve to encrypt the whole string.

You can encrypt the entire option by navigating to Essbase Member Operation lib directory (e.g. C:UsersAdministratorDesktopEssbase_Mbr_Operations_Util_1.4lib)
Issue the following command

java -jar EsbMbrOperation.jar -encrypt="-u=admin -p=p@ssword -S=localhost -App=Sample -Db=Basic -file=C:/PropMbrList.txt -changeproperty"
Encrypted Text : KZkPq/hF3S/St3s43YJja42+VOwaYPLz6aHWZML1R4LBhnVEigiXwHzkYHwMTtBaWydOYbA31R7+hQ7Krqi02FYUOjtgMMQd9xm+7lCh+9NwBdpxuKc8vPu7Gkt5CSgsl9ELFqwguguRuaCrwErqcA==

Update the bat file with the encrypted string

Find Implicit Shared Members

Implicit sharing can be a pain, I think it is high time to change the code and get rid of this. Yeah I know you can use IMPLIED_SHARE to change the behavior, however I don’t like that setting. (I’m an old school guy, well maybe not “old”)

I’m adding an option which will help you find out all potential Implicit Shared members in your cube.

You’ll have to use export MaxL to export your outline as an XML file.

To export all dimensions use the below given MaxL
export outline ‘Sample’.’Basic’ all dimensions to xml_file ‘C:TempSample.xml’;

To export specific dimension use the below given MaxL
export outline ‘Sample’.’Basic’ list dimensions {“Market”} to xml_file ‘C:TempSample.xml’;

You can read more about export outline here.

Extract the outline, I used a modified version of Sample Basic for this.

Encrypt the options.

Update the bat file and there you go.

I did run this on a outline extract which has close to 1.4 Million members and it was done in 2 minutes, so it is fast!!!!

You can download the new version for here 
Documentation is available at https://sourceforge.net/p/essbase-member-operations/wiki/Home/


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.

0 thoughts on “Essbase Member Operation Utility – Encryption and find which members to tag as Never Share

  • TimF

    Hi Celvin,

    Would you mind if I had a slide in my Hybrid presentation at Kscope16 that talks about using your tool to change a dimension to be dynamic calc?

    Thanks,
    Tim Faitsch

  • Greg Beaton

    Hi Celvin,

    Tim told me about your utility at Kscope. I'm trying to use it to convert my outline to dynamic calc for Hybrid. I've setup the utility as described, it connects to the app but then gives java exceptions, saying unknown member. Cost Center, Dynamic Calc is in my file. I tried count and rename, both didn't error out, but my outline didn't get updated.

    When it errors out, it leaves my outline locked. So I know its getting to my application fine.

    Any ideas?

  • Cameron Lackpour

    Spaces work, e.g.:
    Total Product Line View,Dynamic Calc

    If you have the name wrong, or if you have multiple dimensions and either the name is wrong or the storage option is wrong (Dyynamic Calc), the tool will stop.

    Regards,

    Cameron Lackpour

    P.S. You can use this for subhierarchies as well, not just dimension names. Pretty cool when you're trying to figure out what in a hierarchy has to be stored for Hybrid.
    P.P.S. Make sure the assignment is legal — think of the dynamic parent can't be a label only member if there's just one child (I think I have that right) — that'll cause it to stop as well.