OBIEE 11g: Prompt Values reset when Switching Certain Prompts based on Essbase Physical Hierarchy (Doc ID 2174485.1)

Last updated on FEBRUARY 10, 2017

Applies to:

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

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.x 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.

 

Cause

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