Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
72
Views
2
Comments
Chandranshu Bhardwaj
Chandranshu Bhardwaj Rank 3 - Community Apprentice
in Oracle Business Intelligence Applications

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 <DefaultRowsDisplayedInDownload>550000</DefaultRowsDisplayedInDownload> under <Table> and <Pivot> 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).

pastedImage_0.png

Thanks,

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    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

  • Gianni Ceresa
    Gianni Ceresa Mod 
    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).