Join the Community

Sponsor

Free BI Digest

Need more help on this subject?

Error
  • JLIB_APPLICATION_ERROR_COMPONENT_NOT_LOADING

BO List of values

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:

  1. Open DESIGNER and Import Universe.
  2. Select a class and a specific object by double clicking.
  3. Select Properties tab.
  4. Give a list name.

    Edit Properties of Dimension

  5. Click Edit button.
  6. Drag the selected object in the condition pane ,give desired operator and type the values manually.
  7. Run and Click save and close.

    Query Panel

  8. Check values by clicking the display button.

    List of Values of Dimension

  9. 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.
  10. Open a Web Intelligence Document and select the exported Universe.
  11. Select any object along with the object on which .lov file is created in the Query pane.
  12. Select the object having the LOV in the query filter pane , select an operator (in list) and try to insert values from a list.
  13. 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

  14. 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

Using Cascading List of Values (LOVs)

Similiarly 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.

About the Author

Saurav Mitra

Saurav Mitra is a business intelligence professional.
Connect with the author via Google+
 



If you have any doubt or question on the above article, please Ask your question here. We will surely help you out!

Before you leave, Kindly provide your comments / suggestions / feedback below. Thank You!