Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Freeze panes obiee 11g

Received Response
61
Views
1
Comments
2773333
2773333 Rank 4 - Community Specialist
edited Aug 13, 2024 6:10PM in Oracle Analytics Cloud and Server

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.

pastedImage_0.png

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

Thanks for the help.

Regards

Vyshak P

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    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