Hiding duplicate rows

Question

Hi all,

I have a question. How to make Oracle BI Answers not to hide duplicate rows?

I disabled DISTINCT_SUPPORTED in database features in BI Administration Tool (as it was described here - Shiv Bharti's Blog: Ability to Enable/Disable DISTINCT and ORDER BY Clause in OBIEE at Report Level ), so there are no distincts in report's query when I check query log, but rows in the report are still hiding.

For example, here I have table:

PERIODA1DRNOV-16Sample100NOV-16Sample100NOV-16Sample300

I want to see all the data in my report, all rows, but in the report data display as:

I added rownumber column to check - and it shows that the hided row is counted but not displayed. Any ideas how to avoid this? I have Oracle version 11.1.1.7.150120 if it is important.

Thanks in advance.

Thomas Dodds · Answer

Add the unique row key from the database to your analysis just to make sure you have it right ... the display is showing correctly given the QUERY GRAIN ... you need to pin that grain at the same level as the TABLE GRAIN to get what you want.

Odarin · Answer

nay, unfortunately it didn't help

735098 · Answer

in rpd, if  you go the logical table source in the table -> content tab-> check on  select distinct  values option -> save it and try to see the results now