When Using Choice List Groups with OBIEE 11g Dashboard Prompts the Prompt LOV Only Displays 25 Values (Doc ID 2156444.1)

Last updated on JULY 18, 2016

Applies to:

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


When using OBIEE on Exalytics with a Selection Group and Prompts in a dashboard page, the Prompt List of Values (LOV) only displays 25 values.
This happens even when there are more than 25 possible values.

For example, create an analysis on Sample App Lite.

1. Select following columns: Time.Calendar Date, Time.Per Name Month, Product.Product Number, Orders.OrderNumber an Base Facts.Revenue.
Save the analysis as Product Revenue.

2. Then create a condition and use Selection steps -> starts with All values -> Then Keep Only
Where Column "Time"."Per Name Month"
Operator: is not equal to
Value 2006 /10; 2006 /11; 2006 /12 -> then
Save condition as "My Condition."


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