Forum Discussion
Dashboard Extender BR fails to retrieve WF information for Scenario and Period
Hi all,
I'm working on a Dashboard Extender BR where different processes will be triggered depending on the button selected by the user on the dashboard.
The BR is structured this way:
The two parameters shown above (p_scenario and p_yearmonth) retrieve the value for Scenario and Period from the WF.
Every time the user clicks on a different button, two variables are assigned the value of WF Period and WF Scenario as shown above.
The process works fine for all of the dashboard buttons except one. When that one is clicked, the values of WF Period and Scenario are not retrieved. The two variables shown above are left as empty strings.
Any idea what might be causing this?
I'm using the same formula for all of the buttons:
Dim Scenario As String = args.SelectionChangedTaskInfo.CustomSubstVars.XFGetValue("p_scenario")
it works fine on all buttons except that one
Thanks in advance for any help on this!
10 Replies
I would focus on the button that is not working. Through deductive reasoning, if the same code serves multiple buttons and only one button is not functioning correctly, you should be able to rule out the code and focus on what is unique to the button that is failing.
Can you tell more about that particular button?Hi Rob
All the buttons are structured the same:
once clicked, they trigger the execution of the BR and refresh the dashboard.
If that button is clicked, the overall process works fine, but somehow those two dimensions are not retrieved, and therefore the resulting data is wrong.
Even more strange is that only the WF dimensions are not retrieved.
In the dashboard, the user has a dropdown list to choose the desired base Entity, which is then assigned to a variable the same way Period and Scenario are. When that button is clicked, Scenario and Period dimensions are left empty, but Entity is correctly assigned the Entity selected by the user on the dashboard.
EricOsmanskiOneStream Employee
Pass the parameters from the button to the rule:
An alternative way to grab the values passed from button:
I found out what seems to be causing the problem
the main dashboard is composed of two embedded ones. If opened in Design Mode, on the side there is a list of the parameters in use.
If I remove the second embedded dashboard component from the main dashboard, the parameters p_scenario and p_yearmonth (which store the WF values of scenario and period) are also removed from the list.
Hence why when the button is clicked, the BR is not able to retrieve the values for WF scenario and period.
Does anyone know what's the relationship between the embedded dashboard components and the parameters shown in the list? Is there a way to add or remove parameters from there?
Thank youDid you try passing the parameter like Eric was saying? What type of parameters are they, when you say WF parameters, I'm thinking of the substitution variables. They don't seem like using sub vars.
That's correct, both parameters (p_scenario and p_yearmonth) are assigned a sub var (|WFScenario| and |WFTime|).
The issue with Eric's suggestion is (please correct me if I'm wrong) that through the 'Selection Changed Server Task' I can only pass one BR.
At the moment, I'm passing the BR I want to launch when the button is clicked
If I replace this, I won't be able to trigger the BR that should be triggered.
He is not asking you to replace it, he is suggesting you to pass the parameters as {scenario=|!scenario!|}. However, since you are using the substitution variable, you don't even need those parameters. Just use Brapi.Workflowcluster.timekey and scenariokey and use timedimhelper and scenariodimhelper to get the names
ok that solved the issue, thank you all for the help!
Just for my knowledge, I'd still be curious to know if and how it would be possible to modify the list of parameters on the side of a dashboard when opened in design modedoes anyone have any idea?
Design mode lets you edit the dashboard and components and parameters. However, to modify them (I think you mean remove them?) then you need to go to the individual components, and use the "pencil" icon to edit.
I'm sorry I didn't explain my question very well, I'll try to be more clear
From the "backend" section of the dashboard, it's possible to add different components into the dashboardIn this case I added an embedded dahsboard, a button, and a SQL editor.
When I open the dashboard in design mode, on the left I see the different components that were added to the dashboard, plus a list of parametersThis list is not present in the "backend" section, but becomes visible only when the dashboard is launched in design mode.
What is not clear to me is how is this list generated? Is it automatically generated by OS? And is it possible to modify it (add or remove parameters from it)?
Hope my doubt is more clear now
Thanks for the help!
