Clears blocks of data and sets them to #MISSING
.
CLEARBLOCK ALL | UPPER | NONINPUT | DYNAMIC ;
ALL | Clears all data blocks. |
UPPER | Clears all consolidated level blocks. |
NONINPUT | Clears blocks containing values derived from calculations. Applies to blocks that are completely created by a calculation operation. Cannot be a block into which certain values were loaded through a data load operation. |
DYNAMIC | Clears blocks containing values derived from Dynamic Calc and Store member combinations. |
The CLEARBLOCK command sets cell values to #MISSING
, and if all the cells are empty or contain #MISSING
, removes the block. This command is useful when you need to clear
old data values across data blocks before loading new values into the database.
CLEARBLOCK is especially useful when you want to optimize the calculation speed of a database. When a database is initially calculated, numerous consolidated level sections (blocks) are created. Subsequent calculations against the same set of data take longer since Analytic Services must pass through these additional data blocks. CLEARBLOCK clears blocks before a calculation occurs.
If you use CLEARBLOCK within a FIX command, Analytic Services clears only the data cells within the fixed range, and not the entire block.
If you regularly enter data values directly into a consolidated
level, the UPPER
option overwrites your data. In this case,
you should use the NONINPUT
option, which only clears blocks
that contains calculated values.
CLEARBLOCK ALL; CLEARBLOCK UPPER; CLEARBLOCK NONINPUT; CLEARBLOCK DYNAMIC;
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |