Databases Reference
In-Depth Information
another cell value without changing the cell value from an earlier calculation.
The syntax for Freeze Statement is:
Freeze <subcube>
This Freeze statement is only used within MDX Scripts. It is easier to under-
stand the Freeze statement with an example. Assume the following MDX
statements below where A, B, and C are MDX expressions.
A=B;
B=C;
Due to recursion the final value for A will be equal to the value of C. However,
if you want to ensure that the value of A is pinned to the value assigned by
MDX expression B, you would introduce a Freeze statement between the two
assignments as shown here.
A=B;
Freeze (A);
B=C;
You can use the Freeze statement when you perform budget allocations. An
example of Freeze statement is used in the sample Adventure Works DW
database. Budget is first allocated the current year's quarters based on the
previous year's quarter values and Freeze statement is applied to the quar-
ters so that their values are not changed. Then the months are allocated
weights based on the previous years followed by the budget for the months
which allocated as a ratio of the quarter value. If the Freeze statement is not
applied to the budget value for quarters their values would be overwritten
when the ratios for the months are calculated.
Search WWH ::
Custom Search