Oracle^® Business Intelligence Presentation Services Administration Guide > Administering Oracle BI Answers >

Configuring the Maximum Number of Rows in an Answers Table View

You can override the maximum number of rows that can appear in a Table view by modifying the Oracle BI Presentation Services configuration file (instanceconfig.xml) to add the following entry. The internal default is 65000. If the user exceeds this value, the server returns an error message when the table view is rendered.

NOTE:  This entry applies to the Table view, not the Pivot Table view.

The following entry is an example:

<ResultRowLimit>95000</ResultRowLimit>

The ResultRowLimit entry controls the maximum value that can be set for the DefaultRowsDisplayed, DefaultRowsDisplayedInDelivery, and the DefaultRowsDisplayedInDownload entries. To set DefaultRowsDisplayed, DefaultRowsDisplayedInDelivery, or DefaultRowsDisplayedInDownload to a value that exceeds the current value of ResultRowLimit, you also must increase the value of ResultRowLimit to equal or exceed the value that you want to set.