Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Downloading report to excel file problem

907664Jan 7 2013 — edited Jan 23 2013
Hello everyone!

I have a problem, that I wasn’t able to solve. Need your help. (We are using OBIEE 11.1.1.6.5, Oracle DB as datasource).

So I developed 2 standard financial reports in OBIEE analytics. Report 1 has more column (12 column) then report 2 (5 columns). Both of the report displays a lot of data (rows). Both of them works just fine – all data is displayed correctly.

The problem starts when I am trying to download reports to excel. When browser's downloading progress bar reaches ~~10mb then the download process stops. This happens every time for both reports. The excel file is actually downloaded and can be open. There is even data in it, but if you scroll down the excel file you will see then not all the data was downloaded, and after the last row there is windows error icon (it looks something like this http://www.image-share.com/upload/1982/106.jpg). If i donload second report, then it will also stops on ~~10mb, it will have more rows in it, but still there will be windows error icon after the last row.

I tried to edit Instanceconfig.xml like it was told in this article, but it didn’t help.
http://shivabizint.wordpress.com/2011/08/26/export-more-than-6500-obiee-11g-records-to-excel/

I would be very greatfull for your help!
Many thanks,
Miloslav
Comments
Locked Post
New comments cannot be posted to this locked post.