OBIEE 11g: Adding Sequence ROW_ID to Keep Track of "# Rows"

When looking at big data, it makes it easier if we have ROW # to help us navigate throughout. Especially if we were to reference it, similar to MS Excel - where it is built in to reference to every cell.

To apply sequence # in OBIEE, please follow below steps:

1. Add a column from Subject Area and Edit Formula:
2. Replace column's formula with: RCOUNT(1)

3. Add all other necessary report columns and click on Results
4. Result:

Hope this helped!