The OBiEE XmlViewService Web Service Method Does Not Handle Fetch Previous Records (Doc ID 2114589.1)

Last updated on MARCH 21, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.161018 and later
Information in this document applies to any platform.

Symptoms

Per the Oracle Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise EditionXMLViewService Service

The XMLViewService Service handles the following functions:

  cancelQuery() Method
  executeSQLQuery() Method
  executeXMLQuery() Method
  fetchNext() Method
  getPromptedFilters() Method
  upgradeXML() Method

For both, executeSQLQuery() Method and executeXMLQuery() Method, the documentation states:

Note:
If the results returned exceed one page, you need to use the fetchNext() Method to return the next page of rows.


There is no method available to handle the previous page request. 

For example:

When a user is presented with a list of records, the length of the list is determined by the page set size (maxRowsPerPage parameter)
In many cases, this number is greater than the number of records displayed on the first page, so the user must click on the UI element resulting in the fetchNext() request being submitted. The fetchNext() returns the next page of data.

The XMLViewService Service does not handle the request for the previous page.

The business user does notknow what the second page contains until he has viewed that data (or the third etc.). Once one has viewed that non-first-page data set, one may decide that one wants to view the last set of data he just looked at, without:

Cause

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