TechNet
Expand All
The document is archived and information here might be outdated

CLEAR CALCULATIONS Statement (MDX)

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


CLEAR CALCULATIONS [FROM Cube_Expression]

Cube_Expression

A valid Multidimensional Expressions (MDX) cube expression.

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

ms145603.note(en-US,SQL.90).gifNote:
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)

Show:
© 2016 Microsoft