Actually I got one scenario while working on WEBI report.
First of all my table structure and data is as follows :Customer NoProduct IDOrder IDCredit LimitTotal Amount1P1O1100002001P2O2100003002P3O3200005002P3O4200004003P4O5300006003P5O6300007004P6O740000800
Now, I have two data Providers :
In DP 1 , I am taking Customer No,Product ID,Credit Limit
& in DP 2, I am taking Customer No,Order ID,Total Amount.
Now I would like to see output as shown in table above.
How can I solve the issue with considering above scenario only.
I have already tried following methods :
Method 1: Merge Customer No object , then create the detail for Order ID object but I am getting #multivalue error because of 1 : N cardinality.
1 customer having more then 1 order and also more then 1 products.
So, Please let me know the logic\method how anyone can achieve this in WEBI.