Oracle Communities

Oracle Analytics and AI

Child Item

How export more than 25,000 rows

Kauan_Bohn

Hello,

I have a question that frequently comes up among colleagues who use OTBI for report extraction.

There are two ways to export data:

Formatted > Excel
Limit of 25,000 rows
Data > Excel
Limit of 75,000 rows

However, when I run these exports to Excel, I encounter the following limitation:

I would like to know if there is a way to export more data.

What is the limit when exporting via email?

Regarding BI Publisher, is there a way to leverage existing analyses, or do I need to develop a query from scratch?

Find more posts tagged with

Analytics

Oracle Fusion Analytics

Analysis and Data Visualization

OTBI

Analytics Community

Accepted answers

Dimple-Nagesh-Support-Oracle

Hi There!

You can review the current default limits for OTBI and BIP reports : Please refer the table which shows the limit defined for ONLINE and SCHEDULE Report outputs.

https://docs.oracle.com/en/cloud/saas/sales/facaa/analysis-and-report-limits.html

Thanks,
Dimple N

All comments

MandeepGupta

Can you try the solution mentioned in below MOS doc i.e exposting as csv?

Exporting OTBI Reports Limited To 25,000 Lines In Excel (Doc ID 2753125.1)

Fusion OTBI - How To Export More Than 65000 Records From OTBI (Doc ID 2247962.1)

Thanks.

Josue Jimenez

If your data output is in Excel, you can enable this option which will create additional tabs where the information will be organized in each of them as the query is printed.

MandeepGupta

Hi @Josue Jimenez ,

Is this applicable for OTBI reports as well?

Thanks.

Josue Jimenez

Hi @MandeepGupta

As long as you generate a template and it is in XLS format, you can apply the option.
For RTF formats, this option is not available.

Regards!

Dimple-Nagesh-Support-Oracle

Hi There!

You can review the current default limits for OTBI and BIP reports : Please refer the table which shows the limit defined for ONLINE and SCHEDULE Report outputs.

https://docs.oracle.com/en/cloud/saas/sales/facaa/analysis-and-report-limits.html

Thanks,
Dimple N

Kauan_Bohn

Thank you guys for the help, apreciate that.

Tomasz 'TJ' Jublewski

Hi all!

https://community.oracle.com/products/oracleanalytics/discussion/comment/60417#Comment_60417

Please note - I think these limits are for Sales module or outdated - I see that HCM have different limits, e.g. when exporting Data > Excel (instead formatted) the rows limit is 250 K.

It would be nice if someone from Oracle could confirm that. @Dimple-Nagesh-Support-Oracle

Kind Regards,
TJ