SET MSG
The SET MSG calculation command sets the level of messaging you want Essbase to return about calculations, and enables simulated calculations.
This command applies only to the calculation script in which it is used.
Syntax
SET MSG SUMMARY | DETAIL | ERROR | INFO | NONE | ONLY;
Parameters
- SUMMARY
-
Displays calculation settings and provides statistics on the number of:
-
Data blocks created, read, and written
-
Data cells calculated
-
- DETAIL
-
Provides the same information as SUMMARY. In addition, it displays a detailed information message every time Essbase calculates a data block.
- ERROR
-
Displays only error messages.
- INFO
-
Displays information and error messages.
- NONE
-
Displays no messages during the life of the calculation script. However, because error messages may contain vital information, they are still displayed.
- ONLY
-
Instructs Essbase to perform a simulated calculation only. You may disregard any error message during validation that indicates Essbase does not recognize a command.
Note:
When you use this parameter, Essbase generates some empty upper-level blocks. Make sure to clear upper-level blocks (or non-input blocks if you load data into upper level blocks in your model) at the end of the simulation/command.
Oracle recommends using SET MSG ONLY with the calculation script commands SET NOTICE HIGH and CALC ALL.
SET MSG ONLY does not generate a completion notice.
Notes
SET MSG SUMMARY and SET MSG DETAIL tell you:
-
The status of calculation settings (for example, whether completion notice messages are enabled)
-
The total number of data blocks created
-
The number of data blocks read and written on sparse calculations
-
The number of data blocks read and written on dense calculations
-
The number of data cells calculated on sparse calculations
-
The number of data cells calculated on dense calculations
In addition, the SET MSG DETAIL command provides an information message every time Essbase calculates a data block. It is useful for testing your database's consolidation path. Because it causes a high processing overhead, it should be used during test calculations only.
SET MSG SUMMARY causes a processing overhead of approximately 1% to 5%, depending on the database size.
Example
SET MSG ERROR;
Displays only the error messages.
SET MSG SUMMARY;
Produces the following sample output:
[Tue Apr 4 05:11:16 1995] local/Sample/Basic/Qatest/Info(1012672)
Calculator Information Message:
Maximum Number of Lock Blocks: [100] Blocks
Completion Notice Messages: [Disabled]
Calculations On Updated Blocks Only: [Enabled]
Clear Update Status After Full Calculations: [Enabled]
Calculator Cache With Multiple Bitmaps For: [Market]
[Tue Apr 4 05:11:19 1995] local/Sample/Basic/Qatest/Info(1012672)
Calculator Information Message:
Total Block Created: [0.0000e+00] Blocks
Sparse Calculations: [4.3000e+01] Writes and [4.3000e+01] Reads
Dense Calculations: [4.3200e+02] Writes and [4.3200e+02] Reads
Sparse Calculations: [1.7200e+02] Cells
Dense Calculations: [4.3200e+02] Cells
SET MSG DETAIL;
Produces the following sample output:
[Thu Mar 30 16:27:26 1995] local/Sample/Basic/Qatest/Info(1012669)
Calculator Information Message:
Maximum Number of Lock Blocks: [100] Blocks
Completion Notice Messages: [Disabled]
Calculations On Updated Blocks Only: [Enabled]
Clear Update Status After Partial Calculations: [Disabled]
Calculator Cache With Multiple Bitmaps For: [Market]
[Thu Mar 30 16:27:26 1995] local/Sample/Basic/Qatest/Info(1012669)
Calculator Information Message: Executing Block - [100], [East]
[Thu Mar 30 16:27:26 1995] local/Sample/Basic/Qatest/Info(1012669)
Calculator Information Message: Executing Block - [Product], [East]
[Thu Mar 30 16:27:26 1995] local/Sample/Basic/Qatest/Info(1012669)
Calculator Information Message: Executing Block - [100], [Market]
[Thu Mar 30 16:27:26 1995] local/Sample/Basic/Qatest/Info(1012669)
Calculator Information Message: Executing Block - [Product], [Market]
[Thu Mar 30 16:27:26 1995] local/Sample/Basic/Qatest/Info(1012669)
Calculator Information Message:
Total Block Created: [0.0000e+00] Blocks
Sparse Calculations: [4.0000e+00] Writes and [2.2000e+01] Reads
Dense Calculations: [0.0000e+00] Writes and [0.0000e+00] Reads
Sparse Calculations: [3.8080e+03] Cells
Dense Calculations: [0.0000e+00] Cells
See Also