Skip to Content
Former Member
May 07, 2010 at 09:00 PM

Two key figures to one sign data


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



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

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