I recently ran into a issue with a user complaining that when they look at a report on a Dashboard page that the "freeze" column headers wasn't working.....weird since I logged in the same test account and I see then and the functionality. After some investigation the user was using IE8. Ok so of too the land of Oracle Support to find out the answer. Put in SR; after looking around and this is the response from Oracle Support. Good to know when accessing the client's environment during discovery phase.
"In IE 7 and IE 8 the Freeze Header is intentionally disabled. If you click the help button on the table properties dialogue you will see the help page contains the following:
...
Note:
Tables and pivot tables that use the scrolling method to browse data do not render properly in Microsoft's Internet Explorer browser version 7 or 8. As a result, when Microsoft's Internet Explorer browser version 7 or 8 is detected, the table or pivot table will be rendered using paging controls instead...."
Friday, June 28, 2013
Thursday, June 27, 2013
OBIEE 11.1.1.6.x + "Excelish" Freeze Column Headers
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
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
Subscribe to:
Posts (Atom)