Oracle Transactional Business Intelligence

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

Categories

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

What is the latest limit on OTBI export for CSV & Excel.

Received Response
3
Views
3
Comments
Saumishra
Saumishra Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

I was able to export 75k in excel & 500k records in csv with OTBI. However, I keep on reading that excel has a limit of 25k & csv has 75k as a limit. Do we have a way to change these limits for our instance. Can someone pls help me with the hard limit for export for excel & CSV vo OTBI analysis.

Answers

  • CCourty
    CCourty Rank 3 - Community Apprentice

    I was just working with an OTBI report yesterday that returns over 2 million rows. I was able to export 50k in XLS and 250k in CSV. I think it is a limitation of Excel so it is unlikely that there is any way to change this. You would need to use BI Publisher to be able to export all of the rows.

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi,

    For "bulk" data export the recommended by Oracle approach is Business Intelligence Cloud Connector (BICC) (not analytics and reports in OTBI nor the SOAP/REST API)

    Oracle Fusion Cloud Applications

    Creating a Business Intelligence Cloud Extract

    F92942-01 24B

    https://docs.oracle.com/en/cloud/saas/applications-common/24b/biacc/index.html

    Why? see

    My Oracle Support https://support.oracle.com/ 

    Oracle Applications Cloud: Data Export Best Practices (Doc ID 2615185.1) 

    Oracle Fusion Transactional Business Intelligence and BI Cloud Connector Performance Recommendations (Doc ID 2679006.1) 

     

  • mkucuk_tr
    mkucuk_tr Rank 1 - Community Starter

    Report data size maximum limit is 2147483648 bytes.