distinct objecct in the query

building reports webintelligence
1

We have one object in our universe customer and the vew sql corresponding sql is select distinct customer from customer_dim table.
but when i bring that object i get select customer from customer_dim table. What is the reason the old report has distinct customer (its not a
custom sql)

noviamat (BOB member since 2011-03-28)

2

Check the Report Property - Avoid Duplicate Rows in Edit Query Section, that will put distinct in query if checked.

aniketp :uk: (BOB member since 2007-10-05)

3

Thanks Ankit, it woks

noviamat (BOB member since 2011-03-28)