Pagination or “Page Contol” in OBIEE Pivot View

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

Results are like:

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 0^th page only 9 records will be shown for this particular scenario.