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/
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
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?
Let me look at it. It might be because the member name is having a space in it.
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.
Cameron, thank you for checking this. OP, please let me know if it still doesn't work for you.