CALCNOTICE

This Essbase configuration setting specifies the HIGH, DEFAULT, and LOW values for the SET NOTICE calculation command, which displays completion notices about the progress of the calculation.

This setting does not apply to aggregate storage cubes.

Syntax

CALCNOTICEHIGH | CALCNOTICEDEFAULT | CALCNOTICELOW n

Where HIGH, DEFAULT, and LOW are levels.

HIGH—Maximum number of completion notices that a user can choose to display.
DEFAULT—Default number of completion notices.
LOW—Minimum number of completion notices that a user can choose to display.
n—Integer value for each level. It represents the number of notices to be displayed at set intervals during the calculation. The default is 10.

Description

CALCNOTICE defines the values for each of the three levels of the SET NOTICE calculation command.

SET NOTICE HIGH | DEFAULT | LOW provides completion notices during a calculation. The frequency and number of completion notices depends on the level specified.

The interval between notices is approximate. Essbase measures the interval by taking the number of data blocks already calculated as a percentage of the total number of possible data blocks in your cube.

For partial calculations and calculations with multiple passes through your cube, the interval between completion notices is approximate.

Notes

The intervals between completion notices are approximate.
Completion notices do not significantly reduce the calculation performance, except when used with a very small cube.

Example

If you apply the following configurations:

CALCNOTICEHIGH 50
CALCNOTICEDEFAULT 20
CALCNOTICELOW 5

Then SET NOTICE commands in a calculation script produce the following results:

SET NOTICE HIGH;

Displays 50 completion notices at 2% intervals.

SET NOTICE DEFAULT;

Displays 20 completion notices at 5% intervals.

SET NOTICE LOW;

Displays 5 completion notices at 20% intervals.