Difference bet Retrieve Duplicate Rows & Avoid Aggregati

building reports webintelligence
1

What is the difference between Retrieve Duplicate Rows and Avoid Duplicate Row Aggregation?

ANIVID (BOB member since 2009-09-12)

2

‘Retrieve Duplicate Rows’ is a Query level option if you uncheck this report SQL will formed as Select Distinct - -----------------------------
when u check this option SQL will formed as Select ---------

‘Avoid Duplicate Row Aggregation’–>Is generally a table level option at report level ,If checked then duplicates will be displayed in a table.

rak_2010 (BOB member since 2010-05-01)

3

Thank you for clarifying the difference between the two.

ANIVID (BOB member since 2009-09-12)

4

Hi,

I am trying to understand this, are there parameters set on the universe or they are report parameters? I have searched the universe and I cannot see anything. My deployment is BOXI3.1

Thanks

shawzozo :zimbabwe: (BOB member since 2006-08-08)

5

Both of these parameters can be set at report level.

‘Retrieve Duplicate Rows’ - Query Properties

‘Avoid Duplicate Row Aggregation’ - Table/block Properties

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