Conversion File - Append letters to the external data

[Former Member]

Hi gurus,

I want to load transaction data from a cube, but my master data is different from the transaction data.

In master data - in account dimension , I have following element aaa100000, aaa100001, aaa100002 .... ... ..

But in transaction data - for account dimension, I have following 100000, 100001, 100002 .. . ...

So in each of the internal data (master data of dimension) there are additional word "aaa" attached.

How can I load data and remove the additional field in master data of BPC dimension.

Thanks in advance

Sanjay

[Former Member]

Hi,

You can make use of the java scripts in the conversion file for your purpose. Please refer to the below link for reference.

http://help.sap.com/saphelp_bpc70sp02/helpdata/en/81/94a8a5febd40268d5c59b4fc31be37/content.htm

Hope this helps.

[Former Member]

Thanks Nilanjan,

I have tries it but still it is giving same error.

Can you tell what exactly should I write. Or how can I use Excel commands in convrsion file.

THanks for replying

[Former Member]

You can try using

js: %external%.concat("XXXXXXXX"")

What did you use? And what was the error?