Thursday, June 21, 2012

Freeze Frames in OBI 11.1.1.6.x

Finally we have the "freeze pane" option that many users have asked for for years.......Below is the changes needed in instanceconfig.xml:

<Views>
<GridViews>
<DefaultScrollingEnabled>true</DefaultScrollingEnabled>
<DefaultRowFetchSlicesCount>500</DefaultRowFetchSlicesCount>
<DefaultColumnFetchSlicesCount>50</DefaultColumnFetchSlicesCount>
<DefaultFreezeHeadersClientRowBlockSize>40</DefaultFreezeHeadersClientRowBlockSize>
<DefaultFreezeHeadersClientColumnBlockSize>30</DefaultFreezeHeadersClientColumnBlockSize>
</GridViews>

</Views>


Details on what each item means:


DefaultScrollingEnabled - Turns on or off scrolling for all pivot or table views.
DefaultRowFetchSlicesCount - Set the "up to" how many rows to fetch server side for determining the scrollbar height for freeze headers.
DefaultColumnFetchSlicesCount -  Set the "up to" how many columns to fetch server side for determining the scrollbar (across) width for freeze headers.
DefaultFreezeHeadersClientRowBlockSize - Sets how many rows to fetch in one block for freeze headers.
DefaultFreezeHeadersClientColumnBlockSize - Sets how many columns to fetch in one block for freeze headers.

There is a post on OTN with the same:

No comments:

Post a Comment