CLEAR CALCULATIONS Statement (MDX)

Removes all calculations from the cube and returns the cube to calculation pass 0.

Syntax

CLEAR CALCULATIONS [FROM Cube_Expression]

Arguments

• Cube_Expression
  A valid Multidimensional Expressions (MDX) cube expression.

Remarks

The FROM clause can be omitted when the context of the cube is known, such as in an MDX script.

Note

This statement can only be executed by a server or database administrator, or a member of a role that has access to the source data in the cube (that is, ReadSourceData=true)

See Also

Other Resources

MDX Data Manipulation Statements (MDX)

Help and Information

Getting SQL Server 2005 Assistance