CLEARBLOCK

Command

The CLEARBLOCK command clears blocks of data and sets them to #MISSING.

Syntax

CLEARBLOCK ALL | UPPER | NONINPUT | DYNAMIC ;

ALL	Clears all data blocks.
UPPER	Clears all consolidated level blocks.
NONINPUT	Clears blocks containing values derived from calculations.
DYNAMIC	Clears blocks containing values derived from Dynamic Calc And Store member combinations.

Description

The CLEARBLOCK command clears some or all of a database's cells and changes the values of those cells to #MISSING values. 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 Hyperion Essbase must pass through these additional data blocks. CLEARBLOCK clears blocks before a calculation occurs.

If you use CLEARBLOCK within a FIX command, Hyperion Essbase clears only the data cells within the fixed range, and not the entire block.

Notes

• 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.

Example

CLEARBLOCK ALL;
CLEARBLOCK UPPER;
CLEARBLOCK NONINPUT;
CLEARBLOCK DYNAMIC;

See Also

CLEARDATA

Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.