modelling question

[Former Member]

Hi experts,

There are two structures in R/3. Structure 1 has fields batch no,date,qty. Structure 2 has fields batch no,customer.

I have to extract values for all fields from struct 1 and value for customer for each record of structure 1 where structure1.batch no.=structure 2.batch no.

I cant enhance the datasource based on structure 1 with a append field customer.

I want to handle this in the transformations when populating the cube. how do i do this?

thnx

[Former Member]

Can you give example?

Alos, is all the data coming into BW as you are saying you want ot handle this im transformations in BW?

--SA