SET NOTICE

Monitors the progress of your 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;
Parameter Description

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 setting in the essbase.cfg file. If you do not set the value of DEFAULT in the essbase.cfg file, Essbase uses a default value of 10, which provides 10 completion messages at 10% intervals during the calculation.

Notes

  • You can specify the number of notices for each level using the CALCNOTICE setting in the essbase.cfg file.

  • 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 essbase.cfg file contains the following settings:

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 NOTICE LOW;

might produce the following sample output:

[Thu Apr  6 10:09:19 1995] Local/Sample/Basic/Qatest/Info(1012669)
Calculating [ Measures(All members) Year(All members) Scenario(All members) Product(All members) Market(All members)]

[Thu Apr  6 10:09:19 1995] Local/Sample/Basic/Qatest/Info(1012672)
Calculator Information Message:
Maximum Number of Lock Blocks: [100] Blocks
Completion Notice For Every: [ 10.000%] Of Blocks
Calculations On Updated Blocks Only: [Disabled]
Clear Update Status After Full Calculations: [Enabled]
Calculator Cache With Multiple Bitmaps For: [Market]

[Thu Apr  6 10:09:21 1995] Local/Sample/Basic/Qatest/Info(1012672)
Calculator Information Message: Completion Notice For Block Number [49]

[Thu Apr  6 10:09:22 1995] Local/Sample/Basic/Qatest/Info(1012672)
Calculator Information Message: Completion Notice For Block Number [97]

[Thu Apr  6 10:09:24 1995] Local/Sample/Basic/Qatest/Info(1012672)
Calculator Information Message: Completion Notice For Block Number [145]

[Thu Apr  6 10:09:25 1995] Local/Sample/Basic/Qatest/Info(1012672)
Calculator Information Message: Completion Notice For Block Number [193]

[Thu Apr  6 10:09:27 1995] Local/Sample/Basic/Qatest/Info(1012672)
Calculator Information Message: Completion Notice For Block Number [241]

See Also