cancel
Showing results for 
Search instead for 
Did you mean: 

BO4 - Cascading list of values

former_member272336
Participant
0 Kudos
74

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Participant
0 Kudos

Hi Durgamadhab, 

Thanks for info - looks really uesful.

Will Give this a go.

Thanks

former_member272336
Participant
0 Kudos

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
0 Kudos

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
Participant
0 Kudos

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
0 Kudos

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
Participant
0 Kudos

Hi,

Thanks - do you have an example

Former Member
0 Kudos

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
Participant
0 Kudos

Thanks again.

Answers (0)