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:

1. Formatted > Excel
   Limit of 25,000 rows
2. 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?

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

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!

Kauan_Bohn

Thank you guys for the help, apreciate that.