BO4 - Cascading list of values

[former_member272336]

Hi,

We have a child table and want to customise the list of values

e.g  parent table has 15 entries numbers 1 to 15.

Child table has several thousand entries for each

want to limit the love for child such that they have to enter the parent code for this when they do this - what is the best way to do this?

Thnaks

[Former Member · Accepted solution]

Hi Phillip,

You can acheive this by creating a universe parameter using a universe parameter build on top of business layer objects and define the navigation path in the parameter..

Check the link below for details ..

How to create a cascading List of Values (LOV) in UNX with hierarchical display - Business Intellige...

[former_member272336 · Accepted solution]

Hi Durgamadhab, 

Thanks for info - looks really uesful.

Will Give this a go.

Thanks

[former_member272336 · Accepted solution]

Hi

Is there a way to limit the child list of values such that only shows what entered for first one

e.g when select child object and list of values only shows entries for that one rather than the full hierrachical tree?

Thanks

[Former Member · Accepted solution]

Let me understand little better.. Can you provide a example what you want to achieve?

These are just list of values and you can setup your parameter in any way you would like to using @prompt function and then tag these list of values to make it easy for selection..

[former_member272336 · Accepted solution]

Hi,

2 objects Country and City

If take United Kingdom as example with Scotland, England, Wales and Northern Ireland

Whenever someone asks for City and list of values we want them to always be prompted to enter the choose the country first to limit the cities shown.

Thanks

[Former Member · Accepted solution]

If you want if any power user to always have the cascading list while creating a prompt on this objects .. Then you can create a pre built filter in universe and tag that filter with this Hierarchical LOV using @prompt  ..  So when some one uses this filter he will always have to select a country to see and select cities..

[former_member272336 · Accepted solution]

Hi,

Thanks - do you have an example

[Former Member · Accepted solution]

You can use the below sample @prompt code for your

Table.city  IN @Prompt('Enter City ','A','Country\City',Multi,Free)

Please check page 410 of the document below for more details.. Also make sure the LOV used in the formula is setup as a cascading LOV..

http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp2_info_design_tool_en.pdf

[former_member272336 · Accepted solution]

Thanks again.