Hi,
I need to create a 3 level hierarchy prompt, meaning for example, I want the user to select a project, according to his selection, give him a selection of stations and according to the station provide him with a list of operation in the station for which the report will be based. I know how to make a 2 level nested prompt, does anybody have a solution for 3 levels?
Regards,
Ronen Baran, E-Business Project Manager
Tecnomatix LTD.
Mail to : rbaran@tecnomatix.com
Telephone : 09-9594959
First, create 3 dummy objects in your universe (you can hide them afterwords). For each object you modify the query which generates your list of values. Add a condition with a prompt in the query of the list-of-values for all objects except the top one (cfr. your hiÎrarchy).
e.g. - with condition
" equal to @prompt(“Select subgroup”)" - with condition
" equal to @prompt(“Select Group”)"
Last, you make a predefined condition on your object :
= @Prompt(“Select Product”)
When users will use this condition and they click the values-button they will first be prompted “Select subgroup”. When they press the values button at that level, they will be prompted for “Select group”. After selecting the group they will see the corresponding sub-groups. After selecting the correct sub-group they will see the products for the selected sub-group.
Hope this helps.
Kind regards,
Paul Vandenhende
BusinessObjects Consultant
Tel : 0477/390.637
http:/www.sofico.be