Business Intelligence – Oracle

Archive for January 23rd, 2008

Oracle BI EE 10.1.3.3/2 – Total Number of Rows and Pagination

Posted by Venkatakrishnan J on January 23, 2008

Let us look at something very simple today. If you have used pagination in BI EE table views, you would have noticed that there is no way you can find out the total number of records which might sometimes be essential for an end user. It is always desired that the end user knows how many number of pages he is scrolling through.

      

Now in order to have the total records displayed to the end user, there can be a lot of ways. But lets look at a simple approach. Create an extra column in the criteria and put the following formula in the formula tab.

MAX(RCOUNT(1)

This will give us the total number of records as part of each and every row.

      

      

In my case, there are totally 48 records out of which 25 are displayed. Now hide this new calculated column and go to narrative view. Refer this column in the narrative view as @n, give some message so that the end users know. Also restrict the number of records to 1. Now include this narrative view to the compond layout and arrange it in such a fashion that it is just below the table view.

      

      

      

Very simple but again can be useful in quite a lot of situations

Advertisements

Posted in All Posts, OBI EE Plus | 9 Comments »