Skip to Content
0
Sep 13, 2017 at 02:37 PM

Validation transformation file

174 Views

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.