
138 • Developing Essbase Applications: Advanced Techniques for Finance and IT Professionals
FIX (Cola, Sales, Actual)
SET CREATEBLOCKONEQ OFF;
Nevada = NEW YORK" + 100;
ENDFIX
Placing a sparse member on the le side of the formula is not without its dangers.
Consider the following script:
FIX (Cola)
SET CREATEBLOCKONEQ OFF;
Budget = actual->Sales->"NEW YORK" + 100;
ENDFIX
Budget is a member of a sparse dimension and the formula readily creates blocks. In
fact, as shown in Figure4.6, it might create more blocks than expected.
Because the Market dimension was not restricted in the FIX, Cola blocks were created
for every market. When working ...