INCREASE ROW LIMITS IN TABLE PROPERTIES OF OBIEE

Pivot Table Properties

In Pivot table we often get the error “Exceeding Rows”, it means number of rows will be more than the default no of rows fixed in obiee.

Solution:

There is 3 way of solution, one is by increasing the limit in pivot table properties and other is in web logic change the number of rows limits, Change in Instance Config file.

1.   

1      1.Pivot table properties in answer side

      Click edit of the pivot table, click on pivot table properties select bottom page and give the limit of rows you need.

     2.Change in OEM

2.      Login to Enterprise Manager, go to Business intelligence and click on core application Go to 3^rd tab in right side “capacity management” under that click on “Performance” Check this and assign new values to retrieve the number of rows of data “Maximum Number of Rows Processed when Rendering a Table View”

                        

3.     3.  Adding tags to “instanceconfig.xml file”

OBIEE 11g Log Locations:

Catalog Path
Drive:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog

Repository Path
D:\Oracle\Middleware\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

Instanceconfig.xml ----> file path

D:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

NQSConfig.INI file path :

D:\Oracle\Middleware\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1

 
Go to the Instance located path and take a backup of the .xml file and open the file in notepad.

 Add this tag to the file and save it and restart the services.

<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<MaxCells>1920000</MaxCells>
<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Pivot>
<Table>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<MaxCells>1920000</MaxCells>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>

</Table>
</Views>

4.      4. Check in OEM

Go to the tab deployment under that presentation, you can see analysis default tab

Just check in “pivot table show auto-preview”