Fusion Applications Business Intelligence - How To Increase The Number Of Rows Exported To Excel From A Report (Doc ID 1497737.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.1.5.1 to 11.1.7.0.0 [Release 1.0]
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.4.0.0 to 11.1.7.0.0 [Release 1.0]
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.11.1.0 to 11.1.11.1.0 [Release 1.0]
Information in this document applies to any platform.

Goal

This document describes how to change the maximum number of rows to be exported from Fusion Applications Business Intelligence OTBI reports to Excel.

Note:  Setting this value high can have a performance impact on the WebLogic Server for Business Intelligence.  You should test increases in the setting.*

 

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.

Solution

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