FREEZE Statement (MDX)

  • Article

Locks the cell values of a specified subcube to their current values. When the cell values are locked, changes to other cells have no effect on the cells that are locked.

Syntax

FREEZE Subcube_Expression

Arguments

  • Subcube_Expression
    A valid Multidimensional Expressions (MDX) expression that returns a subcube.

Remarks

The FREEZE statement locks the values of cells in a specified subcube, preventing subsequent statements in an MDX script from changing their values in subsequent calculation passes.

In the following example, A and B represent subcubes in an MDX calculation script:

B = 2;
A = B;
B = 3

At this point, both A and B are equal to 3.

We now insert the Freeze function to lock the cells in the A subcube:

B = 2;
A = B;
FREEZE(A);
B = 3

A is now equal to 2, and B is equal to 3.

See Also

Other Resources

MDX Scripting Statements (MDX)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006
Changed content:
  • Updated syntax and arguments to improve clarity.