Skip to Content
0
Former Member
Apr 18, 2011 at 07:31 PM

Script logic needs to be fixed to work on data records with 0 value

25 Views

Hi,

The following script calculates the CTA based on the difference of the USD and the GC values.

USD values are the currency translated values(LC ->USD) in BPC.

GC values are coming from ECC into the "GC" groups dimension member.(We are uploading both LC, GC values from ECC into BPC)

The script works well when there is data in the LC and the GC members.

But when there is no data (amount 0.0)in the GC column in the upload file, those records are ignored by the system (in the WHEN stmnt) while calculating the difference, as a result of which the CTA amount is not coming correct.

The data can have either GC or LC blank, so even by swapping the GC with USD in the code did not help.

Can you suggest how to have the system filter the 0 values records too and calculate the CTA diff on them as well(USD - 0= USD value)?

I tried using WHEN_REF_DATA=MASTER_DATA,But the pacakge kept running for 12hrs before getting cancelled. (went into some sort of loop I guess)

*XDIM_MEMBERSET KT_GROUPS=GC

*XDIM_ADDMEMBERSET KT_GROUPS=USD

*XDIM_MEMBERSET KT_A_DATASRC=ECC_DATA

*XDIM_ADDMEMBERSET KT_A_DATASRC=CURR_TRANS

*XDIM_MAXMEMBERS KT_A_ACCOUNT=50

*XDIM_MEMBERSET KT_TRANSTYPE=F_TOT

*XDIM_ADDMEMBERSET KT_TRANSTYPE=F_CTA_C, F_100, F_120,F_CTA_H,F_CTA_C_PL

*WHEN KT_GROUPS

*IS "GC"

*WHEN KT_A_ACCOUNT.RATETYPE

*IS "AVG"

*WHEN KT_TRANSTYPE

*IS "F_120"

REC(EXPRESSION=(([KT_GROUPS].[USD])-%VALUE%)

-1),KT_A_ACCOUNT=312000,KT_TRANSTYPE=F_CTA_C,KT_GROUPS=GC,KT_A_DATASRC=CURR_TRANS)

*REC(EXPRESSION=(([KT_GROUPS].[USD])-%VALUE%),KT_TRANSTYPE=F_CTA_C,KT_GROUPS=GC,KT_A_DATASRC=CURR_TRANS)

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

-


Need your help in fixing this script to make it more generic (to work even with 0.0 data records)

Thanks

Apeksha