cancel
Showing results for 
Search instead for 
Did you mean: 

Dashboards Query Browser prompts return no data

Former Member
0 Kudos


Hi Experts,

I am using BEx Query as my data source. When I try to filter values through the Query Browser prompts (built in the Query option) I get no values back. I have tried passing both Values and Key but neither of them return a value. Interestingly I tried filtering on another field on which

seems to work well, but for some reason this field returns no values. I am not sure how to go about resolving this issues, any guidance is much appreciated.

I am using Dashboards Version 6.0.4.0 Build 14,0,4,831

Accepted Solutions (1)

Accepted Solutions (1)

former_member190855
Active Contributor
0 Kudos

Hi Pradeep

Is your query setup to trigger when the parameter changes? Yo have to do that from the usage tab. It is not enough to simply the pass the parameter.

Since your other filter is working this may not be the problem but just checking.

Runali

Former Member
0 Kudos

Thank you! Runali,

I did not have the refresh when value changes option configured, which is why the data did not show up.

have a follow up quesiton:

I am trying to give the user "All" as a selection, any suggestion on how that can be achieved via Query Browser (DS BEx Query)

Answers (2)

Answers (2)

saurabh_sonawane
Active Contributor
0 Kudos

Hi try to use a component name QUERY REFRESH BUTTON

and add the query which you want to show the output.

after that goto behavior tab and map a trigger cell properly.

former_member194862
Active Contributor
0 Kudos

Try passing the same value in the RSRT and check if this works.

Also try using a query prompt selector and check if you are able to pass values