General OBIEE

Get Involved. Join the Conversation.

Topic

    Robin O'Connor
    Any way to bypass the row LimitationAnswered
    Topic posted February 8, 2017 by Robin O'ConnorBronze Crown: 15,000+ Points, tagged Analyses, OBIEE Answers, OTBI, Report Output, Reports 
    1518 Views, 11 Comments
    Title:
    Any way to bypass the row Limitation
    Summary:
    Bypass Row Limitation
    Content:

    Is there anyway to bypass the row limitation?  There are times I need to be able to analyze more than 25,000 rows of data.  This is causing a lot of work to divide reports up to be able to get to all of the information needed. 

    Best Comment

    Neil Peacock

    Hi Robin,

    If you export the report as a Data - CSV file, you will have a higher limit of rows. I believe this is 65,000. However this method can lose some formatting and will be exported in the order you have the data in the criteria tab, rather than in the results tab. So you might have to make your criteria match your results order and import into excel from text to continue to use any vlookups to older documents.

    This method will allow you to analsyse up to 65,000 rows on your preexisting report.

    Neil

     

     

    Comment

     

    • Arun Raj

      Hi,

      Are you using a OTBI report? We had to create a BI report to by pass the issue.

      ~Arun

    • Chris Dabel

      Hi,

      The row limitation cannot be changed. Do you have to analyze all the rows? Or can you get them via another method, then view them in Excel?

      Could you please explain what you mean by "analyze more than 25,000 rows of data"? What kind of analysis do you need to do? The answer will help us be able to advise on alternate ways of getting this information. For example, we have the the Oracle BI Cloud Connector, which may help you meet your business requirement. Here is the BI Cloud Connector overview page.

      Also, as Arun says, you may try using BI Publisher, if you can, to generate the report you need.
       

      Thank you,
      Chris Dabel
      Oracle Fusion Support

    • Neil Peacock

      Hi Robin,

      If you export the report as a Data - CSV file, you will have a higher limit of rows. I believe this is 65,000. However this method can lose some formatting and will be exported in the order you have the data in the criteria tab, rather than in the results tab. So you might have to make your criteria match your results order and import into excel from text to continue to use any vlookups to older documents.

      This method will allow you to analsyse up to 65,000 rows on your preexisting report.

      Neil

       

       

      • Robin O'Connor

        Thanks, I appreciate the tip and I will give this a try.  I have been avoiding using BI Publisher for this since it is a report that one of our end users runs--BI Publisher is too difficult for this user to manage.  They want to extract all absences between a given time period and their business unit is large. 

      • Chris Dabel

        Great point, Neil! Thank you for these tips!

        -Chris

      • Robin O'Connor

        Neil--Exporting as CSV worked!  Thank you so much for the tip.  This saved me a lot of time!

        • Neil Peacock

          Your welcome, glad I could help. We had this issue in another Oracle system when exporting and thankfully it holds true here too.

      • Arun Raj

        Hi Neil,

        Thanks for the tip. I believe in newer versions of Excel (2013, 2016 etc), we can view more than 65000 records.

        Thanks,

        Arun

        • Neil Peacock

          Hi Arun,

          The limitation is not with Excel itself, it is with the export from Oracle being configured to have a maximum row count. These could be changed in the config, however I have been advised on an SR that this is very rare due to the fact that it will get overwritten with patches/updates etc

          Thanks

          Neil

          • Arun Raj

            Thanks Neil. That's an interesting point.

            The excel Template for BI reports has a similar limitation. 

            Regards,

            Arun

             

    • Gustavo Erthal

      Hi all,

      I need to exceed this limit in an analyze with aggregation.

      This limit returns erro when I execute the analyze.

      Is there any SET VARIABLE sufix to use in this case?

      Best regards.