OBIEE 11g: Prompt Values reset when Switching Certain Prompts based on Essbase Physical Hierarchy

(Doc ID 2174485.1)

Last updated on MAY 01, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Information in this document applies to any platform.


On Oracle Business Intelligence Enterprise Edition (OBIEE) version, and later releases

When selecting a value in one prompt,

For Example -:

The issue can be reproduced using the following steps -

  1. Create 4 column prompts as a Dashboard Prompt
    • prompt 1: fiscal year
    • prompt 2: fiscal day (Limit values based on year)
    • prompt 3: Product type
    • prompt 4: product (Limit values based on product type)
  2. Choose a value for fiscal year and fiscal day and after it a value for product type then the value for fiscal day disappear.



Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms