Re: Essbase Studio, ASO Multiple Hierarchies, and Recursive Dimensions

Hi David,
I've not tried recursive hierarchies with ASO cubes yet but this might work. Create user defined members for the the generation 2 members and then add the parent child underneat of them. Something like

Total Soda
Diet
Parent
---child

you could then set Total Soda to be stored and Diet to be dynamic. Since it would build those members first, the ones in the parent child would jsut see them and assume they were in the cube already.

Just a thought