Last updated on JULY 18, 2016
Applies to:Oracle Exalytics Software - Version 184.108.40.206.0 and later
Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.150120 and later
Information in this document applies to any platform.
When using OBIEE 18.104.22.168.150120 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
Million Knowledge Articles and hundreds of Community platforms