Skip to Content
0
Former Member
Mar 16, 2007 at 05:34 PM

Infoset or Multiprovider

11 Views

Hi,

I want to join 4 ODS objects in an infoset or multiprovider. I tried both models but no success.

i.e.

ODS1 :

INVNO QUAN1

-


-


1 30

2 10

ODS2 :

INVNO SEGMENT CNTR

-


-


-


1 A 120

1 B 80

2 B 90

2 D 40

2 C 55

Infoset of ODS1-ODS2 gives me the result as (not sure):

INVNO SEGMENT QUAN CNTR

-


-


-


-


1 A 30 120

1 B 30 80

2 B 10 90

2 D 10 40

2 C 10 55

If i create a BEx query and add the QUAN in columns, the reslt is like :

INVNO QUAN .....

-


-


.......

1 60

2 20

There are many other columns.

How can i obtain that the QUAN values are 30 and 10 for INVNO 1 and 2 like that :

INVNO QUAN ......

-


-


......

1 30

2 10

thanks,

Yigit