OBIEE 11g: Problems With Pagination In Pivot Tables Using Totals "before"

(Doc ID 1940866.1)

Last updated on JANUARY 30, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


There is a problem in pagination of Pivot tables when TOTALS are displayed BEFORE the actual table contents.
- The first problem is that the "Rows 1-X" indicator at the bottom of the table shows an incorrect X.

When opening the dashboard, both Pivot Tables show 30 rows (as specified in the table properties). Correct. But the page navigator of Pivot Table 2 says “Rows 1 - 31”, which is incorrect.

- The second problem is that when you advance to the next page, the last row from the previous page is again shown as the first row of the current page.

When you use the “down” arrow to go to the next 30 rows: Pivot Table 1 starts correctly at row number 31, but Pivot Table 2 starts with row number 30, which was already shown on the previous page.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms