Conversion File issue

[vishal_parmar2]

Hello BPC Champs,

I am stuck in a problem and need your help.

I am creating a transformation file to import 0coorder info object Master Data to BPC dimension.

I created Transformation file for it, and a conversion file for the same.

I want to replace all "/" by "_" in 0coorder string. Hence in my conversion file I wrote a Java Script as per below.

EXTERNAL INTERNAL FORMULA

/ js:%external%.toString().replace("/","_")

Above Script is not working for me.

And while validating my Transformation file it is giving me invalid member id errors for the members having "/" in string.

So I guess Conversion file is not working in this case.

Please Help !!

Thanks,

Vishal Parmar.

[Former Member · Accepted solution]

Hi Vishal,

Please refer to the following link which shows the same issue which might be helpful to you:

Rgds,

Poonam

[james_lim]

Hi,

I am not sure but could you try %external%.replace("/", "_"); ?

regards,

James Lim