If you don’t then read my older brother’s blog posts on the same 🙂
How it works
Create a file which is similar to the one below.
Run the utility with following options
Utility will update the storage properties of all parents in your hierarchy to the one that you specified.
In the example I changed all the parents under Market to a Dynamic Calc and all parents under Product to Store.
This can help you convert an existing BSO cube to Hybrid. Look at ASODYNAMICAGGINBSO
I’m planning to add another option to this which will let you know the members which should be tagged as “Never Share”.
Happy Hybridising 🙂
You can download the file from here.
I tested this on 19K higher level (44K members) hierarchy and it was done in less than 3 minutes!!!
Turns out this is the fastest way to prepare Essbase cubes for Hybrid 🙂