OBIEE- How to refresh data in a column prompt without clicking on Apply button

Question

Hi,

I am working on OBIEE 12c.

I have 2 column prompts on my dashboard.

second prompt is dependent on the value selected in 1st prompt. When I choose a static value from 1st prompt using sql results, I need data to be refreshed in second prompt based on the value I selected from 1st prompt which uses 1st prompt values as input.

I am able to achieve this by hitting on Apply button of prompt, my requirement is that when I choose any value from 1st prompt, the values in 2nd prompt should be refreshed automatically based on prompt 1 without hitting apply button.

I am badly stucked on it. Someone please help.

Thanks

DollyG · Answer

I was initially using "All Column Values" but then the requirement changed. I had to introduce 2 more conditions in the prompt, so I switched to "SQL Results". For example, my 1st prompt is Business Unit. 2nd is products. Based on the business unit I choose from 1st prompt, corresponding products are listed in 2nd prompt. Also, I had to display the prompts with additional condition based on date and only those products need to be displayed which had reporting =yes in DB and based on some date criteria.

Gianni Ceresa · Answer

Ok, let's try to take things from the beginning

You said "sql result", so why aren't your 2 prompts standard "all column values" but instead you had to use a "sql result" for the list of values?

Aren't these 2 columns you prompt for linked in a way or another in your model?

Can't you just use the "limit values by" and let OBIEE filter values automatically based on the model?

DollyG · Answer

Hi Gianni,

Thanks for ur reply!

Can u please tell, how can I manage that in my rpd?

I am new to this tool, so not aware of the best practices.

It would be great if u please tell me how can I manage that in rpd?