Conversion file is not taking into account - SAP BPC 10 NW

[Former Member]

Hello experts,

I am trying to load master data from BW cubes to BPC.

The format of the ID's I want to load is "OI10.14.0001" for example.

I have a transformation file and also a conversion file that replaces de "." to "_" .

The problem is when I execute de package (with sucess) the ID loaded are:

"OI10140001"

What am I doing wrong?

I am sending the transformation file and conversion file.

Regards,

Nadine

[Former Member]

I understood, although the code we see is "OI10.14.0001" the internal code in BW cube is OI10140001.

How can I divide this? Can I use LEFT() and RIGHT() formulas in conversion file?

Regards,

Nadine

[former_member186338]

%external%.toString().slice(0,4)+"_"+%external%.toString().slice(4,6)+"_"+%external%.toString().slice(6,10)

Vadim

[former_member186338]

Or in transformation file (MAPPING):

ID=ID(1:4) + *Str(_) + ID(5:6) + *Str(_) + ID(7:10)

Without conversion

[Former Member]

Thanks Vadim,

We solve the error by chosing other field to load de ID, the external code 0WBS_ELM_EXT.

Regards,

Nadine

[former_member186338]

Hi Nadine,

The code looks correct, may be conversion js can be like:

%external%.toString().replace(/\./g,"_")

global replacement of all "." to "_"

Vadim