OBIEE Dashboard Prompt "All Column Values" Not Filtering As Expected (Doc ID 2151743.1)

Last updated on SEPTEMBER 30, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.10.0.0 version, Analytics

OBIEE Dashboard Prompt "All Column Values" not filtering as expected

Note: The customer is using SQL Results to limit the number of values displayed in the prompt.

Example: In dashboard prompt Fiscal Year column contains values from 2011 to 2015. They are using SQL results to display only values from 2015 to 2025 in prompts, when they choose "All Column Values" and hit Apply , report displays values in 2012 also. In the prompt dropdown do not see 2012, but still 2012 data is getting displayed in report.
 

Solution

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