multiple prompts

[system]

Hi,

I need to get two values as prompts in a report, which are to be selected from LOVs.
The second LOV depends on the first LOV selected. Is it possible to create prompts of this kind in XI R2?

Eg: I need to select “country” first from list of countries and the next prompt “state” should vary according to the country I select

Thanks in advance.

Regards,
Meena

---

Meena (BOB member since 2005-04-20)

[system]

Hi,

You can use the Cascade prompts for this.

Visit the following link for more details:

cascading prompts...

this is a pretty obvious request and something i get from all my clients but have never found a great way to accomplish... anyone have ideas on how to create cascading prompts that work well? i've gone about the typical BO way of editing my child objects LOV and entering a prompt on the Parent object (to allow the users to pick a state first, then a city (only listing cities for the state previously chosen))... but that doesn't seem to work well at all in BO (and only halfway acceptable in We…

---

bvrswamy (BOB member since 2006-06-18)

[system]

Yes: How do I create cascading or nested prompts?

Note:
Cascading prompts work backwards in Buiness Objects and do not generate cascading conditions, example:

Imagine Cascading prompt:

1. Prompt for State
2. Prompt for city according to the selected state

In Business Objects once you have created the cascading prompt you will first be prompted for city, then when you look at the LOV you will be prompted to pick a state, then the LOV for city will appear (backwards).

Now you pick the state “Georgia”, the city LOV will display all cities in GA, and you pick the city “Rome” (note there is a Rome in GA and a Rome in OH). The final condition applied to your data provider will be City = Rome (without a condition on state!). So you will get data for Rome, GA as well as Rome, OH!

To get around this you must guarantee that the final value picked in your prompt (here: city) is unique. In this example you might have to create an object “City with Zipcode” defined as:

City || Zip_Code

and create your cascading prompt based on this new universe object.

---

Andreas (BOB member since 2002-06-20)

[system]

Thanks a lot Swamy & Andreas!!
I found the links very useful.
And I’ll try to back track as you said…

---

Meena (BOB member since 2005-04-20)