OBIEE ResultRowLimit

I still wonder why people want to do it: A report with more than 65000 rows, but still….
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.

<ResultRowLimit>95000</ResultRowLimit>

 

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 ResultRowLimit entry controls the maximum value that can be set for the DefaultRowsDisplayed, DefaultRowsDisplayedInDelivery, and the DefaultRowsDisplayedInDownload (fi download to Excel) 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.

Till Next Time