Pagination for Pivot table

OBIEE doesn't give pagination for pivot table by default. There is a simple work around for that, using rcount.

I implemented it in two ways.

Creating on UI:
1. Create a dummy column called "Page". Add the formula truncate ((rcount(1)-1)/5,0)+1. 5 is the number of rows that has to be displayed.
2. In the pivot table, add the dummy "Page" column to the pages section of the pivot table.
3. When the report is run, the page dropdown appears at the top of the table.


Creating in RPD:
1. The report would have atleast one lakh of records to display. So I gave the user the option of choosing the number of rows.
2. Created a logical column "rsum" in the fact. The formula used was rcount(1).
3. Created a prompt with rsum and used the "Between" operator. So the rsum would show values from 1 to maximum rows.

4. Created a column in the report which is max(.rsum)
5. In the report rsum had the default value of 21 and made rsum prompted in the report.

6. When the report would run, only 21 rows would be displayed. The user could choose the range of rows needed and check the report.

Pagination for Pivot table

There is no pagination for pivot table. One way of achieving this is below.
1. In report add a column and change the formula to TRUNCATE ((RCOUNT(1)-1)/100, 0). 2. Where 100 is the number of rows that should be displayed in the pivot table.
3. Change the column heading to "Page Number"
4. Rcount is equivalent to rownum in oracle.
5. Place this column in the Pages section of the Pivot table.