OBIEE Freeze Pane / Headers

There is a request that the headers in the Pivot Table View “freeze” when scrolling. When
they scroll down, they do not want the headers to move.
Breaking by page option is not allowable and it has to be in Pivot Table View.

After opening an SR with Oracle and trying several options, it appears that freezable header/panes are not possible with the current version of OBIEE. Oracle has advised me that it will be available in the OBIEE 11.1.1.3.0 release per an existing enhancement request #5540847.

If anyone has been able to get this to work, please let me know.

******** UPDATE 2/10/2010************

One of the developers I have been working with, Mark Hancock, has found a solution using some custom CSS scripts.

Insert a static text object on to the dashboard, select the “Contains HTML Markup” option and enter the following text into it:

It works when using IE, but not Mozilla. I get a lot of hits looking for this solution, so please leave a message and let me know if this works for you too.

Column filter using pivot table in Answer

Column filter using pivot table in Answer

Last week a user was asking me to have a drop down box as a filter in the dash board so that he can only sees the data based on the filter criteria.

Well I tried to do that using prompt but it was taking use to different page on selection. So it was not useful at all.

And here it is how I figure out ,you can achieve this using pivot table.

In UsageTracking.rpd repository I will perform above task.

In Answers make the section of the columns as shown below.

Columns selection

Column Selection from repository

Trick is simple: You can use Pages as filter criteria in Pivot table

Arrange Columns, Rows, Measures, and Pages etc as shown in the screen below.

layout for Pivot Table

Now add that view into Compound View to see the filter as shown below.

Fiter with pivot table