Add alternative hierarchy in a custom dimension
SummaryPossible relevant impacts on performance adding an alternative hierarchy in a custom dimension
I would like to know your opinion on a modification I have to make on the Custom2 dimension hierarchy.
On Custom2 dimension I have a primary hierarchy with Product members. The level 0 members of this primary hierarchy must be re-classified in a new alternative hierarchy. So, a new alternative hierarchy needs to be implemented. This new hierarchy has new dynamic calc parent members to sum the level 0 members shared. Level 0 members are 150. New parent dynamic calc members to add on the new hierarchy are 35.