1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. LONGCALCTIMETHRESHOLD

LONGCALCTIMETHRESHOLD

This Essbase configuration setting enables logging informational messages for long-running commands in Essbase calculation scripts.

Syntax

LONGCALCTIMETHRESHOLD n

Where n is the upper-limit execution time, in seconds, before which Essbase tracks the calculations and logs alert messages. Default: 0 seconds (calculation tracking is off).

Description

Use this parameter to specify the upper-limit execution time, in seconds, that top-level calculation command blocks can run before being considered long running and thus subject to tracking. A top-level command block is a command block that is not enclosed in a FIX/ENDFIX block. Essbase sends alert messages if any top level command block runs longer than the specified time limit.

The logged messages include the following information.

  • CALC_USER: ID of the user running the calculation script

  • CALC_SCRIPT_NAME: Calculation script name

  • LINE_NUMBERS: Range of script line numbers encompassed by the calculation command

  • Calc Command Text: First 500 characters of the calculation command code

  • BLOCKS_CREATED: Number of blocks created by the calculation command

  • BLOCKS_READ: Number of blocks read into memory during execution of the calculation command

  • BLOCKS_WRITE: Number of blocks updated by the calculation command

  • EXEC_TIME: Time, in milliseconds, that the calculation command has been running

  • Statistics about custom-defined functions, if any were executed.

Examples

LONGCALCTIMETHRESHOLD 60

Specifies message logging for calculations running 60 seconds or longer.

LONGCALCTIMETHRESHOLD .001

Turns on diagnostics for most calculation commands (the threshold is very small, but not zero).

The following request-pending message indicates that user essuser executed calculation script esscalcx1.csc on cube Sample.Basic. The execution time of the command block from line 9 - 15 was about 75 seconds. There were 562500, 562500, and 1125000 blocks read, written, and created, respectively. The text of the command block is printed inside {} braces. 

[2019-11-27T17:43:51.783-07:00] [Sample] [NOTIFICATION:16] [CAL-912] [CAL] [ecid: 1445992953893,0] 
[tid: 1107577152] [Basic/essuser] [CALC_USER: essuser] [CALC_SCRIPT_NAME: esscalcx1.csc] [LINE_NUMBERS: 9 - 15] 
[EXEC_TIME: 75420] [BLOCKS_READ: 562500] [BLOCKS_WRITE: 562500] [BLOCKS_CREATED: 1125000] 
Calc Command Text [ FIX ("Conversion Rate","No Period","Plan_A","No CO","No Agreement","No Supplier",@RELATIVE
("From Group1",0),@RELATIVE("ToCO Group1",0),"No From Currency","No To Currency") "All Product" 
(@CREATEBLOCK("No Product");)ENDFIX]