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 in MS 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>400</DefaultRowFetchSlicesCount>
<DefaultColumnFetchSlicesCount>300</DefaultColumnFetchSlicesCount>
<DefaultFreezeHeadersClientRowBlockSize>100</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 400 records.
E.g. in Table view and Pivot view
I configured for 400 rows, So..what happens if the record count increases after 400 records?
We can click on “Get more rows” to get more rows as shown in below screen.
Try this it works.
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>400</DefaultRowFetchSlicesCount>
<DefaultColumnFetchSlicesCount>300</DefaultColumnFetchSlicesCount>
<DefaultFreezeHeadersClientRowBlockSize>100</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 400 records.
E.g. in Table view and Pivot view
I configured for 400 rows, So..what happens if the record count increases after 400 records?
We can click on “Get more rows” to get more rows as shown in below screen.
Try this it works.
No comments:
Post a Comment