Infoset or Multiprovider

[Former Member]

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

[Former Member · Accepted solution]

Hi,

The reason you are getting that output is because you have the column SEGMENT in ODS2. According to the design you have given, I am assuming that you are linking both ODSs based on INVNO. Try creating a join condition based on some other fields in the ODS instead of INVNO.

With Regards