Two key figures to one sign data

[Former Member]

Hi Experts,

I am encountering with one problem need to trim and map

My scenario is like this,......i have to load data from COPA to BPC one application, in copa i have two key figures one is QTY and one is Amount, here is an example

I need to map 0COSTELMNT to Account in BPC,

now my data is like this in BI COPA

Costelement Material AMount QTY

00004105000 XXXX 100 50

00004105001 YYYY 50 1000

00004105002 AAAA 200 100

Now my problem is with two key figures and trimming

1) In first instance i created one Conersion and Transformation file where in i used some JS scrpit in order to trim first zeros of cost elemnt and concatnate with account as AC.4105000 -- now it is loading fine with and scuseeful as i have in BPC acount contains AC.4105000 no issues at all with data (since i maintained two trasnformatiosn one for amount and one for qty)now the issues is with second point

2) ISince costelements are coming bringing QTY's also i need to send first two cost elemnts to gross volumes as (AC.GROSSVALC) and second one as AC.RETURNS.

Now i need to trim the first zeros's and map to AC.GROSSVAL or AC.RETURNS

Can any one help me with logic

Is this correct way i am doing by maintaing two transformations and two conversions file for loading one for amount and one for quantity.

Now i need to Trim and assign to the acount at the same time, can any one help me with the logic that i need to apply

Please help me in this regard

Regards

Ram

Edited by: Ram on May 8, 2010 2:53 AM

Edited by: Ram on May 8, 2010 2:53 AM

[Former Member]

Thanks

[sorin_radulescu]

To maintain 2 conversion file and two transformation file I think it is correct in your case.

For trim you can use direct the conversion file and you are able to write JAVA script.

Or another suggestion if that you can really have all the accounts mapped into excel (conversion). That's the easiest way in my opinion.

Regards

Sorin Radulescu

[Former Member]

Thanks for your suggestion all i need is to trim cost element and concatinate to the BPC(AC.) can you please give me the JS logic for this.

[former_member190501]

Hi Ram,

try the following in conversion file:

js:%external%.toString().replace("000","AC.")

hope it works...

regards,

Raju