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?