Logo DWBI.org Login / Sign Up
Sign Up
Have Login?
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Login
New Account?
Recovery
Go to Login
Google icon Login or Sign Up with Google Facebook icon Login or Sign Up with Facebook Twitter icon Login or Sign Up with Twitter
By continuing you indicate that you agree to Terms of Service and Privacy Policy of the site.
SAP Business Objects

BO List of values

Saurav Mitra
Updated on Sep 30, 2020

A list of values contains the data values associated with an object. These data values can originate from a corporate database, or a flat file such as a text file or Excel file. List of Values is a powerful feature that allows users to select from a pick list when setting conditions in a query.

Implementation Steps:

  • Open DESIGNER and Import Universe.
  • Select a class and a specific object by double clicking.
  • Select Properties tab.
  • Give a list name.
Edit Properties of Dimension
Edit Properties of Dimension
  • Click Edit button.
  • Drag the selected object in the condition pane ,give desired operator and type the values manually.
  • Run and Click save and close.
Query Panel
Query Panel
  • Check values by clicking the display button.
List of Values of Dimension
List of Values of Dimension
  • Save and Export the Universe. When we perform this action a .lov file that gets created in the same folder where the universe is stored and get exported along with the universe in the repository.
  • Open a Web Intelligence Document and select the exported Universe.
  • Select any object along with the object on which .lov file is created in the Query pane.
  • Select the object having the LOV in the query filter pane , select an operator (in list) and try to insert values from a list.
  • We will see that the list of values window will just show the values that was previously selected and saved as a .lov file in the Universe level.
Select List of Values
Select List of Values
  • Run the query and we will see that only the selected values in the universe level of the object on which .lov file is created appears in the result with corresponding mapping of other objects selected in the query pane.
Report using LOV
Report using LOV

Using Cascading List of Values (LOVs)

Similarly you can create Cascading List of Values. Cascading List of Values is a Hierarchical LOV selection method which allows users to select highest level of list first followed by the next hierarchical level when setting conditions in a query.

  1. Open DESIGNER and Import Universe.
  2. Select Tools-> List of values -> Create Cascading List of values.
  3. Select some objects of same or different classes from the available pane by pressing Ctrl key and add them to the cascading list of values Panel by clicking the right arrow key. The hierarchies / priorities can be changed by the up or down arrow key. Allow the user to give some prompt values by giving a prompt text.
  4. Click Generate LOVs.
  5. Save and Export the Universe. When we perform this action a .lov file that gets created in the same folder where the universe is stored and get exported along with the universe in the repository.
  6. Open a Web Intelligence Document and select the exported Universe.
  7. Select any number of objects along with the objects on which the cascading .lov file is created in the Query pane.
  8. Select the object having the LOV in the query filter pane , select an operator (in list) and try to insert values from a list.
  9. We will see that the objects with a higher hierarchy in the cascading list will first ask for the values from the list and then only object with the lower hierarchy can be populated with available values.