Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 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
BI Publisher interactive report row limit

Hello,
I have a question about the row limit of an Interactive BI Publisher report. Currently, I get as an output 200 rows, which matches the limit of the Data Model and I would like to know if there is an official limit for this type of output.
By checking the community, I came across the thread https://community.oracle.com/products/oracleanalytics/discussion/20352/bi-publisher-interactive-output-very-weird-behavior-inbuilt-total-characters-per-row-restriction; there it is referenced the por_requisition_lines_all.item_description field while I am using por_requisition_headers_all.description field which has the same characteristics. I also tried to SUBSTR to a lower number of characters, even 10, but the output showed 200 rows still, so no change.
Is there a 200 rows limitation of an Interactive output of a report?
Thank you,
Emil
Answers
-
Are you on OAC-BIP or OAS?
0 -
Hi @Emil Dragan
If you are using cloud version, refer below -
Data Size Limits (Classic Pixel-Perfect Reports)
What Sizing Options Are Available to You? (oracle.com)
For On-prem
In order to extend/increase 'Maximum report data size for online reports' parameter
Go to Administration>Runtime Configuration > Memory guard
Default value is 300MB
Is there a 200 rows limitation of an Interactive output of a report? —> No
Regards,
Arjun
1 -
Very helpful information.
Thank you very much Arjun!
0