MDX Data Manipulation - CLEAR CALCULATIONS

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Syntax


CLEAR CALCULATIONS [FROMCube_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

MDX Data Manipulation Statements (MDX)