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..

No comments:

Post a Comment