OBIEE 11g: Prompt With Is Not Equal To / Is Not In Operator And Multiple Default Values Just Pass One of the Values in the Filter View (Doc ID 1471678.1)

Last updated on JANUARY 31, 2017

Applies to:

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

Symptoms

Issue:
Create a simple report with one of the dim columns as prompted. Then create a dashboard prompt using this same column with operator "is not equal to / is not in" and from the + options in the prompt you specify a list of specific column values, check the "Enable user to select multiple values" and "Enable user to type values" and in the Default selection you choose 2 of those Specific values.

If you put the report and the prompt in a Dashboard Page you will see that in the report you can only see one filter passed, not the 2 specific values you specified in the prompt.

Steps to reproduce:

  1. Create a simple report using the sampleapplite rpd.
  2. Select the columns: Name Year, Product, Product Type and Revenue.
  3. Go to the Criteria Tab and specified in Product Type column filter, is prompted.

    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