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