This discussion is archived
3 Replies Latest reply: Jan 21, 2013 12:52 AM by sayak RSS

Excel and CSV Limitation

user607649 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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
    user607649 Newbie
    Currently Being Moderated
    Please let me know
    Where can i configure excel and CSV file limitation in EM.

    Thanks
  • 3. Re: Excel and CSV Limitation
    sayak Explorer
    Currently Being Moderated
    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 .

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points