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!

Download to Excel 2007 (.xlsx) Help

633105Apr 30 2009

Hi Everyone, I have an issue with the Download options - Download to Excel.

We have a few on-demand bulk reports that basically allows users to fire a detailed obiee report through GoURL.
Once the report is done, the Download Option - Download to Excel allow them to export data to an Excel Spread-sheet.

The issue is, OBIEE is exporting the data to Excel as Microsoft Office Excel 97-2003 Worksheet, (.xls) format. As we all know this has a max row count limitation (65000) per sheet.
I was wondering if there is any setting in OBIEE side that would force the Download to Microsoft Excel 2007, (.xlsx) format which has a max row count of 1 million.

If anyone can help me finding the configuration file or settings in OBIEE that would do the above requirement, is greately appreciated.

Thanks
Sai

Locked Post

New comments cannot be posted to this locked post.

Locked on May 28 2009

Added on Apr 30 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

0 comments

762 views