Monday, October 29, 2007

1012017 Cannot calculate dimension dimensionName with restricted member memberName

Possible Problems
The calculation script contained a calculation that tried to calculate 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 calculate only that member in the same dimension. For example, the following FIX statement is incorrect because the FIX is on the Sales member, which is part of the the Measures dimension, but the statement tries to calculate the entire Measures dimension:

FIX(Sales)
CALC DIM Measures;
ENDFIX

No comments: