Essbase Studio Recursive Hierarchies & Alternate Hierarchies
I am working with recursive hierarchies in Studio (11.1.2.1) and am having trouble creating alternate hierarchies using this method. I have a column that provides the hierarchy name and I am able to create 1 hierarchy from the table but I am not able to create more than 1 hierarchy. Has anyone had any success creating multiple shared hierarchies using the recursive method?
I have the following columns.. DIM_NAME, HIER_NAME, ESS_PARENT, ESS_CHILD, DEF_ALIAS, REPORINT_ALIAS, SORT_ORDER
Thanks for any ideas..