Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
What is the current row limit of OTBI in Oracle Fusion?
Hello Experts,
I’ve recently created an OTBI report to generate a customer list and managed to fetch around 500,000 rows.
Can anyone confirm the maximum row limit or suggest how much data we can realistically extract?
Any insights would be appreciated!
Regards,
Akhil
Answers
-
Ankil,
The limits on data is not just rows but columns and what data is in the values of the cells (bytes) and also by time and database resources used. For analysis in OTBI you have a default maximum query row limit of 75k rows of which a default max 500 can be displayed in a table online. Other limits for pivot tables, tables with prompts and sections etc. For a report in OTBI you have a timeout maximum query response time for the data model is default 30 mins maximum 5 hours but there is also a limit on the bytes of data including the tags in the XML results. Also you have "guardrails" running on the database which will kill your session if you are using too many resources in the database no matter how many rows again. For bulk data extract the recommended solution is BICC cloud connector to extract data to CSV on object storage/UCM.
0
