HI ,
i need some information for building cascading prompts,
thanks
rgupta97 
(BOB member since 2005-11-18)
I don’t want to pick on you, I really don’t. But you made it so easy. 
The fact that you use the term “cascading prompts” leads me to believe that you at least have some idea of what you’re looking for. And with that, may I present some general courtesy rules that apply to any online discussion board…
Rule 1: SEARCH FIRST!
Rule 2: Read the FAQ / Sticky topics! They are there for a reason.
FAQs have the answers to quite a few topics, entries such as this one in the Semantic Layer (Formerly known as Designer) forum titled, strangely enough:
How do I create cascading or nested prompts?
Dave Rathbun (BOB member since 2002-06-06)