Google+ Facebook Twitter MySpace SC

Friday, August 24, 2012

List of Values (LOV) in Business Objects Universe

List of Values (LOV) in Business Objects Universe


List of values or LOV is a distinct list of data values associated with an object. When any dimension of details object is created LOV is assigned to an object automatically.
Use of List of values.
When user needs to filter data in a query based on specific object values, User can simply view the LOV of that objects and choose the value on which they want to filter the data.
e.g. if COUNTRY dimension has following distinct values
A,B,C and if user wants to filter the data of country B, user can put a filter on Country dimension and choose the B as filter while executing the query.

How to create a LOV for an object.
  1. Double click on object in designer to view its properties.
  2. Click on Properties Tab
  3. Click on “Associate a List of Values” checkbox.
  4. Select other LOV options based on requirement.
clip_image002
When first LOV is created it is stored in .LOV file name at universe subfolder on the system file system.
The default location is
C:Documents and Settings<UserName>Application DataBusiness ObjectsBusiness Objects 12.0Universes@<ServerName><UniverseName>
LOV Options
List Name
It’s the name of LOV file by which it will stored on local file system. User can override the default name and can enter his own LOV name. Maximum character limit is 8.
Allow Users to Edit List of Values
When checked this option allows report users to edit the list of values of an objects. The purpose of a list of values is usually to limit the set of availablevalues to a user. If they can edit a list, you no longer have control over the values they choose. Normally, if you are not using a personal data file as a list of values source, you clear this option to ensure that users do not edit lists of values.
Automatic Refresh before Use
When selected this option LOV will be refreshed each times it is referred and used in report. You should choose this option only if contents of underlying column are frequently changing. This options should be use very carefully after evaluation. If this option is not selected LOV is refreshed first when the objects is used in a user session.
Hierarchical Display
Select the Hierarchical Display property to display the cascading list of values as a hierarchy in Web Intelligence.
Export with Universe
When this option is selected LOV file associated with object is exported to universe CMS and gets stored as XML on CMS
Viewing the LOV of an object
To view the LOV of an objects click on display button on properties tab of an object
clip_image004
Modifying the LOV of an object
You can remove the values from LOV of an object by applying a filter or add values to LOV by adding a column.
Apply condition on LOV
To apply condition on LOV
  1. Click on Edit button on objects edit properties tab
  2. The designer query panel will appear showing default object of a LOV
  3. Drag drop the condition object in condition pane and specify the appropriate condition.
  4. You can also view the SQL of the LOV query by click on SQL icon on toolbar.
  5. Run the query to test the values after applying condition on LOV
clip_image006
View and Edit LOV of complete universe
You can also view all the object which has LOV associated with them and edit them.
  1. Click on Tools->List of Values->Edit
  2. List of values dialog will appear
  3. Select the LOV objects and click on Edit if you want to edit a LOV.
clip_image008
  1. In addition to query you can also define LOV for an object using personal data file like CSV and values from this file can also be used as LOV for an object. To do so.
  2. Click on Personal Data and provide the details on Personal data LOV dialog box.
clip_image010
Cascading LOV
Cascading LOV is a LOV associated with hierarchy of an object in the universe. Cascading LOV is created, and if any of the object is used as prompt filter in report query, user has to answer series of values from cascading LOV.
How to create Cascading LOV
  1. Click on Tools->List of Values->Create Cascading LOV.
clip_image012
  1. Add the object and re-arrange them as per your hierarchy
  2. Click on generate LOVs
  3. Click OK.
Now if you use any of the objects as prompt in query. It will prompt the hierarchical LOV to user.

No comments:

Post a Comment