Freeze Column header in OBIEE 11g(11.1.1.6.0)

We have a 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.

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″

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>

Note: Above entry freeze column header option is enabled when number of rows is greater than 200. You can specify the number of rows as you desire. 

1.       Save the file

2.       Start the Presentation Services. 

I configured for 200 rows, so if the record count increases after 200 records,

We can click on “Get more rows” to get more rows as shown in below screen

This is how table should look like: