My Oracle Support Banner

Prompt values do not refresh for the custom groups when used in the pivot view/table view prompt in OBIEE 12c (Doc ID 2489957.1)

Last updated on JANUARY 30, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version to [Release 12g]
Information in this document applies to any platform.


Prompt values do not refresh  for the custom groups when
used in the pivot view/table view prompt in OBIEE

This is working correctly in

Documentation followed to create the groups and calculated items:

This reproduces in as follows:

1) In Answers, select these dimensions:

P1 Product
D1 Office
C1 Customer Name
2-Billed Quantity

2) Create a Pivot table.

On the Pivot,
P1 Product was moved to Pivot table prompts
C1 Customer Name and D1 Office are on Rows
1-Revenue and 2-Billed Quantity are on the Columns

3) Create 3 Column groups against P1 Product by choosing the New Group

(ie: Abel, Baker and Charlie)

Use various products for each Column group

Those groups were saved in My Folders section

4) In Pivot table, under Selection Steps, for P1 Product

Choose Start with All Members and modified it to include
Action: Start with Group or Calculated Item

  Include Abel, Baker and Charlie

5) Open the Pivot table and in prompt section, my
choices were Abel, Baker and Charlie with default to Abel

However, if you try to change the prompt to Baker or Charlie, it does not

The prompt always remains with Abel and its values





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.