multiple prompts

building reports desktopintelligence
3

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 :de: (BOB member since 2002-06-20)