on 05-26-2018 8:01 AM
Hello Experts,
I have created a transformation file in BPC to extract transaction data from BW Infocube. To test, if it working correctly or not, I tried to validate and process the file and used the respective cube data from the selection.
I am getting the below attached error:-
From the log displayed above, it seems that there is no issue with mappings and conversions.
Below is the transformation file:-
*OPTIONS
FORMAT = DELIMITED
HEADER = YES
DELIMITER = ,
AMOUNTDECIMALPOINT = .
SKIP = 0
SKIPIF =
VALIDATERECORDS=YES
CREDITPOSITIVE=YES
MAXREJECTCOUNT=-1
ROUNDAMOUNT=
*MAPPING
ACCOUNT=ZACCOUNT
AUDITTRAIL=ZAUDITTR
CATEGORY=ZCATEGORY
COST_CENTER=ZCOSTCTR
DRIVER=*IF(ZACCOUNT=*STR(0042500003) THEN *STR(S0010);ZDRIVER)
ENTITY=ZENTITY
FLOW=ZFLOW
PRODUCT=ZPRODUCT
REGION=ZWW001
RPTCURRENCY=ZCURRENCY
TIME=ZZTIME
VALUATION=ZVALTN
VENDOR=ZZVENDOR
SIGNEDDATA=ZAMOUNT
*CONVERSION
TIME=TIME.xls
REGION=STATE.xls
FLOW=FLOW.xls
ACCOUNT=ACCOUNT.xls
PRODUCT=PRODUCT.xls
We are using BPC 10.1 NW and BW 740 with Patch 11.
MS-Excel 2016 64-bit and EPM Addin SP 27 Patch 2.
Pls help experts.
Regards
Achyut Sharma
Try to perform data load and post the log!
Also post screenshots of conversion files.
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.