Skip to Content
0
Aug 06, 2016 at 04:21 AM

How to debug Script logic with value

244 Views

Hi expert,

I am working on support project and need to debug script ...

for debugging i am using UJKT and able to only verify that script syntax is correct or not but not able to get the value for example

i have salesvalue, price, quantity

now logic is

sales values=price*quantity

so i have a script

*XDIM_MEMBERSET ACCOUNT_RE842016 = SALVALUE ,SALPRICE, SALQTY

*WHEN ACCOUNT_RE842016

*IS SALQTY

*REC(EXPRESSION = %VALUE%*[ACCOUNT_RE842016].[SALPRICE],[ACCOUNT_RE842016].[SALVALUE])

*ENDWHEN

*COMMIT


After using UJKT


i am getting result on log but not values


On Log

LGX:

*XDIM_MEMBERSET ACCOUNT_RE842016 = SALVALUE ,SALPRICE, SALQTY

*WHEN ACCOUNT_RE842016

*IS SALQTY

*REC(EXPRESSION = %VALUE%*[ACCOUNT_RE842016].[SALPRICE],[ACCOUNT_RE842016].[SALVALUE])

*ENDWHEN

*COMMIT

-------------------------------------------------------------------------------------------------------------------------------------

LOG:

FILE:\ROOT\WEBFOLDERS\PKT_RELIANC_8_4_2016 \ADMINAPP\Reliance_Finance8416\TEST.LGF

USER:SAPUSER

APPSET:PKT_RELIANC_8_4_2016

APPLICATION:Reliance_Finance8416

[INFO] GET_DIM_LIST(): I_APPL_ID="Reliance_Finance8416", #dimensions=8

ACCOUNT_RE842016,CATEGORY,ENTITY_RE842016,MEASURES,RELI_AUDIT842016,REL_INTERO842016,RPTCURRENCY,TIME

#dim_memberset=1

ACCOUNT_RE842016:SALVALUE,SALPRICE,SALQTY,3 in total.

REC :%VALUE%*[ACCOUNT_RE842016].[SALPRICE]

CALCULATION BEGIN:

QUERY PROCESSING DATA

QUERY TIME : 844.00 ms. 69 RECORDS QUERIED OUT.

QUERY REFERENCE DATA

QUERY TIME : 1033.00 ms. 138 RECORDS QUERIED OUT.

CALCULATION TIME IN TOTAL :73.00 ms.

69 RECORDS ARE GENERATED.

CALCULATION END.

SCRIPT RUNNING TIME IN TOTAL:2.29 s.


I am giving param as

SALPRICE=10

SALQTY=15


BUT ANY WHERE IN LOG I AM NOT GETTING


SALVALUE=10*15=150


ANY IDEA THAT HOW TO TEST


PLEASE FIND ATTACHED SCREEN ALSO






Attachments

Untitled.jpg (198.5 kB)