1 Reply Latest reply on Nov 8, 2016 10:07 PM by Gianni Ceresa

    Freeze panes obiee 11g

    2773333

      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

        • 1. Re: Freeze panes obiee 11g
          Gianni Ceresa

          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

           

          Capture.PNG

          Capture.PNG