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 220.127.116.11.0 to 18.104.22.168.0 [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 22.214.171.124.
This is working correctly in 126.96.36.199
Documentation followed to create the groups and calculated items:
This reproduces in 188.8.131.52 as follows:
1) In Answers, select these dimensions:
C1 Customer Name
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