Hi,
we have created a OTBI report for Item master but when we download using csv it can download only 75000 rows. so want to know if there is any limitation on number of rows that can be downloaded using OTBI report.
Rgds,
pradeep
Hello @User_W7SY0
I understand your point. We try to compliment the documentation with KM Articles. For example:
FAW:FDI:FDIP Export To Excel Is Exporting Only 25000 Rows For Visualizations (Doc ID 3027775.1)
@Pradeep kudale FYI, there is an OTBI community here: https://community.oracle.com/products/oracleanalytics/categories/otbi
Regards,
John
Hi Pradeep,
FAW does not have a limitation. The limitation likely comes from OAC or BI Publisher if you are using that. You should check OAC documentation for limitations based on the number of OCPUs. https://docs.oracle.com/en/cloud/paas/analytics-cloud/acoci/create-services.html#GUID-7D6DB4EE-8DD5-44C5-9B6E-9FA847463A5F
Workbooks (the new analysis format in FAW/FDI) currently only allows for 25,000 rows to be exported to Excel. CSV export can go up to 4,000,000 I believe.
I think Oracle needs to be extremely clear about this and not ask users/customers to navigate a million different documents to get an answer for these types of questions. It's very clear what users/customers expect with respect to export data from reports.
Hi @Pradeep kudale
In Oracle Transactional Business Intelligence (OTBI), the limitation for downloading reports is typically set at 75,000 rows when exporting to CSV format. This limit is imposed to optimize performance and manageability, especially for larger datasets.
If you need to work with larger datasets, consider the following options:
For further details and insights, you can check the official Oracle documentation or forums discussing OTBI limitations and best practices.
Thanks and regards,
Jayant Deshmukh
I'd like to point out that we keep hearing about "performance and manageability" when raising concerns about export limitations in the era of Big Data. These export restrictions are understandable in the past when bandwidth, storage and compute were limited. This is simply no longer the case in the modern era.
I'm still of the opinion export restrictions should be set higher and/or up against the limitation of a specific format (such as modern excel supporting up to a million rows).
You have a valid point, please consider logging an idea in the Idea Lab.
Hi, I'm new to OTBI & FDI and need your help. Is it possible to do a report to identify missing default expense account in FDI or OTBI? Thanks for your help.
Hi Team We are using SCM- Maintenance subject areas for reporting . We enabled the Asset related DFFs (CSE_ASSETS_B) under Data Configuration successfully but the Asset DFFs are not reflecting under Descriptive Flexfield Folder . We do not see any Asset folder even under the Descriptive Flexfield folder . Please advise if…
We made some changes in the Fusion UI, and those changes were reflected correctly in OTBI but not in FDI. To refresh the data in FDI, the Oracle support team advised me to reload the relevant functional area (Absence Management). I navigated to Application Administration → Human Capital Management, selected Absence…
Data are synchronized with Oracle HCM and I can see PN 2470, which was terminated in the past. If I add any assignment information I find no records, why?
In an analysis/report, when the Bottom Up Manager details are selected from the hierarchy, the Top Position Person record drops out. This is due to the fact that this top level position does not have a record in the Fusion table : PER_MANAGER_HRCHY_CF which is the source to load OAX$OAC.DW_MANAGER_CF_DH . The requirement…
