I have a requirement in which I am having three different prompts, when selection happens in first prompt, it triggers the second and when selecting the second, it triggers the third. But each time I have to select 'Go' Button on each prompt to reflect the changes. Is there any other way like event handling in order to automate the process like when user selects a prompt, it autorefresh the second and third not including the 'Go' Button. Please help.
You can try "Constrain" option in 10g to limit the values of prompts, bi server will run the queries by including the values selected in the first prompt . Please note this will not populate the prompt results automatically but values will be constrained when the selection screen appears.