Transformation File

[Former Member]

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

[Former Member]

Just from a single line..how are we suppose to understand the issue??? What is the transformation file for? Master transaction? loading from flat file , BW?? screenshots!

Please provide all details!

JP

[Former Member]

loading from a flat file ..transaction data.

[Former Member]

want to know if there is any syntax error in the statement i posted above

[Former Member]

Sorry but without details I cannot help you!

[Former Member · Accepted solution]

Found this note....

2353846 - Source dimension member is converted to upper case with error

[former_member186338]

Transformation file:

ACCOUNT=sacct

*CONVERSION

ACCOUNT=AccountConv.xls

Conversion file (AccountConv.xls):

* js: (%external%.toString() == "purcase") ? "ACCT1" : "ACCT2"

or simply try:

purcase ACCT1

* ACCT2

[former_member186338]

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!

[Former Member]

HANA SPS12 Revision 122.02

NW 7.4 SPS15

BPC 10.1 SP10 Patch 2

EPM Addin SP25

how we map it in Conv file?

[former_member186338]

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"?

[Former Member]

sacct=*STR(PURCASE) and PURCASE 221... - >This works.all caps in both trans file & data file.

sacct=*STR(PURCASE) and purcase 221... ->this combination also didnt work

yes its a typo when i created this - it should be purchase

[Former Member]

Attached data file screenshot ... when i change sacct values to all caps in data file and in transformation file it works. but it doesnt work when there is lowercase

[former_member186338]

Please show your data file with header and some lines!