title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
---|---|---|---|---|---|---|---|---|---|
CLEAR CALCULATIONS Statement (MDX) |
MDX Data Manipulation - CLEAR CALCULATIONS |
kfollis |
kfollis |
kfollis |
02/17/2022 |
sql |
analysis-services |
reference |
mdx |
Removes all calculations from the cube and returns the cube to calculation pass 0.
CLEAR CALCULATIONS [FROMCube_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.
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)