on 10-23-2014 12:52 PM
I AM FACING A PROBLEM WHEN I RUN 2 ROUNDS IN ONE TRANSFORMATION FILE...
I need to distribute a source field in to BPC through making 2 conversion files... following is the data
Transformation file
*OPTIONS | ||||||||||||
FORMAT = DELIMITED | ||||||||||||
HEADER = YES | ||||||||||||
DELIMITER = , | ||||||||||||
AMOUNTDECIMALPOINT = . | ||||||||||||
SKIP = 0 | ||||||||||||
SKIPIF = | ||||||||||||
VALIDATERECORDS=YES | ||||||||||||
CREDITPOSITIVE=YES | ||||||||||||
MAXREJECTCOUNT= | ||||||||||||
ROUNDAMOUNT= | ||||||||||||
CONVERTAMOUNTWDIM=ZOUTPUT | ||||||||||||
*MAPPING | ||||||||||||
CATEGORY=*NEWCOL(ACT) | ||||||||||||
PAO=0COSTCENTER | ||||||||||||
TIME=0FISCYEAR | ||||||||||||
ZOUTPUT=0FUNDS_CTR | ||||||||||||
SIGNEDDATA=0DEB_CRE_LC | ||||||||||||
*CONVERSION | ||||||||||||
PAO=PAO_CONVER.XLS | ||||||||||||
ZOUTPUT=ZOUTPUT_CONVER.xls | ||||||||||||
*OPTIONS | ||||||||||||
FORMAT = DELIMITED | ||||||||||||
HEADER = YES | ||||||||||||
DELIMITER = , | ||||||||||||
AMOUNTDECIMALPOINT = . | ||||||||||||
SKIP = 0 | ||||||||||||
SKIPIF = | ||||||||||||
VALIDATERECORDS=YES | ||||||||||||
CREDITPOSITIVE=YES | ||||||||||||
MAXREJECTCOUNT= | ||||||||||||
ROUNDAMOUNT= | ||||||||||||
CONVERTAMOUNTWDIM=ZOUTPUT | ||||||||||||
*MAPPING | ||||||||||||
CATEGORY=*NEWCOL(ACT) | ||||||||||||
PAO=0COSTCENTER | ||||||||||||
TIME=0FISCYEAR | ||||||||||||
ZOUTPUT=0FUNDS_CTR | ||||||||||||
SIGNEDDATA=0DEB_CRE_LC | ||||||||||||
*CONVERSION | ||||||||||||
PAO=PAO_CONVER.XLS | ||||||||||||
ZOUTPUT=AMOUNT_CONVER.XLS Conversion file 1 (PAO=PAO_CONVER.XLS)
|
Conversion file 2 (ZOUTPUT=ZOUTPUT_CONVER.xls)
ID0001 | FX01 | VALUE*1 |
ID0002 | FX01 | VALUE*1 |
ID0003 | FX01 | VALUE*.40 |
DG0001 | FX02 | VALUE*1 |
DG0002 | FX02 | VALUE*1 |
Conversion file 3 (ZOUTPUT=AMOUNT_CONVER.XLS)
EXTERNAL | INTERNAL | FORMULA |
ID0003 | FX02 | VALUE*.60 |
I am getting the following error
[Start validating transformation file] | |
Validating transformation file format | |
Start validation transformation 1/2 | |
Validating options... | |
Validation of options was successful. | |
Validating mappings... | |
Validation of mappings was successful. | |
Validating conversions... | |
Validation of the conversion was successful | |
Start validation transformation 2/2 | |
Validating options... | |
Validation of options was successful. | |
Validating mappings... | |
Validation of mappings was successful. | |
Validating conversions... | |
Validation of the conversion was successful | |
Creating the transformation xml file. Please wait... | |
Transformation xml file has been saved successfully. | |
Begin validate transformation file with data file... | |
[Start test transformation file] | |
Validate has successfully completed | |
ValidateRecords = YES | |
Reject count: 0 | |
Record count: 6 | |
Skip count: 0 | |
Accept count: 6 | |
0COSTCENTER is not a valid command or column 0COSTCENTER does not exist in source | |
Validation with data file failed |
Hi Rai,
As far as I know only single round is allowed.
Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
I followed this experiment from the post of Scott >>>link in below
Well in this post several people mentioned that this cannot be done in BPC 7 but I am currently using BPC 10...
The real issue is as following in this below link as following ...
I would really appreciate, if you can go through it and let me know if there is any possible solution
Regards
Sohaib
Hi Rai,
Are you loading master data or transaction data?
Do you have 0COSTCENTER in your infocube?
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
3 | |
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.