SET TRACEID

The SET TRACEID calculation command enables multiple Essbase users to trace their calculations using SET TRACE in a calculation script. Each person issuing a trace request has their own unique tracing file in the cube directory.

This command enables you to use SET TRACE command and write the results to your own tracing file that will not be overwritten by others.

Syntax

SET TRACEID uniqueId

Parameters

uniqueId: A unique ID to append to the calc tracing log file name, to prevent it being overwritten by others who are also tracing their calculations.

Notes

Trace output is logged to calc_trace_uniqueID.txt in the cube directory.
There can be only one SET TRACEID in a calc script, and it should be positioned at the top before any SET TRACE command (otherwise, it will be ignored). The TRACEID applies to all traces in the calc script.
Refer to SET TRACE for full information on calc tracing.

Example

In the following example, SET TRACEID is set with an ID of id001, prior to the start of any SET TRACE command. This causes the tracing output file to be saved as calc_trace_id001.txt, for all traces in the calc script.

SET TRACEID "id001"
SET TRACE (@CHILDREN("Qtr1"), "Cola", "New York", "Actual", "Ending Inventory");                                
FIX(@LEVMBRS("Year",0), "Cola", "New York", "Actual")
"Opening Inventory" (
    IF(NOT @ISMBR("Jan"))
       "Opening Inventory"=@PRIOR("Ending Inventory");
    ENDIF                                
    "Ending Inventory" = "Opening Inventory" + "Additions" - "Sales";
)                           
ENDFIX
SET TRACE (@CHILDREN("Qtr1"), "Cola", "Oregon", "Actual", "Ending Inventory");                                
FIX(@LEVMBRS("Year",0), "Cola", "Oregon", "Actual")
"Opening Inventory" (
    IF(NOT @ISMBR("Jan"))
       "Opening Inventory"=@PRIOR("Ending Inventory");
    ENDIF                                
    "Ending Inventory" = "Opening Inventory" + "Additions" - "Sales";
)                           
ENDFIX