on 09-13-2017 3:37 PM
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.XLSBut, i have 0 data accepted even if the cube contains data. like something wrong in my file.
Thanks.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What chain is used??? If it's UI - what is the selection?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
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.