TIMINGMESSAGES

This configuration setting controls whether Essbase logs the duration of each grid and report query in the application log.

Syntax

TIMINGMESSAGES TRUE | FALSE

TRUE—Essbase logs these items:
- The duration of all grid 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—Essbase does not log these items:
- The duration of all grid 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.

Description

TIMINGMESSAGES controls whether Essbase logs the duration of each grid 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, Essbase 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 Essbase to time and log the duration of queries in the application log. For example: [Thu Nov 26 14:55:32 2020]Local/Sample/Basic/admin/Info(1020055) Spreadsheet Extractor Elapsed Time : [0.078] seconds.

TIMINGMESSAGES FALSE

Disables the logging of query durations.