OBIEE + Rownum

Post date: 08-Apr-2011 04:57:50

Sometimes evern if you remove

i) removed Distinct in advance tab in report.

2. In rpd unchecked the distinct supported.

Still u can't see duplicate records.. then rownum comes to rescue

Create an logical column with expression : Evaluate('ROWNUM' as INTEGER)

    and use this column in report and hide it.

Check if RSUM can be help  - Use RSUM(1)

else RCOUNT

In your answer request criteria add any column then edit formula (fx button) then enter RCOUNT(1). If you click the "function..." button you can select it from the running aggregate functions - "This function takes a set of records as input and counts the number of records encountered so far."