Oracle Transactional Business Intelligence Idea Lab

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

OTBI Export to Excel or CSV limitation

4981
Views
88
Comments

Organization Name

Capgemini

Description

Hi Team,

The OTBI Report export to excel or csv limited to 25k and 75k rows.This Limit is very small for business requirements.It's better to provide some configuration to increase this limitation in OTBI.

You can look at this SR (SR 3-21271633161 : OTBI Report Export Limitation) for more details.

 

Regards

Sateesh

Use Case and Business Need

We have the validations reports for opportunity ,accounts and contact objects where user wants to see complete data set without any filters in it.

More details

Due to this Limitation we are not able to deliver the report in OTBI  Analysis.

Original Idea Number: 06409aea0b

89
89 votes

Submitted · Last Updated

«13456789

Comments

  • Tessy
    Tessy Rank 2 - Community Beginner

    Same case here. We find it strange that it is a tool for transactional data, which is high volume by definition. Only the tool cannot handle this high volumes. Which makes the reports build useless.

    Even after we did adjust the maximum rows to export in the conficuration of BI and restarted the BI server we couldn't see all the data.

  • Sigrid B.
    Sigrid B. Rank 2 - Community Beginner

    I support this idea and look forward to an opportunity where all relevant data can be exported!

  • Ramadan Reddymasi
    Ramadan Reddymasi Rank 1 - Community Starter

    We are also facing the same issue and spent lot of time in researching and found that this feature is yet to be implemented by oracle. I hope oracle will implement this soon in the product. Thanks

  • MaartenDIF
    MaartenDIF Rank 4 - Community Specialist

    If not within the UI, at least let us schedule the reports to exceed the limits - same as with regular BI Publisher reports which exceed their limits.

  • User_TCBC1
    User_TCBC1 Rank 1 - Community Starter

    This idea is very relevant!

  • Kim Miller-75544
    Kim Miller-75544 Rank 1 - Community Starter

    Our entity is currently over 90K employees and growing so we're automatically over the limit with only 1 line per employee. With these limitations we can't run a simple report with a few columns of demographic data and export consistently

  • James Farrell
    James Farrell Rank 1 - Community Starter

    We have an employee population that would exceed that limit.

  • AlyssiaKing
    AlyssiaKing Rank 1 - Community Starter

    Detailed reports require more thank 75K lines - especially when pulling payroll data. This improvement would be wonderful!

  • Jason G
    Jason G Rank 1 - Community Starter

    running analysis to provide data to senior leadership without creating complex data models.

  • User_Y34OK
    User_Y34OK Rank 1 - Community Starter

    Increasing the limit would be useful for lot of OTBI reports which we have.