Freeze Column headers in OBIEE 11G

Disclaimer: Before reading this post. I would like to make a request to all readers. This feature is not supported by oracle at this version and so please do not go to the oracle support for further information. This was the reason that I have removed this post for sometime. But I have seen so many other bloggers are re blogged my content in their blogs and hence I thought of republishing this. Again, I am not responsible for any issues caused because of this. 

There is a very common must have feature in OBIEE, to have a functionality 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.

Now we have this feature in OBIEE 11.1.1.6.0 and enabled through Grid view. Like in ASP.net, Java, the Grid View control enables us to view item collections in a table/Pivot that typically has interactive column headers and scrollable data grid.

By default this Freeze option is not enabled. We need to turn ON by adding set of attributes in OBI PS instanceconfig.xml file under <Views> element, between  <GridView>… </GridView>  class.

These are the available configuration parameters to control the ‘Freeze Headers’ feature.

So let’s enable this and test by adding the attributes in OBI PS instanceconfig.xml file as shown.

Note: Here I am enabling the Column Header freeze option with the Scroll bar if my request contains more than 250 records.

Restart the OBI Presentation service and log into OBI analytics.

Create a new analysis which has more than 250 records. You can test this with either Table view or Pivot view.

Now see the results. Your table view will be equipped with a scroll bar and Fixed column header while you are moving down.

E.g. in Table view

E.g. in Pivot view

Thanks for stopping by here… till next time…

Thanks,

Shiva