OBIEE 11g: After Clearing A Dashboard Prompt, The Results Are Still Filtered By The Previous Prompt

(Doc ID 2102492.1)

Last updated on AUGUST 09, 2016

Applies to:

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

Symptoms

The results on the dashboard are filtered by the prompt value which is stored in the Save Customization,  even after you have cleared the value of prompt.

This issue can be reproduced and demonstrated with the SampleAppLite repository via following steps:

  1. Create An dashboard which consists of an prompt and an Analysis as following:
    Prompt Columns: Per Name Year, Per Name Month, Product

  2. Open dashboard Page,set prompt value as following:
    Per Name Year: 2008
    Per Name Month: 2008/02
    Product: V5x Flip Phone
    Click apply.

  3. Perform any interaction (e.g exclude or include columns of analysis).


  4. Click Save Current Customization.


  5. Apply Customization which saved.

  6. Deselect the 'Product' prompt to clear product value and then click Apply again.

  7. Set the prompt of Per Name Month to any other value (e.g 2008/02,2008/03) and then Click Apply again.

    You will observe that the results are filtered by "V5x Flip Phone" which were saved in "Step 2." even you have clear its value.


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