OAC - Maximum number of visible rows per page in a table and pivot view — Oracle Analytics

Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OAC - Maximum number of visible rows per page in a table and pivot view

Needs Votes
803
Views
3
Comments
Mark Dang
Mark Dang Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

Description

In OAC, currently the maximum number of visible rows per page in a table or pivot table is set to 5000 rows.  Any reports having greater than this number of rows will have to then select the down arrow located at bottom of report to see the next 5000 rows.  It doesn't have the capability to see all rows at once (like On Prem version).  This means users have to perform many more clicks and is not good user experience. Furthermore if users like to download the page and the complete report with all rows, they are unable to do so via the "Export Current Page" functionality (the workaround would be to download using Export link at bottom of report). 

Can the functionality be made configurable or set to a higher limit on number of visible rows in OAC?

Use Case and Business Need

Users would like to see the report in its entirety on the dashboard page and is unable to do so.

More details

This is not user friendly to have users click on down arrow buttons multiple times to see the report (when it contains more than 5000 rows). 

Original Idea Number: d55b7bdf53

Tagged:
21
Up
21 votes

Needs Votes · Last Updated

Comments

  • Bret Grinslade - Oracle Analytics-Oracle
    Bret Grinslade - Oracle Analytics-Oracle Mod

    Can we get more insight in to the scenario? How many rows can a user realistically read on a page?  Or is the main scenario export or are they searching for specific items?  Assuming we have to have a limit, what limit would work for your users?  

  • Mark Dang
    Mark Dang Rank 1 - Community Starter

    Hello Bret,

    Thanks for your reply.  We would want all of the rows in the analysis to display so when the dashboard is exported, the complete report is exported.  It’s typically not for reviewing data online.

    As for row limits, we have seen have seen approximately 60,000 rows with On-Prem and would like to see something similar in OAC.

  • ShyamVaran
    ShyamVaran Rank 1 - Community Starter

    What was the final conclusion on this 5000 limit? Scatterplots also hit this limit.