EPM10NW: JS formulas not working conversion file ??

[Former Member]

Hi Experts,

I put in my transformation file:

CONVERT_INTERNAL = NO

In my conversion file :

EXTERNAL	INTERNAL
*	js:%external%.replace("/","")
*	js: %external%.split("/").join("")
01COM/BOM/01	*SKIP
02COM/BOM/02	*SKIP

But, I still cannot load my dimension, although, the transformation file is correctly validated.

Here is the error :

Task name MASTER DATA TARGET:

Error in Admin module or a component used by Admin module

Dimension member 01COM/BOM/01 is an invalid member ID

Dimension member 02COM/BOM/02 is an invalid member ID

Hope someone can help,

Regards,

Olivia.

[Former Member]

Hi Olivia,

You have 4 lines in the conversion file.

1st and 2nd lines are doing the same operations. So, please keep the 1st line. Delete the second line.

Since, in the first line, you have replaced all the "/" with "", there is no member 01COM/BOM/01 available anymore; since it has "/" in it. So, keep 3rd and 4th lines at the top.

Or probably, you can use the below code in INTERNAL:

*IF(%external% = 01COM/BOM/01 then *SKIP; %external% = 02COM/BOM/02 then *SKIP; js:%external%.replace("/",""))

The above code compresses all the line of your conversion file in to 1.

Hope this helps.

[Former Member]

Hi Nilanjan,

Tks for this.

Nevertheless, but this so strange, because, even if I leave only one line in my conversion files, while i execute my package, i get this :

Task name MASTER DATA SOURCE:

Record count:                                               182

Task name TEXT SOURCE:

Record count:                                               182

Task name CONVERT:

No 1 Round:

Reject count: 0

Record count: 182

Skip count: 0

Accept count: 182

Task name MASTER DATA TARGET:

Error in Admin module or a component used by Admin module

Dimension member 01COM/BOM/01 is an invalid member ID

Dimension member 02COM/BOM/02 is an invalid member ID

model: Sales. Package status: ERROR

... and so, no account is loaded....

I tried your formula above ; and also your followed your advices. but...

Thks,

Olivia.

[Former Member]

Hi Olivia,

Is 01COM/BOM/01 a master data in the BW characteristic or is it 01/COM/BOM/01?

[Former Member]

It is "01COM/BOM/01"

It seems that the JS is not read... by the system 😞

I also tried this formula, found int he SDN, but , failed, getting the same error :

js: %external%.split("/").join("")

Tks,

Olivia.