Forum Discussion
Solved
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 p...
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").
JackLacava
OneStream Employee
OneStream EmployeeThis 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").
That's what I ended up doing, by incorporating the SQL into the load function and supplying it to the parameters. Not as elegant as I wanted, but it works now. Thanks
- JackLacava
You can make it slightly more elegant by turning the SQL bound list into a Method one of type Business Rule, which runs a Dashboard DataSet that can share logic with the onload extender.