Skip to Content
0
Apr 14, 2010 at 02:46 PM

How do multiple hierarchies affect performance?

42 Views

We have 15 members in our product dimension and currently have two hierarchies that utilize all members. We would like to set up several more hierarchies, each of which only use two dimension members:

H3: Product A

Product B

H4: Product A

Product C

H5: Product A

Product D

Do alternate hierarchies have a significant negative affect on performance? Are there other impacts we should consider?