Skip to Content
avatar image
Former Member

BPC 10 NW - Error converting Invalid Character when loading BW Master Data

Hi Experts,

I've been trying to load BW Master Data from BW to BPC Dimension through Transformation/Conversion File.

Transformation File:

Conversion File - NODENAME:

Conversion File - ID:

My BW InfoObject:

I've tested the command through http://www.w3schools.com/js/tryit.asp?filename=tryjs_string_replace, an it works there.

When I try to Execute through Run Package, it gives me an error:

----

Task name CONVERT:

No 1 Round: Error in Admin module or a component used by Admin module

Dimension member TOT-ADM/MG is an invalid member ID in dimension TEST_ORGSTRUC

model: TEST_PAYROLL. Package status: ERROR

----

I've tested for usual characters and the command worked. I've tested only for second record and it loaded without conversion, as intended.

What can be done to convert correctly this kind of value?

Regards,

Maurício.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Nov 23, 2016 at 04:19 PM

    The correct js for ID:

    js:%external%.toString().replace(/\s+/g,"").replace(/\/+/g,"")

    And remove NODENAME - incorrect here!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2016 at 04:01 PM

    Sorry, but what do you mean by NODENAME in CONVERSION section???

    Looks like you are loading master data, not the hierarchy - 2 separate processes!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2016 at 04:29 PM

    Or using [...]

    js:%external%.toString().replace(/[\s\/]/g,"")

    In [] 2 symbols are defined:

    \s - space

    \/ - / (has to be used prefixed with \)

    g - all matches of each symbol

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2016 at 04:35 PM

    Also I suspect that with your ID's the following will not work correctly:

    Add comment
    10|10000 characters needed characters exceeded