Sets the level of messaging you want returned about calculations, and enables simulated calculations.
SET MSG SUMMARY | DETAIL | ERROR | WARNS | INFO | NONE | ONLY;
SUMMARY | Displays calculation settings and provides statistics on the number of:
|
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. |
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.
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
CLEARBLOCK
SET NOTICE
Set Commands
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |