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
Pplant
OneStream Employee
OneStream EmployeeDynamically setting the bound parameter for a Supplied Parameter
Is it possible to dynamically set the Bound Parameter of a Supplied Parameter?
I have tried to use and xfbr rule to do this but the supplied parameter but this does not work.
PplantOneStream Employee
OneStream EmployeeThanks for the input. However, I would like the assignment of the Supplied Parameter to be dynamic, i.e. the Supplied Parameter will exist in the dashboard with the name Param01 but the Bound parameter that this has will be set dynamically, that is at run time. And that this assignment will vary based on user and session (based on other selections that the user has made).
I am trying to set up a dashboard that will render user input forms and dashboards. The Forms will use have user selections that can be set at run time. I am not aware of any way to dynamically add components to a dashboard at run time that will just impact the current session. So, my ideas is to have some place holder parameters and to assign these to parameters at run time. For the parameter to be available in the dashboard I need the supplied parameter to be set (unless there is a different option. )
JackLacavaOneStream Employee
OneStream Employee
Pplant wrote:
I am not aware of any way to dynamically add components to a dashboard at run time
Embedded Dashboards components have a property Embedded Dashboard, which can be set to a Parameter. You can then manipulate that parameter in various ways (including the one Henning mentioned) to specify the name of a different Dashboard to embed, hence loading different controls if required. You will have to refresh or reload the dashboard embedding that component, after the parameter is changed, in order to trigger redrawing of the Embedded Dashboard.
Note that you can create your own Embedded Dashboard component like any other Component, you are not limited to the ones that get created when you create Dashboards.
- Pplant
Hi Jack. Yes, you are correct. But I think that I was a little unclear. I really meant to dynamically add a new component at run-time, such as adding a new supplied parameter to a dashboard, or a new button. I do not mean making a component visible or referring to an already existing component such as a dashboard.
I've done adding a component dynamically. However, the problem is with the Dashboard cache, I couldn't find a way to refresh the cache other than restarting IIS. However, that cannot be used as a solution.
- Pplant
Yes, that sounds like a problem. Was the component added only for a specific session or was this added for all users?
Out of curiosity, how did you add the component? was this by updating the Dashboard* tables or could you do this via the api?
- JackLacava
I'm sure you can get clever with Parameters so that you don't need new Supplied ones (which, tbh, are kinda redundant). A Literal parameter, for example, could contain a list of key-values to parse with NameValuePair, or even a JSON structure, that you can then unpack via XFBR where required.
Adding new Components, yeah, i'm not aware of ways to do that; the main technique is to have everything you might need ready on hidden dashboards, and display (or pop-up) them as necessary. If you think you might want to do something like generating a long list of elements with controls attached (e.g. a button for each member), you can either drop their names in a Combobox/Listbox instead, or use a CubeView and use Bound Parameters (in Navigation Links) to automatically create and populate the params you need.
Maybe if you attach some sort of screenshot or layout to explain what you want to achieve more in detail, we might be able to suggest something more specific.
