1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Commands
  3. Calculation Command List
  4. SET NOTICE

SET NOTICE

The SET NOTICE calculation command monitors the progress of your Essbase calculation by providing completion notices at intervals during the calculation. The number of notices depends on the level you specify.

Syntax

SET NOTICE HIGH | DEFAULT | LOW;

Parameters

HIGH, DEFAULT, and LOW

Levels defining the frequency and number of completion notices.

You can set the values of HIGH, DEFAULT, and LOW using the CALCNOTICE configuration setting. If you do not set the value of DEFAULT for CALCNOTICE, Essbase uses a default value of 10, which provides 10 completion messages at 10% intervals during the calculation.

Notes

  • 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 database. For example, if there are 10,000 possible blocks and you specify 5 notices, Essbase notifies you when the calculation approximately reaches block 2000, 4000, 6000, 8,000 and 10,000. However, if only the blocks 1,000 - 4,000 exist, then Essbase displays only two notices.

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

  • Completion notices do not significantly reduce the calculation performance, except when used with a very small database.

Example

If the following settings are configured:

CALCNOTICEHIGH  50
CALCNOTICEDEFAULT  20
CALCNOTICELOW   5

then:

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.

SET MSG