Home > Universe Designer > Cascading Prompts

Cascading Prompts


Creating Cascading Prompt in Universe Designer

Create the Classes and objects that are needed to be cascaded in the universe. Bring up the objects in a single folder which falls on a natural hierarchy according to your table relations. Like in the example below, i have used some tables in Adventure Works DW2008 sample database (SQL Server 2008).

Tables :

Factsinternetsales

Dimproduct

DimProductSubcategory

DimProductCategory

BO Product Version:

Business Objects XI 3.1 SP3.

Universe Designer.

1

Considering the best practices on creating the universe objects, i have brought all hierarchical objects in single class folder named "Product". To create cascading prompt, go to TOOLS –> Lists of Values –> Create cascading Lists of Values.

2

A new window for creating cascading list of values will open, it will display the list of available objects in the universe,

put the corresponding objects for cascading list of values in hierarchical order.

Category –> Subcategory –> Product

3

after adding up the objects in order for list of values, check the option "Hierarchical View" to get the prompt view like a collapse/expand style of selection in Web Intelligence,  disabling this option will result in showing the prompt values individually,   like it will show prompts for category, subcategory and product at the last. And Both the view will cascade on selected values.

5

Finally, click on Generate LOVs then cascading prompts are created,

6

Save and Export the universe and start using the leaf level object in the prompt to cascade for above two levels,

In this case, use product object in the prompt for web intelligence Reports, then it will show in either of the styles (Hierarchical view option) according to your choice,

Run the query, Answer for Category then answer for the prompt "Sub category" and finally select the product. Cascading prompts are now created.

image_thumb1

a. Hierarchical View

 

image_thumb2

b. Without Hierarchical View

Advertisements
  1. November 27, 2012 at 6:35 am

    It’s actually a great and helpful piece of info. I am satisfied that you simply shared this helpful info with us. Please stay us informed like this. Thank you for sharing.

    Like

  2. Katherin
    May 20, 2014 at 9:15 am

    My partner and I stumbled over here from a different page and thought I might check things out.
    I like what I see so now i am following you. Look
    forward to looking into your web page yet again.

    Like

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: