Freeze panes obiee 11g

Question

Hi All

We have a requirement in obiee 11g answers where the user needs to freeze the column headers. This is easily acheivable through many ways.

However, there is also a requirement that the first column and its value should not move when scrolled horizontally ( For example a Description column with Actuals from Jan to Dec.)

We cannot use a pivot view here and needs a solution for a normal table view.

In the picture above the description column and its values should remain freezed when scrolled horizontally.

Thanks for the help.

Regards

Vyshak P

Gianni Ceresa · Answer

Hi,

That's actually the default behaviour when using a pivot view and setting the "Data Viewing" as "Fixed headers with scrolling content".

I just did it on a SampleApp 506 running 11.1.1.9 and it's what happened.

Now when you say :

We cannot use a pivot view here and needs a solution for a normal table view.

Well ...

You want to have a pivot but don't want to use a pivot view !!! Do you see the problem?

Be realist ... it's like if you ask us how to implement materialized views and then says you can't use a database and you have only txt files.

Why "you cannot use a pivot view" ?

Choose:

a) use a pivot

b) forget to freeze the first column