Monday, October 29, 2007

1012016 Cannot calculate dimension member memberName with restricted member memberName

Possible Problems
The calculation script contained a calculation that tried to calculate a member after restricting the calculation to a different member in the same dimension.

Possible Solutions
Make sure that the member is correctly positioned in the FIX statement. If you fix on a member, you can calculate only that member. For example, the following FIX statement is incorrect because the FIX is on the Sales member, but the statement tries to calculate Profit, which is a different member:

FIX(Sales)
Profit;
ENDFIX

The following FIX statement is correct:
FIX (Sales)
Sales;
ENDFIX

No comments: