Avoiding Multiple Member Selections for a Dimension in Source and Destination

Source and destination member selections for dimensions can impact calculation performance depending on how they are specified. In general, calculation performance is improved when the members desired for a dimension are specified with fewer upper level member selections instead of many lower level or level 0 member selections.

Using a single upper level member provides the best performance. In cases where the natural hierarchy doesn’t easily support groupings needed for allocations, consider creating alternate hierarchies that allow you to select fewer (ideally one) upper level member to specify the group of level 0 members you want to include in the source or destination.