Restict Number of Row for Table View in OBIEE

OBIEE Presentation server provides an ability to restrict the number of rows to be displayed in table view.

The Administrator can set the number of rows to be displayed in table view by configuring the InstanceConfig.xml file.  

Assume that, a table called Emp_Olem consists of 1000 rows, by default all the rows will be display in table view. Administrator can restrict to 10 (or any number he can specify ) rows. 

Below are the steps to achieve this :

1. Open instanceconfig.xml file.

2. Locate <ResultRowLimit >  tag and define the number of rows to be displayed.

         <ResultRowLimit >10</ResultRowLimit >

     If the above tag is not there in your config file, then add it.

        <ServerInstance>

             <ResultRowLimit >10</ResultRowLimit >

        <ServerInstance>

     

 3. Save the file and restart the Presentation Server.

 4. Now, check the result.

Drag some logical columns into Answers then click on Results.

Only ten rows are displaying even though the table having 1000 rows. But in Pivote Table, all the rows will be display. This applies only to table view.

Note : BI server retries all the rows, ie 1000 rows from the database but display only ten 10 rows in table view.

We can also configure number of rows to be display per page. To read about this click here.