This discussion is archived
0 Replies Latest reply: Nov 14, 2012 8:44 PM by 834075 RSS

Alternate Hierarchy

834075 Newbie
Currently Being Moderated
I have added Alternate Hierarchy to one of the dimensions and the total members have increased to almost double the number of members before the alternate hierarchy. But why would the .pag size increase?.. since all I added were Shared members except for their unique parents. Also my the calculations are taking longer, simple agg is taking more than 20 mins.

Why would the .pag size increase drastically?
How can I improve the Calc time?

Thank you for your help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points