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