How do multiple hierarchies affect performance?
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
H4: Product A
H5: Product A
Do alternate hierarchies have a significant negative affect on performance? Are there other impacts we should consider?