My Oracle Support Banner

The Number Of Rows To Display & Download Is Limited By MaxVisibleRows When Section Is Used (Doc ID 2984770.1)

Last updated on NOVEMBER 02, 2023

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.


The number of rows to display and export is limited by MaxVisibleRows for the case of the analysis, in which a section is placed.

- Open analysis/dashboard on the browser: Only parts of rows are displayed and it's limited by MaxVisibleRows.
- Export with report link [Excel 2007+] of analysis: ALL the rows are exported as expected in downloaded excel.
- Open dashboard --> export [Export to Excel] using dashboard page option--> Export Current page or Entire Page: Only parts of rows are displayed and it's limited by MaxVisibleRows.

It can be reproduced with the following steps with the subject area "Samples Sales Lite".

1. Specify the value for MaxVisibleRows in instanceconfig.xml for OBIEE 12c or Maximum Visible Rows from System Settings in the Oracle Analytics Server Console.

2. Create an analysis like below and place a column in sections.

3. Create a dashboard page and include the created analysis.

4. Check the Test results.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.