SET NOTICE

The SET NOTICE command monitors the progress of your calculation by providing completion notices at intervals during the calculation.

Syntax

SET NOTICE HIGH | DEFAULT | LOW;

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, Hyperion Essbase uses a default value of 10, which provides 10 completion messages at 10% intervals during the calculation.

Description

This setting provides completion notices at intervals during the calculation. The number of notices depends on the level you specify.

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. Hyperion 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, Hyperion 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 Hyperion Essbase displays only two notices.

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

Notes

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

CALCNOTICE (ESSBASE.CFG) file
SET MSG