Forum Discussion

fc's avatar
fc
New Contributor III
2 years ago

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!

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    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?

     

  • fc's avatar
    fc
    New Contributor III
    2 years ago

    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.

     

     

    • EricOsmanski's avatar
      EricOsmanski
      Valued Contributor
      2 years ago

      Pass the parameters from the button to the rule:

       

      An alternative way to grab the values passed from button:

       

       

  • fc's avatar
    fc
    New Contributor III
    2 years ago

    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 you

     

    • ckattookaran's avatar
      ckattookaran
      VIP
      2 years ago

      Did 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. 

  • fc's avatar
    fc
    New Contributor III
    2 years ago

    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. 

  • ckattookaran's avatar
    ckattookaran
    VIP
    2 years ago

    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

  • fc's avatar
    fc
    New Contributor III
    2 years ago

    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 mode

    does anyone have any idea?

     

  • ckattookaran's avatar
    ckattookaran
    VIP
    2 years ago

    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.

    • fc's avatar
      fc
      New Contributor III
      2 years ago

      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 dashboard

      In 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 parameters

       

      This 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!