Parent/Child Alternate hierarchy in Essbase Studio for ASO cube
Hello Experts, I am trying to build ASO cube outline using studio where we have primary hierarchy as parent/child which is getting built successfully but also have parent/child hierarchy altenate roll up. I have added parent/child from primary table on top in hierachy and similiary added parent/child columns from alternate hierarchy table. Strangly it is only building primary hierarchy and ignoring alternate roll up during cube deployment. I tried marking dimension as dynamic as well as multiple hierarchies enabled no luck so far. Also tried adding child in alternate hierarchy from primary hierarchy as user guide suggests to create shared