Hi,
I have added an additional 2 hierarchies to my account dimension and it seems to be taking progressively longer to open - it now takes atleast 1 minute. Could it be the additional hierarchies? I now have another possible hierarchie that I require a 4 hierarchy as I now have the same member rolling into two different parents on my 3rd hierarchy.
Which is better practice - adding an additional heirarchy for the different rollup or adding an dimension calculation (MDX) for the second rollup? There are quite a few members that have two possible rollups in the 3rd hierarchy, so there would need to be quite a few dimension calculations.
I'd be really interested to hear if anyone else has had this issue with opening the dimension for editing - all other dimensions are quick to open.
Any advice would really be appreciated,
Kind Regards,
Fiona