Create a dimension association

A dimension association in is an association that creates a mapping between members of a source dimension and members of a destination dimension. To create a dimension association, in PerformancePiont Planning Business Modeler, you must first Create a model association between the source model that contains the source dimension, and the destination model that contains the destination dimension.

There are two different methods that you can use to associate dimensions: you can scope the dimension, or you can create mappings between dimensions and dimension members. Depending on what you want to do, you can use just one method by itself, or you can use a mixture of both.

The following table contrasts the unique features of each method:

Method Unique feature


Dimension scoping

You can configure source or destination dimension scopes:

  • Use Source dimension scoping to filter the dimension members in the association.
  • Use Destination dimension scoping to introduce a dimension into the mapping. For example, if the source model does not have a Product dimension, you can specify the Product dimension in the destination scoping statement.

Dimension and member mapping

Use Dimension-member mapping to specify precisely how fact data should be moved for mapped dimensions. You can map one or more source members to each single destination member.
What do you want to do?


Create a dimension association by scoping

  1. In the Workspace Browser pane, click Associations.
  2. Click the model association that you want to use. Then, in the Association Tasks pane, click Check out.
  3. Click the Dimension Associations tab.
  4. From the Source dimensions table, select a source dimension. To create a source dimension scope, do the following:
    1. Click the ellipsis button (…) to display the Add or remove members to include them in the selection for [dimension].[member] dialog box.
    2. Scroll through the Available Members list, and select the check box next to the members that you want to include in the Selected Members list.
    3. When you are finished adding members, click OK. The members appear in the Scope column of the Source dimensions table for the selected source dimension.
  5. From the Destination dimensions table, select a destination dimension. To create a destination dimension scope, do the following:
    1. Click the ellipsis button (…) to display the Add or remove members to include them in the selection for [dimension].[member] dialog box.
    2. Scroll through the Available Members list, and select the check box next to the member that you want to include in the Selected Members list.

 Note   You cannot specify more than one member of a destination dimension.

  1. When you are finished adding the member, click OK. The member appears in the Scope column of the Destination dimensions table for the selected destination dimension.
  1. Repeat steps 1 - 5 for each dimension that you want to scope.

Top of Page Top of Page

Create a dimension association by mapping members

  1. In the Workspace Browser pane, click Associations.
  2. Click the model association that you want to use. Then, in the Association Tasks pane, click Check out.
  3. Click the Dimension Associations tab.
  4. From the Source dimensions table, select a source dimension
  5. From the Destination dimensions: table, select the destination dimension that you want to associate with the source dimension, and then click Add Mapping.

 Note   You can associate only one source dimension with one destination dimension.

  1. Click the Member Associations tab.
  2. From the Dimensions mapped drop-down list, select a dimension association.
  3. From the Source dimension members table, select one or more source dimension members
  4. From the Destination dimension members table, select one destination dimension member and then click Add Mapping.
    To automatically create associations between all source dimension members and destination dimension members that have matching names, click Map Identical.

Top of Page Top of Page