Skip to Content
0

BW 7.5 Composite Provider-JOIN Issue

Jan 20, 2017 at 07:48 AM

129

avatar image

Dear All,

I have the following issue:

Table 1

Doc No Approver

1 abc

1 def

Table 2

Doc no Item no Product qty

1 10 100

1 20 200

When I create a BW Composite Provider of Inner JOIN Table 1 (DSO1)to Table 2(DSO2)

I get the output as

Doc Approver Item Qty

1 abc 10 100

20 200

1 def 10 100

20 200

I am looking for output

1 abc 10 100

1 def 20 200

I tried various cardinality but still does not work. Is there any way to get this output?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Anil reddy Jan 20, 2017 at 08:13 AM
0

Hi Ramachandran,

Here Joining only on Doc no will give only same result.

The output you are looking for can be obtained, only when you can join it on some other Column along with doc no

Thanks,

Anil

Share
10 |10000 characters needed characters left characters exceeded