Skip to Content

BPC 10.1 NW - CONVERSION FILE

hello,

BPC 10.1NW ,EPM SP28 P3

i want to load values from 106002 :106007 (external data mapping) to PROD1 (internal). I tried below formula in "INTERNAL" column. but throws an error when i run DM pkg.

is there any syntax error in below formual?

js:If((parseint(%external%)>106001 AND parseint(%external%)<106008)?"PROD1":"*SKIP")

Thanks

Rekha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 23, 2017 at 03:18 PM

    modified as below but still get an evaluation error

    js:*if(%external% == "0000106003") "PROD1"

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21, 2017 at 09:04 PM

    "is there any syntax error in below formual?" - yes!

    Please read ANY online JavaScript manual!

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21, 2017 at 09:57 PM

    Where do you read about combination of "if" and ternary operator???? Why do you write "if"?????

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 26, 2017 at 02:14 PM

    *SKIP can't be used inside JavaScript!

    The simple way to achieve your goal is to use direct mapping without JavaScript:

    0000106003 PROD1

    0000106004 PROD1

    0000106005 PROD1

    0000106006 PROD1

    0000106007 PROD1

    * *skip

    Add comment
    10|10000 characters needed characters exceeded

    • P.S. Without SKIP the JavaScript will be:

      js:parseInt(%external%)>106001 && parseInt(%external%)<106008 ? "PROD1" : "NONE"

      JavaScript is a case sensitive language!