Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Report exported to excel takes long time to render and download file
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.
Answers
-
If possible please upload you template and sample XML to debug further
0 -
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
0 -
I've attached the sample xml and the template herewith.
Thanks
Gulshan.
0 -
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.
0 -
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
0 -
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?
0 -
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.
0 -
Not sure about your question. Is this fast for 4-5 reports or then also excel download is slow? meaning?
0 -
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
0 -
The environment is 11g.
0