Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Issue while export

Received Response
11
Views
1
Comments
User_B7ZTH
User_B7ZTH Rank 5 - Community Champion
edited Aug 13, 2024 5:20PM in Oracle Analytics Cloud and Server

Hello Experts,

We are using the version of OBI 12c 12.2.1.3.0 on Solaris box.

We are facing issue while downloading the a report in excel.

  • Its a simple report with year filter
  • It has 54000 rows and 15 columns
  • We are exporting the report in Excel we are getting error, while downloading the report in CSV its working fine.

We have tried all the possible solution provided on google but no luck, but moment we reduce the columns count to 7 or 6 it working fine (able to export in excel).

Please let me know is anything I am missing or is there any limited size (# of rows and columns count) which we should take care while exporting in excel ?

Kindly suggest.

Regards,

Abhi

Answers

  • Charles M
    Charles M Rank 6 - Analytics Lead

    Try reviewing this note: OBIEE : Error: "Exceeded configured maximum number of allowed input records. Error Codes: EKMT3FK5:OI2DL65" when Exporting or Opening a Large Report (Doc ID 1487839.1). Also, click on the links to the documentation provided, they are helpful in understanding. This was written for 11g, so there may be a 12c equivalent out there ...