BPC 10 Javascript unique concatenation of 2 BW IO combinations to give an output - please help

[mark_dean]

I am loading BW transaction data to a BPC 10 Model, and I want to achieve the following. There are 2 inbound InfoObjects e.g. an Account and Distribution Channel, and all the possible combinations of these 2 IO's concatenated together form an output SALESACCOUNT dimension member.

Somehow I want to put all the unique contatenated string combinations in the external column of the BPC conversion file to give the required SALESACCOUNT output in the Internal column.

I have looked through some javascript blogs but still cannot find a way to do this.

Any help please?

Thanks

Mark

[former_member186338 · Accepted solution]

But why you are looking for Javascript?

Just use in transformation file

ID = 0ACOUNT + 0DISTR or what you have to perfom concatenation and then in conversion file list all possible combinations.with required target in internal.

If you have some logic to convert concatenated string to internal then you can use Javascript. But you are not explaining the required logic.

[mark_dean]

Thank you Vadim, worked perfectly