on 07-31-2015 2:40 AM
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 ID | Name1 | BU | Voucher ID | Invoice Id | Invoice Dt | Pymnt DT | Pymnt amt | Gross Amt | Enter DT |
---|---|---|---|---|---|---|---|---|---|
1234 | BMW | ECS | 6789 | IS3456 | xxxxx | XXXX` | XXXX | XXXX | XXX |
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 ID | Name 1 | BU | Voucher ID | Invoice ID | Invoice Dt | Pymnt Dt | Pymnt Amt | Gross Amt | Enter DT |
---|---|---|---|---|---|---|---|---|---|
3456 | Volvo | ISG | 9087 | G5678 | XXXX | XXXX | XXXX | XXXX | XXXX |
3456 | Volvo | ISG | 9087 | G5678 | XXXX | XXXX | XXXX | XXXX | XXXX |
91007 | Audi | Fleet | 2345 | B6789 | XXXX | XXXX | XXXX | XXXX | XXXX |
91007 | Audi | Fleet | 2345 | B6789 | XXXX | XXXX | XXXX | XXXX | XXXX |
Can anyone help me on this to get Unique records for all vendor Id's
Many thanks in advance!!
Ravi Shankar
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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?
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.