No data accept into BPC after uploading process

[former_member437100]

Hi expert,

I'm working on BPC 10.1 and EPM add in version: 10.0 SP27 Patch1. Net4

I'm facing the issue when I try to validate the transformation file by using flat file below "Capture A"

Below is script in my transformation file. I found the problem is "PCTR" dimension because when I try to validate, it's success but no data records or accepts (show in capture B) but when I just change PCTR = *NEWCOL(NOPCTR), it's working fine and data is uploaded into the system (show in capture C)

*OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER =, AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT= -1 ROUNDAMOUNT= *MAPPING CATEGORY=*NEWCOL(CIT_ACCRUAL) TIME=*COL(2) ENTITY= *COL(3) PLANT=*NEWCOL(NOPLNT) PCTR=*IF(*COL(4)=*str()then*str(NOPCTR);*COL(4)) ACCOUNT=*COL(6) MATERIAL=*NEWCOL(NOMAT) BOINO=*NEWCOL(NOB) TAXRATE=*NEWCOL(100) TRDPAR=*NEWCOL(NOTRD) FLOW=*NEWCOL(F999) CIT_PROCESS=*NEWCOL(AFD405) RPTCURRENCY=*COL(13) KF=*NEWCOL(AMT) SIGNEDDATA=*COL(14) *CONVERSION ENTITY=ENTITY_CONV.xls RPTCURRENCY=CURRENCY_CONV.xls BOINO=BOINOFA_CONV.xls ACCOUNT=ACCOUNT_CONV_FA 5.XLS

Use >> PCTR=*IF(*COL(4)=*str()then*str(NOPCTR);*COL(4))

Use >> PCTR = *NEWCOL(NOPCTR)

I'm not sure what's wrong with my script in transformation file that why I cannot use "if function" . Any experts has the recommend, please let me know

Thanks

[former_member186338]

Sorry, but do you look on your post results? Line breaks are missing in transformation file text - making your question unreadable! Unreadable question - no answer!

P.S. To post texts like transformation file text use CODE button!