Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Fix the .xls output limitation of 65k rows for Oracle BI Reports

Submitted
8
Views
1
Comments
NancyAledia
NancyAledia Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Please address the .xls output limitation to 65K rows.

As an ERP Cloud Report user

I need to have excel reports use the newer versions of excel if possible - XLSX so that I can get more than 65k rows of data and bypass the limitation for report output data.

Tagged:
2
Up
2 votes

Submitted · Last Updated

Comments

  • RVohra
    RVohra Rank 6 - Analytics Lead

    Can you save and upload Template as .xlsx (Excel 2007+)

    When designing your report:

    • Use BI Publisher Desktop Plugin with Excel.
    • Save your layout as an .xlsx file.
      • File → Save As → Choose Excel Workbook (.xlsx)
    • Upload this layout to your BI Publisher Report.
    • Under Output Format, choose Excel (xlsx) instead of Excel.
      • In Oracle terms:
        • Excel = .xls (65k row limit)
        • Excel (xlsx) = .xlsx (1 million+ rows)