Wednesday, October 31, 2007

1012024 Cannot aggregate dimension dimensionName with restricted member memberName

Possible Problems
The calculation script contains a calculation that tries to aggregate a dimension after restricting the calculation to a member of the same dimension.

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

FIX(Sales)
AGG(Measures);
ENDFIX

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

No comments: