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

DollyG

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

Gianni Ceresa

Hi,

must be the week of the prompts as that's probably the 3rd thread like that I see this week ....

In OBIEE out of the box there is a way to manage dependance between prompts fields, it works using the column prompts and the RPD model to refresh related fields.

If your prompts are based on LSQL queries there is already an issue as it means your model doesn't match the business needs, and so you lose the nice out of the box functionality existing to manage the case.

Why are you using LSQL based prompts? Why that logic isn't defined in the RPD?

DollyG

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?

Gianni Ceresa

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

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.