CALCNOTICE

The CALCNOTICE configuration settings enable you to customize the number of notifications Essbase generates for the HIGH, DEFAULT, and LOW values of the SET NOTICE calculation command. SET NOTICE displays completion notices about the progress of the calculation.

CALCNOTICE configurations apply only to block storage (BSO) databases, and do not apply to aggregate storage (ASO) databases.

Syntax

CALCNOTICEHIGH | CALCNOTICEDEFAULT | CALCNOTICELOW n

CALCNOTICEHIGH—The level with the maximum number of completion notices.
CALCNOTICEDEFAULT—The level with the default number of completion notices.
CALCNOTICELOW—The level with the minimum number of completion notices.
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 generates 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.