We tried following instructions for cascading prompts and we are not successful. Our cascading prompts are such:
Model Year
Make Name
Model Name
Model Descriptions
Even though the prompts do cascade asking for model year, make name,Model Name, Model Descriptions the query returns all possible combinations of the model year selected.
Model year is the first (Base) prompt in the cascade. Any sugesstions thanks in advance.
nrashidi (BOB member since 2002-08-21)
nrashidi – a cascading prompt simply limits what is displayed to a user, based on previous prompt answer(s).
It sounds to me like you end up with a single query condition for selecting a model year, and you see all rows for that model year?
It sounds like you need to have more conditions – restrict what is returned for more objects than just just model year.
Anita Craig 
(BOB member since 2002-06-17)
Hi,
I’m starting this thread again after a year. I am having the same problem.
The cascading part works fine. But the query does not take all prompt answers as where part of the query. It taks only the last prompt value as part of where clause and generates the output for that.
How can I make the other (inner) prompt values a part of my query?
Akshay
akshay 
(BOB member since 2004-02-05)
I’m having exactly the same problem, so I thought I’d add to this thread to see if anyone can offer an answer.
Thanks,
Chris
choll (BOB member since 2005-07-05)
Cascading prompts in BusinessObjects are used to ultimately select only one value. And that’s the most detailed value. It is, unfortunately, the way the “trick” works. In Crystal XI (not Webi XI) you can build cascading prompts that include the criteria for each level of the prompt. You could probably do the same in BusinessObjects, but you would end up asking the user twice for the same thing. Since the “cascade” part of the prompt is only used for the list of values, it doesn’t get passed back to the document.
Dave Rathbun (BOB member since 2002-06-06)
Hi Dave,
Pits. No workaround? Is there any way to set a variable to the user’s choice so it can be used in subsequent queries? Can subqueries be used to offer applicable choices (to previous selections) and query on all responses? 
Thanks,
Chris
choll (BOB member since 2005-07-05)
The problem is that the nested or cascading prompts are not used to fill in a query parameter, they are used to restrict the values shown on the LOV query only. So the short answer is, under the 6.5 BusinessObjects architecture and earlier versions, No. Not as far as I know.
You can get creative with VBA, but that only works for full client reports, and only when refreshed via full client users or ZABO users with VBA installed. And it’s not generic; so you would be looking at a lot of code.
This is not something that BusinessObjects does well, or at all frankly. As I mentioned, in Crystal XI the developer can create cascading prompts but can also store and use the intermediate results as part of the query restriction. That’s not possible (as far as I know) within BusinessObjects. Not within the framework of the current solutions, anyway.
Dave Rathbun (BOB member since 2002-06-06)
So is there no work around for cascading prompts in BO 6.5. ?
mak1600 (BOB member since 2006-02-09)
I think it’s pretty clear. You can simulate cascdading prompts, but they don’t work very well.
There is no workaround. BO simply doesn’t have this functionality. It’s amazing, but true.
Steve Krandel (BOB member since 2002-06-25)
Does XI R2 have any workaround to implementing cascading prompt? Thanks.
aaddiitt (BOB member since 2005-03-17)
Not one that works 100%, no. There is a cascading prompt feature in Designer, but all it does is automatically build LOV’s that reference other fields. It does not perform the full function that would be required.
Dave Rathbun (BOB member since 2002-06-06)
But isn’t that the same as what we do manually in 6.5??? This sucks!
Thanks anyways.
aaddiitt (BOB member since 2005-03-17)
Yes, it does suck. It’s cascading LOVs; not cascading prompts and conditions.
Steve Krandel (BOB member since 2002-06-25)
Hi,
I am newbie to BO world, and it has not been a pleasant exp so far, working on BO XI R2. I am trying to implement Cascading Prompts. I see that there is no way of implementing Cascading LOV’s with the selected value at various levels showing up in the where condition, only the last level value shows up in the Where clause, this is really ridiculous.
For Eg if I have 4 levels (in reality I have 8 levels)
Region
Country
State
County
For Eg. If
Somebody selects
Region: North America
Country: USA
State:California,NY
County:ALL
With the current Cascading setup I see that the WHERE clause has just County=‘ALL’ and none of the other levels show up. I know of one sad workaround i.e
Create a prompt for each level, but then the user will have to go through selecting diff levels again and again for each prompt which again opens up scope for making a wrong selection in one of the levels.
Cascading Prompts has surely turned out to be a pain.
Can anybody see any workaround?
Thanks in advance
reachzak (BOB member since 2007-03-12)
Unfortunately, that’s the way it works. If you use Crystal there is a way to apply a condition for each level of the prompt. Webi, Deski, no such luck.
Dave Rathbun (BOB member since 2002-06-06)