3 Replies Latest reply: Jan 21, 2013 2:52 AM by sayak RSS

    Excel and CSV Limitation

    970365
      Hi
      I am using obiee11g.Could you please let me know any one what is the excel and csv file limitation rows.
      In CSV when i try to export it should be 2500 rows.

      Thanks
      Gram
        • 1. Re: Excel and CSV Limitation
          user248025
          Hi,

          Its 65,000 rows

          For more you have configure if u r less than obiee v1.6

          18.3.1.2 Manually Configuring Settings for Data in Views
          http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/answersconfigset.htm#CIHHBHAI
          also you can do it via weblogic EM

          Thanks
          deva
          • 2. Re: Excel and CSV Limitation
            970365
            Please let me know
            Where can i configure excel and CSV file limitation in EM.

            Thanks
            • 3. Re: Excel and CSV Limitation
              sayak
              Hi ,

              login to Enterprise manager 11g - > buisness intelligence -> coreapplication - >Capacity Management - > Performance
              - > in the left section you can see :
              Maximum Number of Rows Processed when Rendering a Table View

              Maximum Number of Rows to Download

              Maximum Number of Rows Per Page to Include

              Before doing it , just "Lock and Edit Configuration" and after changing "Activate changes" and restart all services .