Tag Archives: OBIEE Pivot

Pagination or “Page Contol” in OBIEE Pivot View


Hello Everybody,

There are several blog entries which explains about pagination in OBIEE Pivot

Please, include this entry also in that list. J

Suppose, i want to see 10 rows for every page in pivot.

Apart from the columns selected in the criteria for particular request, select another column and modify it’s functionality to CEILING((RCOUNT(1))/10.0). Now, change it’s column heading as: Select Page Number:  and drag this column into Pages block of Pivot

Pages of Pivot

Results are like:

Pagination Control

Note: In denominator of the formula, use ‘10.0’ instead of ’10’.  If you use 10, page Numbers are populated  from ‘0’ and in the 0th page only 9 records will be shown for this particular scenario.