cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation File

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

loading from a flat file ..transaction data.

Former Member
0 Kudos

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

Former Member
0 Kudos

Sorry but without details I cannot help you!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Found this note....

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

Answers (5)

Answers (5)

former_member186338
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

Please show your data file with header and some lines!