cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate records for Vendor ID in Webi report

Former Member
0 Kudos

Dear Experts,

We have developed Webi report based on relational Universe(unx) in BI 4.1 version and the datasource is Oracle.

In webi report I am getting duplicate records for some Vendor Id's, but for other Vendor Id's I am getting single reocrd only and exactly matching with Database.

Vendor IDName1BUVoucher IDInvoice IdInvoice DtPymnt DTPymnt amtGross AmtEnter DT
1234BMWECS6789IS3456xxxxxXXXX`XXXXXXXXXXX

For the above Vendor ID 1234 I am getting single reocrd only and exactly matching with Database.

For the below 3456, 91007 Vendor id's I am getting duplicate records and not matching with database.

Vendor IDName 1BUVoucher IDInvoice IDInvoice DtPymnt DtPymnt AmtGross AmtEnter DT
3456VolvoISG9087G5678XXXXXXXXXXXXXXXXXXXX
3456VolvoISG9087G5678XXXXXXXXXXXXXXXXXXXX
91007AudiFleet2345B6789XXXXXXXXXXXXXXXXXXXX
91007AudiFleet2345B6789XXXXXXXXXXXXXXXXXXXX

Can anyone help me on this to get Unique records for all vendor Id's

Many thanks in advance!!

Ravi Shankar

Accepted Solutions (1)

Accepted Solutions (1)

former_member183330
Active Participant
0 Kudos

Hi Ravi,

Please provide complete data instead of giving XXXX, So that it would be easy to analyze.

For each vendor in below table all the rows are coming same, so may be in date fields you are getting

multiple records for each combination. Check the dates once.

Thanks,

G Sampath Kumar

Former Member
0 Kudos

Hi Sampath,

Thanks for the quick response,

Yes, we are getting Invoice and Pymnt dates are different like below

Vendor ID  Invoice Date    Pymnt Date  Voucher ID  Invoice ID

3376         1996-05-25     1996-06-26  96060024    MM98795

3376         1996-05-25    1996-07-12   96060024    MM98795

3376         1996-06-22    1996-06-26   96070008    NM04338

3376         1996-06-22    1996-07-12   96070008    NM04338

Former Member
0 Kudos

Hi Sampath,

This is due to trap at universe level .

To resolve traps, refer this links  .

How to solve Fan Trap in Business Objects Universe

how to resolve the loop in universe level | SCN

--NISHANT

arijit_das
Active Contributor
0 Kudos

If the combination of dimension values are different in each row, then what is wrong in your result ?

Former Member
0 Kudos

Hi Ravi

How are invoices, payments and vouchers related to each other in the universe?

Also, how are they related to each other within the business?

It looks like the way that they are being implemented in the universe incorrectly.

For example, does an invoice always have one and only one invoice date and one and only one payment date? Or can the invoice ever be paid across multiple dates?

Former Member
0 Kudos

Hi Arjit,

We want only one Unique record for each Voucher ID like below

Vendor ID   Voucher ID  Invoice ID  Invoice Dt    Pymnt DT    Pymt amt    Gross amt 

3376           96060024    MM98795  1996-06-25    1996-06-26    XXXXXX    XXXXXXX

3376           96070008      NM04338  1996-06-22    1996-07-12  XXXXXX     XXXXXXX

But we are getting below records when we run the query

Vendor ID    Voucher ID  Invoice ID   Invoice Dt    Pymnt Dt      Pymnt amt  Gross amt

3376            96060024    NM98795    1996-05-25   1996-06-26    XXXXXX     XXXXXX

3376            96060024    NM98795    1996-05-25   1996-07-12    XXXXXX     XXXXXX

3376            96070008    NM04338    1996-06-22   1996-06-22    XXXXXX     XXXXXX

3376            96070008    NM04338    1996-06-22    1996-07-12   XXXXXX     XXXXXX

Many thanks in advance

Ravi

Former Member
0 Kudos

Dear all,

Issue has been resolved by taking correct objects in the report.

Answers (1)

Answers (1)

saurabh_sonawane
Active Contributor
0 Kudos

Hi

Make sure all the cloumn data contain the some value,

we think that there is a space in the second vendor id i.e 3456.

Note plz check the invoice date and pymnt date should not same so you are getting the different record.