Skip to Content
avatar image
Former Member

Validation transformation file

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Sep 13, 2017 at 10:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 13, 2017 at 08:31 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2017 at 02:39 PM

    transformation file

    Conversion file

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2017 at 02:41 PM

    Data in my infocube

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2017 at 04:00 PM

    Validation status

    Add comment
    10|10000 characters needed characters exceeded