Showing posts with label How to display duplicate records in OBIEE 11g. Show all posts
Showing posts with label How to display duplicate records in OBIEE 11g. Show all posts

Wednesday, 21 November 2012

Displaying duplicates in a report


By default, a report in obiee will eliminate duplicate in a report.
If u want to show duplicate records also in u r report.
u need to do this process.
  • In BMM layer created a logical column - rownum 
  • Check 'Use existing logical columns as a source" add the following code in the Expression Builder: EVALUATE('ROWNUM' AS INTEGER). 
  • Include this in your criteria on your report as hidden.

C U Next Time..