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

2226
Views
24
Comments

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):


Description (Required):

For one of our customer OTBI analysis is fetching only 75001 rows but for other customer it is fetching 250000 rows by default.

Please let me know how to change/control this setting

Use Case and Business Need (Required):

Customer want to fetch more rows in OTBI analysis

Enhancement Request / Service Request:

84
84 votes

Submitted · Last Updated

«13

Comments

  • DM-WSFS
    DM-WSFS Rank 1 - Community Starter

    Please do, this is very frustrating to have this limitation, 75k rows is not enough. 250k won't be enough at some point too.

  • Alyse Grant
    Alyse Grant Rank 1 - Community Starter

    It would be VERY helpful to be able to increase the number of lines.

  • User_00FBO
    User_00FBO Rank 1 - Community Starter

    Hi,

    This is and awful limitation in every GL audit for us where we are having +200k rows that we need to extract and send to the auditor.


    Please increase and make this possible,

  • Farooq H Syed
    Farooq H Syed Rank 4 - Community Specialist

    Increasing the limit is very much required as by growing the data customers required more data and this has to be enhanced.

  • Ahmed M Ali
    Ahmed M Ali Rank 1 - Community Starter

    Running one of the detailed OTBI Reports after only one quarter Requires us to run it in 3 or may be 4 times with different parameters to split the data to be able to get the Quarter data It's a time consuming job

    It's indeed a very Required Feature we hope it can be done through a profile option or Something can be increased by SR. But to limit it to 75000 Records only will keep some customers Out of using it at all

  • User_8RKYT
    User_8RKYT Rank 1 - Community Starter

    The OTBI report needs to be run multiple times per month close per day, it is extremely inefficient to only fetch 250K rows.

  • James Coles
    James Coles Rank 1 - Community Starter

    Our client also requires this. 75k lines is a small amount of data

  • Amit Sutar
    Amit Sutar Rank 1 - Community Starter

    We should have option to setup the limit of records instead of defaulting the row count.

  • KDR
    KDR Rank 3 - Community Apprentice

    Please increase this limit to at least 250k rows. This limitation has forced us to re-write several OTBI analyses into BIP Data Models/Reports and required a lot of development time migrating the Logical SQL into Physical SQL, in order to avoid this hard limit.

  • Tom Strudley
    Tom Strudley Rank 4 - Community Specialist

    Have seen this come up a number of times