The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Parameters in GridView.
I am trying to create a dashboard with GridView as the component. In Gridview am using Dataadapter (SQL Query). I want to pass parameter to the GridView when displaying the data in the dashboard.
C...
Sorry I thought, the gridview is the triggering object, but you are looking for a way to change the query using a parameter.
If you have a sql data adapter, you can use the parameters in the sql script like here:
I hope, this is what you are looking for?
In the sample, Onestream replaces
|!WFProfileCriteria_TCR!|
with the parameter's value:
= 'Houston.Register'
and executes the query with this where statement:
... WHERE XFW_TCR_Register.WFProfileName = 'Houston.Register' ...
It is better to use a Dashboard data set rule when trying to pass parameters into a SQL query. What Christian suggested will work. However, if the parameter is not resolved, this can create errors. Where in which the rule, you can check whether the parameter containssubvars and trigger the SQL or return an empty datatable.
Thank you!
Yes i agree your point. I will apply this in my dashboard.