Problem loading hierarchy from BW to BPC + Javascript

[#1]

Hello experts,

I've been facing an issue trying to load a hierarchy (0COSTCENTER) from BW to BPC. The ID of the nodes are 0CO_AREA + " " + 0COSTCENTER. That space is an error on productive system, and cannot be changed on ERP side, so we want to handle it in the BPC layer.

First of all, in the first chain (/CPMB/IMPORT_IOBJ_MASTER), I constructed artificially the same structure 0CO_AREA + 0COSTCENTER (the space is already there) for both costcenter and hierarchy nodes (created at base level initially). Here, in order to remove the space, I applied the well-known statement in my CF (and works like a charm):

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

But, when I'm trying to load the hierarchy (/CPMB/IMPORT_IOBJ_HIER chain), I try to apply the same CF rule to the field NODENAME, but it's like is not taking it, throwing the following error:

As you can see, it tries to lookup for the original nodes (with space), but my expected behavior would be that once the NODENAME is treated by CF, just after that would be the moment for lookup for the nodes and create the hierarchy. I tried to put any other rule like:     *    "hello", but it doesn't enter into any CF rule.

I attach SS from my TF and CF:

Any sugestions? Since 0COSTCENTER it's an standard InfoObjetc, I wouldn't like to touch any transformations from BW side in order to make it work.

Thanks in advance!

[former_member186338 · Accepted solution]

Ups, what about conversion for PARENT to remove spaces?

Same as for NODENAME!

Vadim

[Former Member · Accepted solution]

Hello Vadim,

Thanks for your response. And yes, before posting this topic yesterday I tried that, but got same results. The only thing is that I pointed to the same sheet NODE_ID for both NODENAME and PARENT fields. I'll try with 2 different conversion sheets but anyway it should work if I point to the same and it doesn't.

[former_member186338 · Accepted solution]

Ups! I see typo error!

Not NODE_NAME but NODENAME in CONVERSION section!!!

Vadim

[Former Member · Accepted solution]

Lol no way hahahaha... I'll correct and I'll tell you

Thanks!!