Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Submitted
2226
Views
24
Comments
2

Comments

  • Clare Murtagh - new
    Clare Murtagh - new Rank 5 - Community Champion

    Can someone advise if this has been actioned as an ER please?

  • Marcus S.
    Marcus S. Rank 1 - Community Starter

    Supporting this request to extend the limits

  • User_GYEO3
    User_GYEO3 Rank 1 - Community Starter

    Need limit increased to perform item cleansing

  • Clare Murtagh - new
    Clare Murtagh - new Rank 5 - Community Champion

    Support the increase of row limit to to avoid having to push reporting into BIP, making the experience less user friendly for end users.

  • Parag Hiremath
    Parag Hiremath Rank 3 - Community Apprentice

    Upvoted - will be a useful feature. Thanks

  • Joju Thomas
    Joju Thomas Rank 1 - Community Starter

    Supporting this request to extend the limits

  • Bonnie G Waters
    Bonnie G Waters Rank 1 - Community Starter

    Client requirement is to be able to pull reports for Payroll costs (labor, fringe and burden) for a billing month. One payroll run has. One bi-weekly payroll run has ~80,000 rows when the other has ~155,000. Two of these payroll runs well exceed the limit of 75,000 rows. 500K rows would be a good starting point on the limit.

  • Clare Murtagh - new
    Clare Murtagh - new Rank 5 - Community Champion

    Upvoted

  • Colin Hall
    Colin Hall Rank 1 - Community Starter

    I'm new to OTBI after our organisation moved to Oracle from another ERP. Limits like 75k rows just emphasises how backwards the Oracle product is.

    The limit needs to be set by the customer not hard coded within the product.

  • KDR
    KDR Rank 3 - Community Apprentice
    https://community.oracle.com/products/oracleanalytics/discussion/comment/52261#Comment_52261

    @Colin Hall We also moved from another (on-prem) ERP system 2 years ago, and while I definitely agree they should allow for increasing this limit, BI Publisher is a more robust reporting and data extract tool that (for the most part) does not have this restriction. As a Developer, BI Publisher is definitely my reporting/extract tool of choice. I typically point end-users to OTBI only for very simple reports.