Skip to Content
0
Former Member
Feb 10, 2011 at 06:33 PM

Use of JavaScript with Conversion file

120 Views

To be clear I will explain my issue in below example

e.g.

I want to convert costcenter hierarchy nodename like 1000C2500 to C2500

I use conversion file as below

External: ?????????

Internal: js:(%external%.substring(4,9))

'This works fine.

However,

If i want to convert Nodename like 1000101000_00 to 101000_00 by using same concept

i.e.,

External: ?????????????

Internal: js:(%external%.substring(5,13))

does not work, simply returns original external value.

Any suggestions?

Pl Note: I have gone through the wiki "How to import Master Data and Hierarchies in to BPC" and implementing scenario1. And have tried many variations including using a combination of Hierarchy and Conversion files

Kara.