Skip to Content

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.

/wp-content/uploads/2013/08/4_264613.png

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

/wp-content/uploads/2013/08/3_264650.png

Save the universe and export to CMS.

Create a new webi  based this Universe.

/wp-content/uploads/2013/08/5_264652.png

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.

/wp-content/uploads/2013/08/6_264662.png

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Krishna Nagh Varanasi

    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.

    (0) 

Leave a Reply