OBIEE Online Training

Friday, June 10, 2011

Exporting in Excel to download more than 65000 rows in obiee11g/10

Hi,
   update the below code in you instance config.xml file, after that restart all bi services.
<Pivot>
<MaxCells>1920000</MaxCells>
<MaxVisibleColumns>30</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
<DisableAutoPreview>false</DisableAutoPreview>
</Pivot>
<Table>
<MaxCells>1920000</MaxCells>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
</Table>
Thanks and Regards,
Deva

2 comments:

  1. IS there anyway in OBIEE analysis to do a date difference and show year,month,days,hours,minutes as an ageing field?

    ReplyDelete
  2. after updating instanceconfig file with
    1920000
    when trying to see all the results for an report
    my interexplorer take forever to load the page and after 15 min to give an out of memory error.

    Please thank

    ReplyDelete