Microsoft KB Archive/942640

= Error message when you validate a cross-model allocation rule in PerformancePoint Business Modeler: &quot;Member set is not defined correctly for cross model mapping. The number of members in source and target member sets in cross model mapping must match&quot; =

Article ID: 942640

Article Last Modified on 10/23/2007

-

APPLIES TO


 * Microsoft Office PerformancePoint Server 2007, 32 Bit Edition
 * Microsoft Office PerformancePoint Server 2007, 64 Bit Edition

-



SYMPTOMS
Consider the following scenario. In PerformancePoint Business Modeler, you have two models that are named MA and MB. You add dimensions to these models. For example, you add D1 to MA, and then you add D2 to MA. Next, you add D4 to MB, and then you add D3 to MB. You create an allocation rule to map dimension members between these models. In the allocation rule, the order in which the dimensions appear differs from the order in which you added the dimensions to the corresponding model. For example, in the allocation rule, D3 appears first. Additionally, D4 appears second.

In this scenario, you experience one of the following symptoms.

Symptom 1
After you run the allocation rule, the members are mapped incorrectly. PerformancePoint Business Modeler maps D1 to D4 and maps D2 to D3.

Assume that you map (D1.[All Members].Mem1, D2.[All Members].Mem2) to (D3.[All Members].Mem3, D4.[All Members].Mem4). After you run the allocation rule, Mem1 is mapped to Mem4, and Mem2 is mapped to Mem3. However, you expect Mem1 to be mapped to Mem3 and Mem2 to be mapped to Mem4.

Symptom 2
The allocation rule contains member sets that have a different number of members. Or, the allocation rule contains a member and a member set.

Assume that you map ({D1.[All Members].Mem1, D1.[All Members].Mem2}, D2.[All Members].Mem3) to ({D3.[All Members].Mem4, D3.[All Members].Mem5}, D4.[All Members].Mem6).

When you validate the allocation rule in PerformancePoint Business Modeler, you receive the following error message:

Member set is not defined correctly for cross model mapping. The number of members in source and target member sets in cross model mapping must match.



CAUSE
PerformancePoint Business Modeler maps the dimensions based on the order in which you add the dimensions to the model instead of the order that you specify in the allocation rule.



WORKAROUND
To work around this problem, use one of the following methods.

Note In the following steps, we use the assumption in the &quot;Symptoms&quot; section. In this assumption, you map (D1.[All Members].Mem1, D2.[All Members].Mem2) to (D3.[All Members].Mem3, D4.[All Members].Mem4).

Method 1: Create associations instead of allocation rules
We recommend that you use this method. In the following procedure, you create an association to create the following mapping:

([D1].[All Members].[Mem1], [D2].[All Members].[Mem2]) is mapped to ([D3].[All Members].[Mem3], [D4].[All Members].[Mem4])

To create an association, follow these steps:
 * 1) Start PerformancePoint Business Modeler.
 * 2) On the File menu, click Connect.
 * 3) In the Connect dialog box, type http:// :46787/ under Select a server, and then click Connect.
 * 4) In Workspace Browser, right-click Models, and then click Create an Association.
 * 5) In the New Association dialog box, type a name in the Name box.
 * 6) In the Source model site list, click the model site that contains MA.
 * 7) In the Source model list, click MA.
 * 8) In the Destination model site list, click the model site that contains MB.
 * 9) In the Destination model list, click MB.
 * 10) Click OK.
 * 11) In the middle pane, click the Dimension Associations tab.
 * 12) On the Dimension Associations tab, click D1 under Source dimensions, click D3 under Destination dimensions, and then click Add Mapping.
 * 13) Click D2 under Source dimensions, click D4 under Destination dimensions, and then click Add Mapping.
 * 14) On the Member Associations tab, click  in the Dimensions mapped list.
 * 15) Under Source dimension members, click Mem1.
 * 16) Under Destination dimension members, click Mem3, and then click Add Mapping.
 * 17) In the Dimensions mapped list, click .
 * 18) Under Source dimension members, click Mem2.
 * 19) Under Destination dimension members, click Mem4, and then click Add Mapping.
 * 20) On the File menu, click Save Model Site.

Method 2: Adjust the sequence of the dimensions that are added to the model
Important We highly recommend that you back up the fact table before you follow these steps.
 * 1) Start PerformancePoint Business Modeler.
 * 2) On the File menu, click Connect.
 * 3) In the Connect dialog box, type http:// :46787/ under Select a server, and then click Connect.
 * 4) In Workspace Browser, click Models.
 * 5) In the middle pane, double-click MB.
 * 6) In Model Tasks, click Manage Model Dimensions.
 * 7) In the Manage Model Dimensions dialog box, note the values in the Member Set or View column and in the Alias column for D3 and for D4.

Note These values must be identical when you rebuild the model in steps 12 and 13.
 * 1) Click D4, and then click Delete.
 * 2) Click D3, and then click Delete.
 * 3) Click OK.

Important Do not save the model after you click OK.
 * 1) Click Manage Model Dimensions.
 * 2) In the Manage Model Dimensions dialog box, click D3 in the Dimension list, click the member set in the Member set list, type the alias in the Alias box, and then click >.

Important The member set that you click and the alias that you type should be identical to the member set and the alias that you noted for D3 in step 7. If the member set or the alias is different, data may be lost in the fact table.
 * 1) Click D4 in the Dimension list, click the member set in the Member set list, type the alias in the Alias box, and then click >.

Important The member set that you click and the alias that you type should be identical to the member set and the alias that you noted for D4 in step 7. If the member set or the alias is different, data may be lost in the fact table.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb kbexpertiseadvanced KB942640

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.