O'Reilly logo

Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting by Daniela Bozdoc

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

List of Values

You can add two types of List of Values (LOVs) to a Data Model: SQL Query or Fixed Data.

For the SQL type, as you can see in the following screenshot, you must do the following:

  • Select a Data Source
  • Check Cache Result if you want your result to be cached for the current session
  • Enter or build your SQL Query
List of Values

The other type, Fixed Data requires pairs Label, that is the value to be entered.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required