TIMINGMESSAGES

Controls whether Analytic Services logs the duration of each spreadsheet and report query in the application log.

Syntax

TIMINGMESSAGES TRUE | FALSE

TRUE Analytic Services logs these items:
  • The duration of all spreadsheet and report queries in the application log.
  • The log also records a timestamp of the query's execution.
  • Messages about dynamic calculator cache usage for each data retrieval.
The default setting is TRUE.
FALSE Analytic Services does not log these items:
  • The duration of all spreadsheet and report queries in the application log.
  • The log also records a timestamp of the query's execution.
  • Messages about dynamic calculator cache usage for each data retrieval.

If you have not created a .CFG file, or if you do not have this parameter specified in your .CFG file, Analytic Services automatically records and logs the duration of queries in the application log. You must set TIMINGMESSAGES to FALSE to disable this feature.

Description

TIMINGMESSAGES controls whether Analytic Services logs the duration of each spreadsheet and report query in the application log. Setting TIMINGMESSAGES to FALSE disables the logging of query durations in the application log. If the timing of queries is disabled, Analytic Services does not have to communicate with the operating system to get query start and finish times. As a result, query execution times may be improved in environments with many concurrent users. Disabling this parameter also decreases the size of the application log.

Example

TIMINGMESSAGES TRUE
causes Analytic Services to time and log the duration of queries in the application log.
For example: [Thu Mar 19 14:55:32 1998]Local/Sample/Basic/admin/Info(1020055) Spreadsheet Extractor Elapsed Time : [0.078] seconds
TIMINGMESSAGES FALSE
disables the logging of query durations.

See Also

SSLOGUNKNOWN

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