I have a requirement wherein the prompts are inter-related.
Lets say that I have a Continent prompt and Country Prompt. I need when I select Asia on Continent Prompt only Country belonging to Asia should be shown in Country Prompt.
Is it possible to do that.
Thanks and Regards,
Kapil Uppal
kapiluppal 
(BOB member since 2006-06-15)
A) Please, take the time to read through the FAQs first. Start with the Designer FAQs here.
B) Business Objects (Webi or Deski) does a poor job regarding cascading prompts, like it or not. Here Crystal Reports is better.
Andreas 
(BOB member since 2002-06-20)
How poor? I can’t get it to work at all.
Prompt 1:
DATA_SOURCE.NAME IN @Prompt(‘Select Physical or Logical Data Source’, A, ‘Data Source\Data Source’, MULTI, CONSTRAINED)
Works fine on its own.
Add Prompt 2:
(SERVICE_TYPE.NAME = @Prompt(Enter Service Type Name’, A, ‘Service Type\Service Type Name’, MONO, CONSTRAINED)) AND (@Select(Data Source\Data Source) IN (@Select(Service Type Prompts\Data Source)))
And Prompt 1 comes up in list followed by “An internal error occurred while calling the ‘answerPrompts’ API. (Error: WIS 30270)”
Is it me or is it that Cascading prompts doesn’t work at all?
Damocles 
(BOB member since 2006-10-05)