Is there an option to delete or disable the DISTINCT_VALUES Parameter in IDT? Currently it is set to DISTINCT on my universe, the only other option I have found is to change this to GROUPBY. I would like to remove this DISTINCT option if possible as I am not getting all rows displayed in webi for sql server table - I want to see the duplicate row in my reporting.
Thanks! 
Blowers (BOB member since 2009-09-30)
The Distinct or Group By clause is used only for LOV queries. It does not impact what you are describing.
In Web Intelligence there is a setting on the table (block) that says something like “Avoid duplicate row aggregation.” Turn that on and you will stop Webi from aggregating your data.
Dave Rathbun 
(BOB member since 2002-06-06)
Ah okay, that makes sense. One further question on this, Is there a way to remove the GroupBy function being added in Business Objects - aside from editing the custom SQL?
I have rows of data, that look like duplicates - but are not actually duplicate rows, they are valid data, but business objects shows the distinct rows only.
I was able to achieve this by editing the custom SQL and removing GroupBy and then unchecking the Avoid duplicate row aggregation option in webi, but wondered if there was another way as changing custom SQL in webi is not ideal.
Thanks!
Blowers (BOB member since 2009-09-30)