Pivot table prompts change automatically in Pivot View OBIEE11g

3396145

Hi all,

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

The Pivot table prompts have the following fields:

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

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

[Deleted User]

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

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