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 SEPTEMBER 27, 2021

Applies to:

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


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.


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

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