on 12-05-2016 11:27 PM
Below mapping in transformation file always goes to the default condition (Acct2). Any syntax errors in below statement?
ACCOUNT=*IF(sacct=*STR(purcase) then *str(ACCT1);*str(ACCT2))
Thanks
Found this note....
2353846 - Source dimension member is converted to upper case with error
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Transformation file:
ACCOUNT=sacct
*CONVERSION
ACCOUNT=AccountConv.xls
Conversion file (AccountConv.xls):
* js: (%external%.toString() == "purcase") ? "ACCT1" : "ACCT2"
or simply try:
purcase ACCT1
* ACCT2
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, not sure what's wrong with transformation (please provide details on your core BPC version and SP)
Workaround: use conversion file! In conversion you can change the string easy!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It works in case:
sacct=*STR(PURCASE) and PURCASE 221...
Correct?
Not working:
sacct=*STR(purcase) and purcase 221...
What about:
sacct=*STR(PURCASE) and purcase 221...
?
By the way, may be "purchase"?
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.
Please show your data file with header and some lines!
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.