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.


About Kishore & Naresh

Hi.. This is a blog operated by Kishore and Naresh. We are colleagues and working as BI Developers. Here we want to share our ideas and researches here. We were the active members of OTN Forums and inspired with Venkat and John's blog. We may not reach to that level, but we brings up all our ideas and research work we done. All the views expressed here are our own and does not reflect the views of our employers. We need all your blessings and support to grow. Thanks

8 responses »

  1. Hello,

    This is excellent. But when I select Print or Download to Excel or PDF, only the page selected is displayed.

    Is there a way to Print all the records or Download all the records?

    Download Data is not going to work as formats and other options are missing.


    • Don’t know in which view you are able to download all records when pagination is introduced?
      Even in table view, you can’t download all pages when you are in 1st page

  2. usually in pivot view itself, if u have thousands of record, it will display only some records, but if u give download it will download all the thousand records…..
    IN paginating case if u download, only the page which u selected will be downloaded…

    is there any way to download all the data…

  3. Is it possible to do the same in OBIEE 11g Pivot table. As I do not see the Pages section in OBIEE 11g, I am unable to implement the above said functionality. Ideally I want to select pages as above in OBIEE 11g.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s