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
3470
Views
38
Comments
124»

Comments

  • Unnikrishnan P
    Unnikrishnan P Rank 1 - Community Starter

    Upvoted!

  • Shreya.Gupta
    Shreya.Gupta Rank 1 - Community Starter

    Is there any update on this? Do we have solution to increase the limit from 75k to more lines?

  • Colin Hall
    Colin Hall Rank 1 - Community Starter

    It obvious Oracle isn't prioritizing this product or addressing the issues customers are facing. Has anyone found a workaround for this bug?

    I want to execute my SQL queries directly against the Fusion database and export the results as a .csv file. Has anyone successfully connected to the Fusion database using SQL Developer or any other proper SQL development tool?

  • LucasMariotto
    LucasMariotto Rank 1 - Community Starter

    Upvoted.

    This limitation is a huge frustration. The limit needs to be set by the customer not hard coded within the product

  • Wim vd Veer
    Wim vd Veer Rank 3 - Community Apprentice

    My customer has the same requirement. Its really not enough to have a maximum limit only 75K

  • Prithvi_Raj
    Prithvi_Raj Rank 3 - Community Apprentice

    Upvoted. This should be updated to atleast 2M like BIP.

  • POD AH
    POD AH Rank 3 - Community Apprentice

    Upvoted - This restriction really does impact reporting capabilities

  • User_UOTIS
    User_UOTIS Rank 1 - Community Starter

    Increasing the limit is required.

    As data volumes continue to grow, our customers require larger datasets to be supported, and the current limit is no longer sufficient. Our client has also requested this enhancement. A limit of 75,000 lines is too small for their operational needs, and increasing it will be necessary to support their business workflows effectively.