In OBIEE 12c unable to export the result in Excel 2007+

Question

Hi All, While exporting the analysis output in Excel 2007+ it is throwing error: There was an error processing your download. Please check with your administrator. If I'm exporting the report which has less number of records, I'm able to export it. But if a report is having large number of records, I'm getting this error. Also, I've added 550000 under and tags in my instanceconfig.xml. In CSV, I'm able to export the same report but not in Excel format(as per the requirement it needs to be exported in Excel format only). Thanks,

Gianni Ceresa · Answer

3531239 wrote:In CSV, I'm able to export the same report but not in Excel format(as per the requirement it needs to be exported in Excel format only).

CSV is a 100% format support by Excel since .... can't count, I was too young to remember.

Before to go more in details ....

What exact version of OBIEE is it? (version + bundle patch installed)

What does "large number of records" mean in your case? (how many rows & columns)

Without knowing exactly of what size we are talking ...

The requirement is wrong! You are doing data dump in OBIEE which is the first mistake, using Excel as format which is the second mistake and Excel 2007+ which is the 3rd mistake : 3 reasons why it can't work. The tools isn't done for these things, that's why CSV is there.

If you don't trust us, and you don't trust Oracle telling you in the linked MOS documents by Sherry George, have a look at your poor OBIEE server and compare what happen when downloading in CSV or Excel 2007+ (CPU, RAM, disk usage).

Sherry George · Answer

Hi,

It is not recommended to download large amount of data using OBIEE. Doc ID 1558070.1 provides Oracle recommendation on exports.

You can also look at the following support docs which deals with your particular issue.

Doc ID 2174628.1

Doc ID 2161550.1