Query on Multiprovider

[Former Member]

Dear All,

I have designed a multiprovider on 2 DSO for billing condition data and billing line items.

Now there is a query on it which have Condition Amount in columns ( Amount restricted on billing conditions) coming from conditions DSO and Net value coming from billing line items DSO.

The problem is instead of having all in one row, I get 2 rows. one will have all the conditions and other for net value.

What can be the reason.

Please advice.

I promise to retunr points for all useful answers

[Former Member]

PB,

It depends upon the key fields of the ODS and alos the fields which are common to bothe the ODS. Since it is an union, it will show 2 records. Again what all do you ahve in teh rows? Are they common in both ODS's?