SATYA RANKI REDDY OBIEE SOLUTIONS: Increase the Row limit in OBIEE

Friday, May 17, 2013

Increase the Row limit in OBIEE

Increase the Row Limit in OBIEE

To Increase the Row limit in OBIEE , add the following tag to the Instance config file. Make sure to take back up instance config file.

<Views>
<Pivot>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>

<MaxCells>1920000</MaxCells>
<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Pivot>
<Table>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<MaxCells>1920000</MaxCells>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Table>
</Views>

OBIEE 11g - Download All/Display All of rows in Answers:

To implement the solution, please do:

Change instanceconfig.xml file in <biee11g_install>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 as following

<Views>
<Pivot>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>

<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Pivot>
<Table>

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Table>
</Views>

3. Note the new elements added are the following to both <Pivot> and <Table>, the Pivot part controls Pivot view, and Table part controls Table View, my testing was done with Table View.

4. Restart Presentation Server from EM, then run your request, do excel export to verify.

Thanks,

Satya Ranki Reddy

3 comments:

!!!RAGHAV!!!August 28, 2013 at 10:31 AM
Hi Satya,

I have a issue with report.When I put any column in the section the report displays all the rows.Paging is not applied to the report.Could you please help me
ReplyDelete
Replies
SatyaAugust 28, 2013 at 11:57 AM
Hi Raghava,

Thank you for visiting my blog.

Try this method:

Open your report --> click result --> Edit report--> In the top you can find XYZ properties --> Here you can find option like Rows per Page here you can define the row limit.

Still it is not displaying someone added xml tags in your instance config files please remove that .

Thanks,
Satya Ranki Reddy
ReplyDelete
Replies
charanMay 14, 2014 at 8:01 PM
Hi Satya,

how to change in obiee 10g environment using EM?

i have done in 11g using em. it is working.
but in production 10g is running..
could you pls help in finding the solution.

Thanks in advance.

Regards,
charan
ReplyDelete
Replies

Add comment