Recently had a client as for the freeze column heading feature in OBIEE 11g turned on. They stated "You know like Excel". So off on another stroll through the documentation and found the following:
1. Stop the Presentation Services.
2. Open instanceconfig.xml at <MiddlewareHome>\instances\<YourOBIInstance>\config\OracleBIPresentationServicesComponent\coreapplication_obips1
3. Locate closing tag for </Views>; which should be at the end of the file.
4. Add below entry before </Views> and save:
<GridViews>
<DefaultScrollingEnabled>true</DefaultScrollingEnabled>
<DefaultRowFetchSlicesCount>500</DefaultRowFetchSlicesCount>
<DefaultColumnFetchSlicesCount>300</DefaultColumnFetchSlicesCount>
<DefaultFreezeHeadersClientRowBlockSize>60</DefaultFreezeHeadersClientRowBlockSize>
<DefaultFreezeHeadersClientColumnBlockSize>15</DefaultFreezeHeadersClientColumnBlockSize>
</GridViews>
5. Save the file and start the Presentation Services back up
No comments:
Post a Comment