CALCLOCKBLOCK

CALCLOCKBLOCK {HIGH | DEFAULT | LOW} sets the HIGH, DEFAULT, and LOW values for the calc script SET LOCKBLOCK command.

This setting specifies the maximum number of blocks that Hyperion Essbase can fix (get addressability to) when calculating one block.

Syntax

CALCLOCKBLOCKHIGH | CALCLOCKBLOCKDEFAULT | CALCLOCKBLOCKLOW n

Where HIGH, DEFAULT, and LOW are levels:

HIGH Maximum number of blocks that a user can choose to fix concurrently when one data block is calculated.

DEFAULT Default number of blocks that can be fixed concurrently.

LOW Minimum number of blocks that a user can choose to fix concurrently.

n Integer value for each level, representing the total number of blocks that can be locked concurrently.

Description

CALCLOCKBLOCK specifies the number of blocks that can be fixed at each level of the SET LOCKBLOCK HIGH | DEFAULT | LOW calc script command.

When a block is calculated, Hyperion Essbase fixes (gets addressability to) the block along with the blocks containing its children. Hyperion Essbase calculates the block and then releases it along with the blocks containing its children.

By default, Hyperion Essbase allows up to 100 blocks to be fixed concurrently when calculating a block. This is sufficient for most database calculations.

However, you may want to set a number higher than 100 if you are consolidating very large numbers of children in a formula calculation.

This ensures that Hyperion Essbase can fix all the required blocks when calculating a data block and that performance will not be impaired.

Example

If the ESSBASE.CFG file contains the following settings:

CALCLOCKBLOCKHIGH 500
CALCLOCKBLOCKDEFAULT 200
CALCLOCKBLOCKLOW 50

then you can use the following SET LOCKBLOCK setting commands in a calc script:

SET LOCKBLOCK HIGH;

means that Hyperion Essbase can fix up to 500 data blocks when calculating one block.

SET LOCKBLOCK DEFAULT;

means that Hyperion Essbase can fix up to 200 data blocks when calculating one block.

SET LOCKBLOCK LOW;

means that Hyperion Essbase can fix up to 50 data blocks when calculating one block.

In ESSBASE.CFG, a parameter is not followed by a semicolon; in a calc script, a parameter must be followed by a semicolon.

Notes

For more information on data blocks, see the Database Administrator's Guide.

See Also

SET LOCKBLOCK (calc script command)

HIGH	Maximum number of blocks that a user can choose to fix concurrently when one data block is calculated.
DEFAULT	Default number of blocks that can be fixed concurrently.
LOW	Minimum number of blocks that a user can choose to fix concurrently.
n	Integer value for each level, representing the total number of blocks that can be locked concurrently.