Skip to Content
0
Former Member
Dec 13, 2014 at 06:17 AM

WEBI report : Problem with 1:N relationship???

258 Views

Hi All,

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.