Select Tools-> List of values -> Create Cascading List of values.
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.
Click Generate LOVs.
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 number of objects along with the objects on which the cascading .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 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.