To Eliminate the DISTINCT Clause in the OBIEE backend query

As a default, OBIEE will give you the distinct rows in the output. In order to avoid and to show the duplicated rows


OBIEE will send the query to database for selecting the distinct values.

Result:

To show  the distinct rows in OBIEE output. the database feature  DISTINCT SUPPORTED has to be uncheck as shown below.

After the change, OBIEE will send query to the database with out the distinct clause.

Result:

Note: As per OBIEE, if we change defaults there would be a possibilities of variation in the reports.Depends on the requirement from the business we have to play with defaults.