SET MSG

The SET MSG command traces your calculations.

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 Hyperion Essbase calculates a data block.

ERROR Displays only error messages.

WARNS Displays only warning and error messages.

INFO Displays information, warning, 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.

Description

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 Hyperion Essbase calculates a data block.

The SET MSG command applies only to the calculation script in which it is used.

Notes

SET MSG SUMMARY causes a processing overhead of approximately 1% to 5%, depending on the database size.
SET MSG DETAIL is useful for testing your database's consolidation path. It causes a high processing overhead and therefore should be used during test calculations only.

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

SET NOTICE

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 Hyperion Essbase calculates a data block.
ERROR	Displays only error messages.
WARNS	Displays only warning and error messages.
INFO	Displays information, warning, 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.