Essbase Member Operation Utility – Change Data Storage based on levels


This is an update to Essbase Member Operation Utility change data storage option. My big brother from completely different set of parents gave me this idea almost 3 months back (yeah it became pretty busy) and I kind of ignored it ;).

Now that I’m on my own and I’m working on a project which involves a POC work on making an existing Planning application Hybrid, now you might ask why change the store based on levels. The utility can already perform this – if you give a parent name, it can change the storage type of all the descendents (except level0s).Why why why????

Here comes the beauty of Hybrid(or I should say the limitation right now with Hybrid), cross dim to a parent member will break Hybrid and will switch to BSO world and that could be really (I really mean it, really really) slow. The trick is to make the parent members of those sparse dimensions store. There could be some calculations which can use let’s say 2nd level ansestor value (ah now you see it), why this update you can provide the parent name, storage and level number (as shown below) and off you go 🙂

changeprop.png

This is a comma seperated file (I’m using a VI editor to show the contents)

You can still use the old format (changing everything under a parent)

image-7

You can encrypt all the parameters

encryption

Copy the Encrypted Text and paste in the script.

esbmbrop-sh-file

Same steps can be followed on windows machine too.

Run the bat/sh file

sh execution.png

There you go all the level 1 parent’s storage property changed to “Store”

You can download the new version for here 

Documentation is available at https://sourceforge.net/p/essbase-member-operations/wiki/Home/

Advertisements

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