Export (0) Print
Expand All

About model, dimension, and member associations

Associations are created when models, dimensions, and members are associated to enable the movement of fact data between source models and destination models.

Note   Associations can only be viewed in the model site in which the association was created, and in the destination model site of the association definition.

The following list shows the steps that are required to create an association and then run the association.

  1. Create a model association

    The first step to create a model-to-model association is to define the relationship between model sites and models.

    When you associate models, the New Association dialog box gives you a selection of aggregation options (Total, Average, Maximum, and Minimum). The aggregation determines how records that have the same dimensionality are aggregated.

  2. Create dimension associations

    The second step is to create associations between the dimensions of the source model and destination model.

    Planning Business Modeler supports two different methods that you can use to create dimension associations.

    • Create a relationship between dimensions, and then add an association between members.

    • Specify a source dimension scope and a destination dimension scope. The source dimension scope selects source dimension members for data movement. The destination dimension scope specifies the destination dimension member that will contain those values.

  3. Create member associations

    To create member-level associations, you must first create associations between the dimensions that contain the members that you want to associate. Member associations enable you to customize the mapping between dimension members and make a more detailed association between members.

    NoteNote:

    You cannot create member-level associations between members that are specified as part of dimension scoping.

  4. Run the association

    When you run an association, Planning Business Modeler uses your specified associations to produce the measures or fact data in the destination model.

See Also

Show:
© 2014 Microsoft