1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Commands
  3. Calculation Command List
  4. SET MSG

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