Comparison between dimension scoping and dimension-member associations
Planning Business Modeler supports two methods for defining associations between dimensions in different models. These two methods can give you different outcomes in the destination model.
Dimension and member associations
Dimension and member associations consist of a dimension association and a related member-level association, or member mapping. To define a member-level association, you must first define an association between the dimensions that contain the members you want to associate, and then define a member mapping.
Member-level associations enable you to do the following:
Aggregate member values from the source dimension, and map the aggregates to a single destination dimension member.
Associate one or more source dimension members to one destination member.
Dimension scoping
Dimension scoping filters dimension values. When you define a source dimension scope, you select the members of the source dimensions that will be copied. When you define a destination dimension scope, you select the members of the destination model that will receive copied information.
When you scope a dimension, you can compensate for models with an unequal number of dimensions in the associated models. For example, if the source model has more dimensions than the destination model, you can create a scope that omits one or more of the source dimension members. Alternatively, if the destination model has more dimensions, you can select No Member. Then, no members appear in the resulting measure group after the association is run.