Skip to Content
avatar image
Former Member

Transformation File

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Dec 07, 2016 at 03:23 PM

    Found this note....

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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2016 at 07:03 AM

    Please show your data file with header and some lines!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2016 at 05:18 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 06, 2016 at 06:07 PM

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Dec 06, 2016 at 07:04 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded

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

  • Dec 06, 2016 at 09:04 PM

    Transformation file:

    ACCOUNT=sacct

    *CONVERSION

    ACCOUNT=AccountConv.xls

    Conversion file (AccountConv.xls):

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

    or simply try:

    purcase ACCT1

    * ACCT2

    Add comment
    10|10000 characters needed characters exceeded