My Oracle Support Banner

OBIEE 11g: There is no List of Values when Creating a Filter in BI Composer (Doc ID 2025285.1)

Last updated on FEBRUARY 16, 2019

Applies to:

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

Symptoms

You have installed OBIEE 11.11..7.x.
How can you have a list of values when adding a filter with 'is equal to' operator when creating an analysis with Bi Composer?
If you follow these steps there is no list of values.

  1. Change preference in My Account to use the BI Composer instead of the Full Editor.
  2. Then New > Analysis > pick a SA.
  3. Create Analysis: Select Columns.
  4. Next.
  5. Create Analysis: Select Views.
  6. Select views to include in the analysis.
  7. Title titleX.
  8. Table Table View.
  9. Next.
  10. Create Analysis: Edit Table.
  11. Next.
  12. Create Analysis: Sort and Filter.
  13. Sort columns and apply filter.
  14. Filter > Add Filter > Select Column.
  15. P1 product "is equal to".

Notice that there is no list of values to create the filter.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.