on 03-06-2017 11:57 AM
Hi Bpc Friends
I can't figure out how some records in BPC has been generated.
I went to see the Audit Data Changes and I found the record that I was looking for and it says Business Rule
I can't understand which Business Rule is being executed.
I went to see the Data Manager and I found that the user load some data running the default logic.
The default logic call the Fxtrans, but the fxtrans it says CURRENCY= GBP
so how Can I understand who is generating these USD records?
*SELECT(%CURRENCYVARIANT%,"ID","RPTCURRENCY","[REPORTING]='Y'")
*FOR %CATS%=%CATEGORY_SET%
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATS%
CURRENCY = GBP //%CURRENCYVARIANT%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = [ENTITY=%ENTITY_SET%]
*ENDRUN_PROGRAM
*NEXT
Thanks
Michele
Please provide full default.lgf script!
You can also look on default.lgf log in UJFS for this particular user. Do you know how to find it?
P.S. I suspect that this line is incorrect:
RATEENTITY = GLOBAL
Has to be:
RATEENTITY = Global (Case sencitive)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim
I have checked the log but there is not trace of USD data
The default logic is that:
*INCLUDE RETAINED_EARNINGS
*INCLUDE FLOW_BALANCING
*INCLUDE FXTRANS
and the three scripts are:
*INCLUDE RETAINED_EARNINGS
*SELECT(%REDSRC%,"[ID]",DATASRC,"DATASRC_TYPE='I'")
*XDIM_MEMBERSET ACCOUNT=BAS(PLAFTUS)
*XDIM_MEMBERSET FLOW=F_CLO
*XDIM_MEMBERSET DATASRC=%REDSRC%
*XDIM_MEMBERSET GROUPS=G_NONE
*XDIM_MEMBERSET RPTCURRENCY=LC,GBP,USD,EUR
*XDIM_MEMBERSET INTCO=BAS(TOTAL_INTERCO)
*XDIM_MEMBERSET COSTCATEGORY= BAS(ALL_COSTCATS)
*XDIM_MEMBERSET PRODUCTGRP=BAS(ALL_PRODGRPS)
//*XDIM_MEMBERSET CHANNEL=<ALL>
*WHEN DATASRC
*IS "MJ_GSALLOC"
*REC(ACCOUNT="RET_EARN_CY",INTCO="I_NONE",COSTCATEGORY="NO_COSTCAT",PRODUCTGRP="NO_PRODGRP")
*REC(ACCOUNT="RET_EARN_CY",INTCO="I_NONE",COSTCATEGORY="NO_COSTCAT",PRODUCTGRP="NO_PRODGRP",FLOW="F_RES")
*ELSE
*WHEN RPTCURRENCY
*IS "LC"
*REC(ACCOUNT="RET_EARN_CY",INTCO="I_NONE",COSTCATEGORY="NO_COSTCAT",PRODUCTGRP="NO_PRODGRP")
*REC(ACCOUNT="RET_EARN_CY",INTCO="I_NONE",COSTCATEGORY="NO_COSTCAT",PRODUCTGRP="NO_PRODGRP",FLOW="F_RES")
*ENDWHEN
*ENDWHEN
*COMMIT
*INCLUDE FLOW_BALANCING
*XDIM_MEMBERSET ACCOUNT=BAS(MNG_BS)
*XDIM_MEMBERSET DATASRC=BAS(CUP_IFRS)
*XDIM_MEMBERSET FLOW=F_ERR,F_NONE
*XDIM_MEMBERSET GROUPS=G_NONE
*XDIM_MEMBERSET RPTCURRENCY=LC
*WHEN DATASRC
*IS <> "MJ_GSALLOC"
*REC(FACTOR=0)
*ENDWHEN
*COMMIT
// Calculate different between F_CLO and F_CLO_CALC and post to F_ERR for flowed accounts and F_NONE for non flowed accounts
*XDIM_MEMBERSET ACCOUNT=BAS(MNG_BS)
*XDIM_MEMBERSET DATASRC=BAS(CUP_IFRS)
*XDIM_MEMBERSET FLOW=BAS(F_CLO_CALC)
*XDIM_ADDMEMBERSET FLOW=F_CLO
*XDIM_MEMBERSET GROUPS=G_NONE
*XDIM_MEMBERSET RPTCURRENCY=LC
*WHEN DATASRC
*IS <> "MJ_GSALLOC"
*WHEN ACCOUNT.FLOWED
*IS Y
*WHEN FLOW
*IS F_CLO
*REC(FLOW=F_ERR)
*IS BAS(F_CLO_CALC)
*REC(FACTOR=-1,FLOW=F_ERR)
*ENDWHEN
*ELSE
*WHEN FLOW
*IS F_CLO
*REC(FLOW=F_NONE)
*IS BAS(F_CLO_CALC)
*REC(FACTOR=-1,FLOW=F_NONE)
*ENDWHEN
*ENDWHEN
*ENDWHEN
*COMMIT
*INCLUDE FXTRANS
*SELECT(%CURRENCYVARIANT%,"ID","RPTCURRENCY","[REPORTING]='Y'")
*FOR %CATS%=%CATEGORY_SET%
*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CATS%
CURRENCY = GBP //%CURRENCYVARIANT%
TID_RA = %TIME_SET%
RATEENTITY = GLOBAL
OTHER = [ENTITY=%ENTITY_SET%]
*ENDRUN_PROGRAM
*NEXT
P.S. In general the scripts are strange - the scope of default.lgf (changed values) is not used in the script at all...
Please read:
Sorry, but you have to test everything yourself!
Even if user is entering data in LC then in the first script the scope is completely redefined!
*XDIM_MEMBERSET RPTCURRENCY=LC,GBP,USD,EUR
The scripts are written incorrectly, have to be redeveloped!
If you want some help with default.lgf you need to clearly specify:
scope1 of send data -> calculation logic -> where to store result
scope2 of send data -> calculation logic -> where to store result
...
Sorry, but now it's your logic 🙂 And it's incorrect!
User | Count |
---|---|
16 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.