RSS

Export more than 6500 OBIEE 11g records to Excel

26 Aug

To Export more than 6500 OBIEE 11g records to Excel, perform the following steps:

1. Backup Instanceconfig.xml file from location:

<Middleware_HOME>\instances\instance1\config\OracleBIPresentationServicesComponent\

coreapplication_obips1\instanceconfig.xml

2. Edit instanceconfig.xml, with, for example, the content specified as following:

<Views>

<Pivot>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>500000</DefaultRowsDisplayedInDownload>

<DisableAutoPreview>false</DisableAutoPreview>

<MaxVisibleColumns>300</MaxVisibleColumns>

<MaxVisiblePages>1000</MaxVisiblePages>

<MaxVisibleRows>1000</MaxVisibleRows>

<MaxVisibleSections>30MaxVisibleSections>

<DefaultRowsDisplayed>50</DefaultRowsDisplayed>

<MaxCells>500000<MaxCells>

</Pivot>

<Table>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>500000</DefaultRowsDisplayedInDownload>

<MaxVisiblePages>1000</MaxVisiblePages>

<MaxVisibleRows>1000</MaxVisibleRows>

<MaxVisibleSections>30</MaxVisibleSections>

<DefaultRowsDisplayed>50</DefaultRowsDisplayed>

<MaxCells>500000<MaxCells>

</Table>

 

<Charts>

<MaxVisibleColumns>2000</MaxVisibleColumns>

<MaxVisiblePages>1000</MaxVisiblePages>

<MaxVisibleRows>2000</MaxVisibleRows>

<MaxVisibleSections>30</MaxVisibleSections>

<JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>

</Charts>

</Views>

 

3. Save the file and re-start all of the BI Services through Enterprise Manager.

Now you should be able to export more than 6500 records to excel.

 

 

Thanks,

Shiva


Advertisements
 
15 Comments

Posted by on August 26, 2011 in BI Publisher, OBI EE, OBIEE 11g

 

15 responses to “Export more than 6500 OBIEE 11g records to Excel

  1. nir

    August 28, 2011 at 12:28 pm

    a. Note that according to written in the instanceconfig.xml it should be done from EM:


    500000

    b. What are the max values, accepted by the OBIEE for all the parameters you mentioned?

     
    • Srini

      April 7, 2015 at 7:31 pm

      Hi Shiva, thought of asking question on related one. The above one answers when we download from analysis to excel. My question is when I download entired dashboard to Excel i get only few records to excel, Do you have any idea on this?
      From Analysis it works fine, but when you put this report onto dashboard and do downlad entrie dashboard to excel i get only few records when it has more. Your help is greatly appreciated and will also post if i find any. Thanks in advance.

       
  2. Rajkiran Taraka

    August 29, 2011 at 2:38 pm

    We need to Change in EM also. If not after restarting the server its again consider the EM setting.
    Path: Business Intelligence->Coreapplication-> Capacity Management-> Performance->
    Maximum Number of Rows to Download to Excel

    Max Values :

    2920000
    5000
    5000
    750000
    250
    100
    100
    25000
    false

    2920000
    5000
    750000
    250
    100
    100
    25000

    2000
    1000
    2000
    50
    4096

     
  3. Rajkiran Taraka

    August 29, 2011 at 2:38 pm

    Max Values :

    2920000
    5000
    5000
    750000
    250
    100
    100
    25000
    false

    2920000
    5000
    750000
    250
    100
    100
    25000

    2000
    1000
    2000
    50
    4096

     
  4. nir

    August 29, 2011 at 3:54 pm

    Thanks for response.
    There is problem with the html code in the comment.
    Can you please specify the parameter and the max value as simple text?

     
  5. Rajkiran Taraka

    September 11, 2011 at 6:10 pm

    2920000

     
  6. Sona

    January 16, 2012 at 10:30 am

    Hi Shiva Molabanti,

    I designed analysis that includes a table (column for items & column for values) and a chart for this table in obiee 11gR2.
    My problem is that the Arabic items shown correctly in table but when I make the bar chart it shows the Arabic letters but in reverse order, so it is not readable. Even the chart title in Arabic shows in reverse order.
    i tried to edit instanceconfig.xml, according to this doc :http://docs.oracle.com/cd/E21764_01/bi.1111/e10541 with added this code to instanceconfig:

    True
    5
    10
    png
    \\CORPORATE\Download\Flash
    E38CDB6E-BA6D-21CF-96B8-432553540000

    after restart BI services ,BI presentation was not work correctly and this error is appeared on explorer:

    Error 500–Internal Server Error

    From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1:

    10.5.1 500 Internal Server Error

    how can I solve this?what’s your suggestion?
    Thanks in advance
    Sona

     
  7. Sona

    January 16, 2012 at 10:32 am

    [Charts]
    True
    5
    10
    png
    \\CORPORATE\Download\Flash
    E38CDB6E-BA6D-21CF-96B8-432553540000
    [/Charts ]

     
  8. Sona

    January 16, 2012 at 10:36 am

    oh sorry , i wanted to send my code couple of time.
    [Charts]
    [EmbedFonts]True[/EmbedFonts]
    [SectionSliderDefault]5[/SectionSliderDefa ult]
    [SectionSliderLimit]10[/SectionSliderLimit ]
    [DefaultWebImageType]png[/DefaultWebImageT ype]
    [FlashCodeBase]\\CORPORATE\Download\Flash[ /FlashCodeBase]
    [FlashCLSID]E38CDB6E-BA6D-21CF-96B8-432553540000[/FlashCLSID]
    [/Charts]

     
  9. srinivasa reddy

    December 17, 2013 at 3:40 pm

    can i use this code for bi publisher 11.1.1.7 standalone to increase the number of rows.
    or
    OBIEE 11.1.1.7 in both. can u reply back. we ae using bi publisher 111.1.1.7 in our project.

     
  10. Jgadeesh

    December 23, 2013 at 6:47 am

    Hi,

    We are using OBIEE 11.1.1.6.0. When we try to download report into excel, it takes longer time. Have anyone exprerienced the same. If so please let me the solution.

    Thanks
    Jagadeesh

     
  11. Imran

    February 3, 2014 at 4:12 pm

    Hi Shiva,

    Can we able Increase the limit of export option to excel in Agents,
    75

     
  12. Imran

    February 3, 2014 at 4:13 pm

    75

     
  13. Narendra

    September 22, 2016 at 12:48 pm

    Hi Everyone,

    Does anyone resolved this issue ? We tried above solution but still we are seeing the same issue. Can anyone please give the way to solve this issue.

    Thanks in Advance !!!

    Regards,
    Narendra

     
    • Shiva Molabanti

      October 12, 2016 at 12:16 am

      What is the issue you are facing? when you are adding the higher numbers, make sure you have enough RAM & CPU sources. Otherwise BI will keep spinning with sending/recieving teh requests and failes with the timeouts.

       

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: