cancel
Showing results for 
Search instead for 
Did you mean: 

Validation transformation file

amine_lamkaissi
Active Contributor
0 Kudos

Hi guys,

I created a transformation file in BPC 10.1 to transfer data from BW Infocube to BPC model.

here is the transfrmation file:

*OPTIONS FORMAT = DELIMITED HEADER = YES DELIMITER = , AMOUNTDECIMALPOINT = . SKIP = 0 SKIPIF = VALIDATERECORDS=YES CREDITPOSITIVE=YES MAXREJECTCOUNT= ROUNDAMOUNT= *MAPPING RB_CATEGORY=*STR(Actual) RB_PRODUCT=0MATERIAL RB_ACCOUNT=ZACCOUNT RB_ENTITY=0COMP_CODE RB_SALESGRP=0SALES_GRP RB_AUDITRAIL=*STR(BWLOAD) RPTCURRENCY=*STR(LC) TIME=0CALMONTH SIGNEDDATA=ZAMOUNT *CONVERSION TIME=CV_MAS_TIME_BW.XLS

But, i have 0 data accepted even if the cube contains data. like something wrong in my file.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

former_member277290
Participant

Hi Amine,

Because you are loading from a BW InfoProvider, not a CSV file, try using

*NEWCOL(Actual) 

instead of

*STR(Actual) 

for your hard-coded values (Actual, BWLOAD, LC). For the same reason, the DELIMITER specification in the Options section is unnecessary. Try leaving it blank as just:

DELIMITER=

See if that helps. Kind Regards,

-Elliott

amine_lamkaissi
Active Contributor
0 Kudos

Thank you very much Elliott 🙂

Answers (4)

Answers (4)

former_member186338
Active Contributor

What chain is used??? If it's UI - what is the selection?

amine_lamkaissi
Active Contributor
0 Kudos

Hi Vadim,

No selection, i want to load all the content of cube.

Thanks

amine_lamkaissi
Active Contributor
0 Kudos

Validation status

amine_lamkaissi
Active Contributor
0 Kudos

Data in my infocube

amine_lamkaissi
Active Contributor
0 Kudos

transformation file

Conversion file