Skip to Content
Author's profile photo Former Member

creating casacading list of Values in Universe

This demo will show how to create Cascading list of Values in semantic layer and then we will see how it is useful in Webi report.

lets start with universe designer and open existing universe .

Click on Tools and then  List of Values and select create cascading LOV. This is useful in several situation where user had huge data which need to be made use friendly during selection of LOV during report run.


now select the fields required for creating LOV from left to right pane in popup and click generate LOVS./wp-content/uploads/2013/08/2_264646.png


Save the universe and export to CMS.

Create a new webi  based this Universe.


we used query filter as prompt to show the usefulness of these Cascading LOV .now if we had large amount of data we can divide them in category and then select the appropriate value from LOV. for our case city we divided in country then region and then city.


this will make our selection very easy. /wp-content/uploads/2013/08/7_264663.png

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice post,

      Will this work for cross functional dimensions? Say.. Country--> Products

      If I need to show products which are sold in that country by cascading LOVs.. just curious if we can use this concept.