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

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
2
Comments
3231180
3231180 Rank 2 - Community Beginner

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.

Answers