Duplicate rows in the Webi report

building reports webintelligence
1

Hi,
I am getting duplicate rows from one reports query in database(Total records~20000), where as if i run the report in infoview it’s giving the exact records (~18). The same count, i.e. 18 i am getting when i add disctinct to the query and run against database.

It clears some where we have applied ‘NO DUPLICATES’ in the Webi report. But it’s an adhoc i am just developer and no where i have used any conditions to restrict duplicate values but still duplicates are getting eleminated fromt the report.

Can any body say any such option is there in Web intelligence which will automatically restircts the duplicates and if we have the option… .how to disable the same.

Thanks

kk@bi (BOB member since 2009-06-16)

2

Hi Praveen ,

You have an option for gettiing and Adding duplicate rows :

Edit Query --> Go tp properties tab and you can check , uncheck , Duplicate rows option .

Regards
Sapan

swapnil_taz :india: (BOB member since 2006-04-06)

3

Thanks Swapnil, i got the option but when i disable or enable the same there is no change in the record count dispalying in the report. But where as if we don’t apply distinct in the report query when running agaist database it’s giving around 20,000 records.

Can anybody tell what the issue might be.

thanks
P

kk@bi (BOB member since 2009-06-16)

4

HI ,

You can check for option Avoid duplicate rows aggregation .

This would give you the same results as in database query

Regards
Sapan

swapnil_taz :india: (BOB member since 2006-04-06)

5

Hi Praveen,

Can you chat the queries which you are running in the DB and from the WEBI?
That might be helpful to resolve.

sandeepmunagala :us: (BOB member since 2010-09-07)

6

Hi Praveen,
This is krishna here, I am also facing same duplicate rows problem in my webi report are got any solution please suggest to me…

krishnareddy.bo (BOB member since 2010-12-17)

7

There is a report query property called “Retrieve Duplicate Rows”, uncheck to avoid duplicate data & vice versa to allow duplicate data.

Other than this table property, “Avoid duplicate row aggregation” allows you to handle it at report level if query fetches duplicate records.

Prashant Purohit :india: (BOB member since 2009-02-18)

8

Hi,

I am also facing the same issue.

My Database is showing me 10 Records,
But my WebI report showing 9 records.

I checked Universe and Report level for the duplicate rows.
But still getting only 9 records.

a) I checked the “Retrieve duplicate rows” in WebI → Query Properties.

b) Also checked the “Duplicate rows” in universe level object.
Double click Object → Properties → Edit → Options → then change into Duplicate rows.

(Attached the screenshot for this…)

Oneway to acheive this : If you add another coloumn like Serial No in the final table, then you can view the duplicate rows. But I require without adding any coloumn.

Thanks,
A.M :slight_smile:
Untitled.jpg

yourajai :india: (BOB member since 2011-03-09)

9

Did you check this as well?

Table property, “Avoid duplicate row aggregation” allows you to handle it at report level if query fetches duplicate records.

I don’t see partial result as cause because query returns only 10 rows…

Prashant Purohit :india: (BOB member since 2009-02-18)

10

Hi Prashant,

Thanks for your reply.

I unchecked the “Avoid duplicate row aggregation” at the report level.
(Attached is the screenshot…)

But still the report showing me the distinct records.

:hb:
A.M :slight_smile:
ReportTableProperties.jpg

yourajai :india: (BOB member since 2011-03-09)

11

Hi,

Its a simple mistake i did.
You need to check the box - “Avoid duplicate row aggregation”. (I have atthaced the screenshot in the above post)

Now it is working as per my requirement.
Thanks,
A.M :slight_smile:

yourajai :india: (BOB member since 2011-03-09)