Supplied parameter tied to Bound List not returning value
Hi community,
I have an issue where i have a member list tied to a bound list. The bound list uses a SQL query to get the top member of a given dimension. I have this bound list tied to a supplied parameter that I have attached to a dashboard.
The issue is that when I run the dashboard, it is not triggering the bound list, even though i am using the supplied parameter. If I remove the supplied parameter and run the dashboard, it prompts me with the bound list parameter showing the value i want to return, and thereafter, when i put the supplied parameter back it works. It seems like the system needs to trigger the bound list first, but I haven't found a way to do so yet. Any thoughts?
This is a long-standing issue with the order of evaluation of parameters. Bound lists cannot have a default value, because the system does not know which value could be valid until it runs the sql - which will happen later in the loading process. Once the bound list actually runs and the parameter is set, it is cached, so at the next load it will be there from the start.
What you can do is execute a dashboard extender during the dashboard load, which will set a value in the parameter (aka "custom substitution variable").