Fusion Applications Business Intelligence - How To Increase The Number Of Rows Exported To Excel From A Report
Last updated on JUNE 30, 2017
Applies to:Oracle Fusion Application Toolkit - Version 220.127.116.11.1 to 18.104.22.168.0 [Release 1.0]
Oracle Fusion Application Toolkit Cloud Service - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 1.0]
Oracle Fusion Global Human Resources Cloud Service - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 1.0]
Information in this document applies to any platform.
This document describes how to change the maximum number of rows to be exported from Fusion Applications Business Intelligence OTBI reports to Excel.
General Information About this Setting
The actual number of rows to be downloaded is a function of rows and columns.. For example, if we make the setting to download 25,000 for a report with 20 columns, this equals 500,000 cells in a report. If there are more than 20 columns, the number of rows exported will be less than 25,000 on a sliding scale. See below for an example.
|Setting||Max Rows to Download||25,000|
|Max Rows to Download||500,000*||(Based on 20 column calculation and 25,000 rows)|
|Columns in a report||10||15||20||21||22||23||24|
|Rows that will be downloaded||25,000||25,000||25,000||23,810||22,727||21,739||20,033|
*Performance Considerations with High Number of Rows to Export
In our SaaS environments we have the maximum at 25,000 because exporting this data to Excel is a large hit for the WebLogic Server (WLS) that runs Business Intelligence (BI). Increasing this max rows to a high number will have very unfortunate consequences for BI on your server. It may crash the WLS for BI. If it does not, other users will be in a wait state waiting for resources to free up when the export finishes. For these reasons, we have made a decision not to increase the number of rows to export above 25,000 in our SaaS environments.
OTBI analyses are not designed to bulk extract data from the system. Trying to use the product in this way tends to be very problematic.
We recommend that you use a BI Publisher report in place of an OTBI analysis. The BI "Getting Started Document, note 1489938.1, has link "Create a simple BI Publisher report" that will play a video. The video shows how to create a BI Publisher report using an OTBI analysis as the data model for the BI Publisher report. If you have an OTBI analysis that returns many rows, you can use that analysis as the data model for the BI Publisher report. Then you would schedule the BI Publisher report with an output destination of Excel. Do not run the BI Publisher report to return many rows to the screen and then try to output that to Excel while you are viewing the data in the UI. That DEFINITELY will crash the BI server. Please schedule the BI Publisher report with output destination of Excel.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms