cancel
Showing results for 
Search instead for 
Did you mean: 

BW 7.5 Composite Provider-JOIN Issue

former_member231279
Discoverer
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

anilreddyk
Explorer
0 Kudos

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