List of Javascripts used in Conversion File

[Former Member]

Hello Experts,

Can someone point me to right discussion which lists of all the Javascripts which can be used in a Conversion File.

Also, can I read a Member Value(External) and map it to a Property?

Thanks,

Mulak

[former_member186338 · Accepted solution]

Hi Mulak,

You can use any JavaScript method, function, etc... But it has to be single line expression!

Please define your requirements!

"I read a Member Value(External) and map it to a Property?" - yes, but explain more...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Basically, I am trying to load the below Master Data from an InfoObject into a Dimension with Region as a Property.

TX_1001

NY_2001

CA_3001

The above all will be IDs in BPC.  But using the same ID, I would like to populate the Dim Property Region for each ID.  For ex: TX_1001 should populate TX as the Region Property, NY_2001 should populate NY for the Region Property, etc.

I believe I have to put in the mapping in Trf file as below:

ID = ID

REGION=ID

CONVERSION

REGION=Conversion File Name.xls

In the Conversion file I would put

EXTERNAL= *

INTERNAL =?

Hope I have explained it in a simple manner?

Thanks,

Mulak

[former_member186338 · Accepted solution]

I prefer to use JavaScript like:

INTERNAL:

js:%external%.toString().substr(0,2)

Vadim

[Former Member · Accepted solution]

Thanks Vadim, That's what I was planning to use, just wanted to check with you.  Thanks for your feedback.