SET MSG

Sets the level of messaging you want returned about calculations, and enables simulated calculations.

Syntax

SET MSG SUMMARY | DETAIL | ERROR | WARNS | INFO | NONE | ONLY;

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 Analytic Services 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.
ONLY Instructs Analytic Services to perform a simulated calculation only. You may disregard any error message during validation that indicates Analytic Services does not recognize a command.

NOTE: When you use this parameter, Analytic Services 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.

We recommend using SET MSG ONLY with the calculation script commands SET NOTICE HIGH and CALC ALL. For more information, see the Database Administrator's Guide sections on optimizing calculations.

Description

SET MSG SUMMARY and SET MSG DETAIL tell you:

In addition, the SET MSG DETAIL command provides an information message every time Analytic Services calculates a data block.

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

Notes

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

CLEARBLOCK
SET NOTICE
Set Commands

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com