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