We have a new feature in OBIEE 11.1.1.6.0 that freezes the data column header. So when a user scrolls down to the bottom of the report, the column header stays in place and only the data rows move. This is similar to the ‘Freeze Panes’ option inMS Excel.
By default this Freeze option is not enabled. We need to turn ON by adding set of attributes in instanceconfig.xml file under <Views> element, between<GridView>… </GridView> class.
To do this..
Navigate to the path “<MiddlewareHome>\instances\instance2\config\OracleBIPresentationServicesComponent\coreapplication_obips1″ and open instanceconfig.xml file and add the below entry between <Views> and </Views> tag
<GridViews>
<DefaultScrollingEnabled>true</DefaultScrollingEnabled>
<DefaultRowFetchSlicesCount>200</DefaultRowFetchSlicesCount>
<DefaultColumnFetchSlicesCount>300</DefaultColumnFetchSlicesCount>
<DefaultFreezeHeadersClientRowBlockSize>60</DefaultFreezeHeadersClientRowBlockSize>
<DefaultFreezeHeadersClientColumnBlockSize>15</DefaultFreezeHeadersClientColumnBlockSize>
</GridViews>
<DefaultScrollingEnabled>true</DefaultScrollingEnabled>
<DefaultRowFetchSlicesCount>200</DefaultRowFetchSlicesCount>
<DefaultColumnFetchSlicesCount>300</DefaultColumnFetchSlicesCount>
<DefaultFreezeHeadersClientRowBlockSize>60</DefaultFreezeHeadersClientRowBlockSize>
<DefaultFreezeHeadersClientColumnBlockSize>15</DefaultFreezeHeadersClientColumnBlockSize>
</GridViews>
The entry in instanceconfig.xml should looks as below screenshot.
Note: Here I am enabling the Column Header freeze option with the Scroll bar if my request contains more than 200 records.
E.g. in Table view and Pivot view
I configured for 200 rows, So..what happens if the record count increases after 200 records?
We can click on “Get more rows” to get more rows as shown in below screen.
