nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Report exported to excel takes long time to render and download file

Gulshan Chaurasia

Summary

Report exported to excel takes long time to render and download file

Content

Hi All

I have a report which is created using excel template. The query for the report takes about 2-3 minutes to run in the backend, and it takes another 9-10 minutes to generate the output in excel.

I've faced same issues with multiple such reports, both for RTF and Excel templates.

Has anyone faced similar issues, and is it something to do with any BI Publisher parameter configuration?

Thanks

Gulshan.

Find more posts tagged with

Accepted answers

All comments

Brajesh Shukla-95078

If possible please upload you template and sample XML to debug further

Brajesh Shukla-95078

This happen when you have merge columns in Excel. Each merge takes some KB in excel and suppose you have 1000 rows in report and some 5 merge columns then size will be in 4-5 MB and report will take time to open. Try to minimize your merge cells and see the performance. Most likely this will solve the issue else we will see some other option.

Regards,

Brajesh

Gulshan Chaurasia

I've attached the sample xml and the template herewith.

Thanks

Gulshan.

Gulshan Chaurasia

Hi Brajesh

Thanks for your reply, I confirm that there are no merged cells being generated in the output file. The performance issue after observation looks like coming during the excel file generation by the report engine. I tried by monitoring the report by scheduling it. The query runs in database in a few minutes but it spends next 8-10 minutes trying to generate XML file and then Excel.

Thanks

Gulshan.

Brajesh Shukla-95078

Excel export is slow for 4-5 rows also? or it slow for more than 1000-2000 rows?

Because when I generated the output it was 4 records in excel and it exported fast

Brajesh Shukla-95078

I tried to load the data into excel and extracted it using preview option it ran fast without performance. So template looks good.

Is this fast for 4-5 reports or then also excel download is slow?

Gulshan Chaurasia

Sample data had only 5 rows.

for my requirement, output data is 40-50 K rows. The issue I'm trying to understand is whether this is expected from BI Publisher, because query itself finishes in the DB in 2-3 minutes, and it takes another 9-10 minutes to get the output.

Gulshan Chaurasia

Not sure about your question. Is this fast for 4-5 reports or then also excel download is slow? meaning?

Venkat Thota - BIP

Yes ,this is expected behavior with 50k records of output data ,but you can tune the report at two places

1. database level -------use MV'S or GTT etc

2. report level -------setting up report properties(FO processing --this is mainly responsible for processing report output from data to final output) , increase bip server JVM in weblogic, increase system resources etc. Thanks

Gulshan Chaurasia

The environment is 11g.