Oracle Transactional Business Intelligence Idea Lab

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

OTBI Analysis fetches starting 75001 rows only -- how to increase the limit

Needs Votes
2934
Views
35
Comments
13

Comments

  • Francis Grégoire111
    Francis Grégoire111 Rank 1 - Community Starter

    75 000 is not enough. I also support this idea on behalf of the City of Montreal.

  • Vanessa Assuncao EBS
    Vanessa Assuncao EBS Rank 1 - Community Starter

    Upvoted

  • Raquel K
    Raquel K Rank 1 - Community Starter

    An increase in number of rows in OTBI is really needed. We also often need to pull up to 250k rows

  • User_L8MC2
    User_L8MC2 Rank 1 - Community Starter

    Can't believe we are still having these limitations, please can Oracle increase the limit

  • Donna Biggs
    Donna Biggs Rank 1 - Community Starter

    Please increase this limit to at least 250k rows as others have said. This is causing issues when trying to run some of the OTBI reports which we require

  • User_SPTA7
    User_SPTA7 Rank 1 - Community Starter

    Hope there is an update on this - because of restricted row count is limiting OTBI utilization significantly.

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    Upvoted !!!

  • Ashish_Thakur_birl
    Ashish_Thakur_birl Rank 1 - Community Starter

    Up voted

  • Puneet Jain-Oracle
    Puneet Jain-Oracle Rank 1 - Community Starter

    Since customers are keeping multi year data in fusion, it becomes critical to enhance this limit to ensure they are seamlessly able to access that data via reports

  • Brent_Beardsley
    Brent_Beardsley Rank 1 - Community Starter

    Upvoted as well. We recently needed to run a report to see how many of our employees have had a specific Job Function. This required using the Assignment Event subject area so that we can see the employee's history. This ran into the 75,000 row cap. Fortunately, in this case we were able to apply a filter to reduce the number, but that is not always going to be possible and it makes data validation difficult to impossible.