RSS

Freeze Column headers in OBIEE 11G

04 May

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

About these ads
 
17 Comments

Posted by on May 4, 2012 in BI Publisher, OBI EE, OBIEE 11g

 

Tags: , , , , ,

17 responses to “Freeze Column headers in OBIEE 11G

  1. bidevatapraveenkumar

    May 5, 2012 at 1:31 pm

    Nice Post Shiva…This is very useful when we have huge amount of data…

     
    • Alex Mendelev

      May 6, 2012 at 2:02 pm

      Shiva,
      Very nice post! I’ve been waiting for this feature for ages! Is there any official documentation on this?
      I tried your solution, and I’m getting the scroll bar, but after some scrolling I’m getting an error Message:
      “trimBuffer is removing all blocks due to no overlap. This is unexpected”
      Do you have any suggestions?

      Best regards,
      Alex

       
      • Shiva Molabanti

        May 8, 2012 at 5:51 am

        Alex,
        Try to alter the numbers in above tags and also check the JVM.

        Thanks,
        Shiva

         
  2. Ram Chaitanya

    May 7, 2012 at 6:57 am

    Thanks Shiva!
    Is this feature officially supported? Oracle just told us a week ago that this will be available in a future release. And I dont seem to find links to any documentation either…

     
    • Shiva Molabanti

      May 8, 2012 at 5:52 am

      Sorry Ram,
      This is just my finding on OBIEE configurations. There is no any official documentation on this.

      Thanks,
      Shiva

       
  3. Ross Morrissey

    May 7, 2012 at 3:50 pm

    Very helpful – but…

    These seem to be stuck in a 700x400px box. Is there a way to grow that box?

     
  4. SMR

    May 15, 2012 at 9:20 pm

    Why was the post removed?? I was about to do it!! =(

     
  5. George Kallikratis

    May 16, 2012 at 6:43 am

    Why can’t we see the post anymore?????

     
  6. Deepika

    May 22, 2012 at 12:44 pm

    i m not able to access this link. i need it urgently

     
  7. Sajan

    June 27, 2012 at 3:27 am

    Can this be done in Oracle Business Intelligence Product Version 11.1.1.5.0??

     
  8. Yojana

    July 3, 2012 at 11:27 am

    Hi, I tried to do what you suggested for Oracle 11.1.1.5 and I’m afraid it doesn’t work. I’m getting an error that all parameters in the GridViews tag are an Unknown Element.
    Please share if you have any work-arounds. Thanks.

     
  9. Atul Sharma

    July 20, 2012 at 10:25 pm

    Hi Shiva….Its really a great post and very helpful.
    I have implemented this and its working OK for me, But I am having some issues as..
    1) First It got stuck with a size of approx 700*400 and I am not able to change the size of the view.
    2. As a result of 1st issue, in a table view I am able to horizontally scroll but the first column is not getting ‘freeze’. So its not helpful because when we scroll horizontally the first dimensional column is getting hidden and you see only measures.
    2) In pivot table its freezing the measure section only and works well when we have one dimensional column in rows and column section each but if we have more than 5-6 columns in the Rows section and when you scroll the columns in row section, first few columns will be hidden and you don’t get the complete view.
    3) I have one report which is showing Top 10 values, But its showing a grayed area of same size after 10th row which would be not good to show in a report.

    I am not sure if I am missing something here. I would really appreciate if you can help me out in this.

     
  10. David Granholm

    August 7, 2012 at 10:07 pm

    Note from Oracle Product Management:

    This is not a released feature and has been discovered via inspection of config files. It is planned for a near-term release, but use of this feature as found in shipping product will certainly lead to dead-end development and likely end-user frustration.

    Content created using this capability will not be supported, will not upgrade, will easily break, and most importantly may not yield correct numbers or output.

    I would not recommend promoting or using this partially-implemented capability.

     
  11. Net Grid

    November 17, 2012 at 7:43 am

    The grid supports work with one or multiple headers that can instantly transform the grid from treelist control to fully functional grid with multiple independent headers without changing data structure inside the grid.Every header has two panels the grouping panel and the column panel The grouping panel contains columns with Column.Grouped property set to true, while the column panel contains only visible columns more detail visit dapfor. com

     
  12. kumar

    December 9, 2012 at 5:06 am

    Hi Shiva,
    Can we do this in OBIEE 10.1.3.4 version?if so please let me know the steps.

    Thanks,
    Kumar

     
  13. Yoshi

    August 28, 2013 at 2:25 am

    Hi Shiva,

    Very nice post! This option is exactly what I wanted!
    We tried on OBIEE v11.1.1.7.0 with IE8 and IE9. IE9 seems OK, however with IE8, a scrollbar does not show up and all columns & rows are fully expanded. Does this option work for IE8? If there is any other options, please let me know.

    Thanks,
    Yoshi

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

Join 619 other followers

%d bloggers like this: