OBIEE 11g - Download All/Display All of rows in Excel

3231180

Hi Team,

The user sees an error message at the bottom of excel document.

View Display Error Maximum total number of cells exceeded (Configured Limit: 1000000). Error Codes: EY692ZW9

Already in instanceconfig.xml file,issue with max rows export to excel functionality and that seems to be normal as it is already set to maximum

<DefaultRowsDisplayedInDelivery>1000000</DefaultRowsDisplayedInDelivery>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDownload>2000000</DefaultRowsDisplayedInDownload>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DisableAutoPreview>false</DisableAutoPreview>

<MaxVisibleColumns>10000000</MaxVisibleColumns>

<DefaultRowsDisplayed>100000</DefaultRowsDisplayed>

<MaxVisiblePages>5000</MaxVisiblePages>

<MaxVisibleRows>10000000</MaxVisibleRows>

<MaxVisibleSections>10000000</MaxVisibleSections>

<MaxCells>10000000</MaxCells>

</Pivot>

<Table>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDelivery>1000000</DefaultRowsDisplayedInDelivery>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDownload>2000000</DefaultRowsDisplayedInDownload>

<DefaultRowsDisplayed>10000</DefaultRowsDisplayed>

<MaxVisiblePages>5000</MaxVisiblePages>

<MaxVisibleRows>1000000</MaxVisibleRows>

<MaxVisibleSections>1000000</MaxVisibleSections>

<MaxCells>1000000</MaxCells>

</Table>

</Views>

could anyone help me ..its very urgent..

Thanks in advance.

Gianni Ceresa

Please avoid double posting OBIEE 11g - Download All/Display All of rows in Excel

Now there are 2 threads will probably stay unfollowed and open forever ...

[Deleted User]

Close this thread.