Sets the HIGH, DEFAULT, and LOW values for the SET NOTICE calculation command, which displays completion notices about the progress of the calculation.
This setting does not apply to aggregate storage databases.
CALCNOTICEHIGH | CALCNOTICEDEFAULT | CALCNOTICELOW n
where HIGH, DEFAULT, and LOW are levels.
HIGH—Maximum number of completion notices that a user can choose to display.
DEFAULT—Default number of completion notices.
LOW—Minimum number of completion notices that a user can choose to display.
n—Integer value for each level. It represents the number of notices to be displayed at set intervals during the calculation.
CALCNOTICE defines the values for each of the three levels of the SET NOTICE calculation command.
SET NOTICE HIGH | DEFAULT | LOW provides 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 database.
For partial calculations and calculations with multiple passes through your database, the interval between completion notices is approximate.
The intervals between completion notices are approximate.
Completion notices do not significantly reduce the calculation performance, except when used with a very small database.
If you use the following settings in the essbase.cfg file:
CALCNOTICEHIGH 50 CALCNOTICEDEFAULT 20 CALCNOTICELOW 5
Then SET NOTICE commands in a 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.
Note: | In essbase.cfg, a parameter is not followed by a semicolon; in a script, a parameter must be followed by a semicolon. |
SET NOTICE (calculation command)