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

Pivot table prompts change automatically in Pivot View OBIEE11g

Received Response
1
Views
2
Comments
3396145
3396145 Rank 2 - Community Beginner
edited Aug 13, 2024 5:56PM in Oracle Analytics Cloud and Server

Hi all,

I have the following pivot view in an analysis in OBIEE 11g:

Normal.png

The Pivot table prompts have the following fields:

Selections.png

But when I change the year, it change the rest of the others pivot table prompts. And it puts the first of them:

final.png

How can I hold these pivot table prompts?

EDIT: My OBIEE version is 11.1.1.9.0, and the bundle Patch 25797429: BI BUNDLE PATCH 11.1.1.9.170418

Any help would be appreciated

Best Regards

Adrian

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    That's the behaviour of in-line prompts. I hope you are aware that those prompts do not actually filter the data stream at all but are just used for visual gimmicking.

  • ArijitC
    ArijitC Rank 6 - Analytics Lead

    Just to add with what Christian said, You can have a pivot table in a dashboard with Dashboard prompt that will do what you are looking for.

    Thanks

    Arijit