Hello,
As a background :
UJKT has 3 options for execution (Validate, Execute, Execute (Simulate) ).
When the 'Execute' option is used, data is actually written back to the cube/s and the log shows the details including a table of dimensions and amounts written back like below.
---------------------------
CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 455.65 ms. 12 RECORDS QUERIED OUT.
QUERY REFERENCE DATA
QUERY TIME : 396.95 ms. 12 RECORDS QUERIED OUT.
CALCULATION TIME IN TOTAL :89.04 ms.
12 RECORDS ARE GENERATED.
CALCULATION END.
ENDWHEN ACCUMULATION: 12 RECORDS ARE GENERATED.
DATA TO WRITE BACK:
Z_ACCOUNT Z_COMPANY Z_COSTCENTER Z_DATASRC Z_DRIVER Z_INTCO Z_RPTCURRENCY Z_TIME Z_TRANSTYPE Z_VERSION SIGNEDDATA
510090 1000 1301 MANUAL NONE I_NONE LC 2012.JUN F_NONE BUDGET 0.00
510090 1000 1301 MANUAL NONE I_NONE LC 2012.FEB F_NONE BUDGET 0.00
510090 1000 1301 MANUAL NONE I_NONE LC 2012.NOV F_NONE BUDGET 0.00
--------------------------------
When the 'Execute (Simulate)' option is used data is not written back. The log shows only the number of records that would be generated but not the details of dimensions and amounts.
---------------
CALCULATION BEGIN:
QUERY PROCESSING DATA
QUERY TIME : 452.84 ms. 12 RECORDS QUERIED OUT.
QUERY REFERENCE DATA
QUERY TIME : 1217.84 ms. 12 RECORDS QUERIED OUT.
CALCULATION TIME IN TOTAL :90.03 ms.
12 RECORDS ARE GENERATED.
CALCULATION END.
----------------
Is there any way to get the table of dimensions and amounts that would be written back in the log when running in simulation mode?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.