Skip to main content
B
brookb
January 18, 2023
Solved

Unselect/Uncheck combo box selections

  • January 18, 2023
  • 2 replies
  • 0 views

Is there a setting on the component or even a business rule that allows you to uncheck/unselect/reset a combo box to its original state? I would like it to reset and check the top member or a default member. I don't want all parameters on my dashboard reset just a specific combo box with the click of a button.

Best answer by Ashok

yes, you can reset or set to specific value using Dashbaord Extender BR. see "RPTA_SolutionHelper" for examples. something like below:

'*********************************************************************************************************************************************
' PARAMETER COMPONENT SELECTION CHANGED EVENT HANDLERS
'*********************************************************************************************************************************************
Case Is = DashboardExtenderFunctionType.ComponentSelectionChanged

 

If (args.FunctionName.XFEqualsIgnoreCase("ValidateDatesForRefresh")) Then


Dim taskResult As New XFSelectionChangedTaskResult

taskResult.ModifiedCustomSubstVars.Add("DashboardToHide_RPTA", "9_NoFilterSelected_RPTAV")

taskResult.ModifiedCustomSubstVars.Add("ReportLabelHeight_RPTA", "*")
taskResult.ModifiedCustomSubstVars.Add("FilterLabelHeight_RPTA", "0")

taskResult.ChangeCustomSubstVarsInDashboard = True
Return taskResult

2 replies

A
AshokAnswer
January 18, 2023

yes, you can reset or set to specific value using Dashbaord Extender BR. see "RPTA_SolutionHelper" for examples. something like below:

'*********************************************************************************************************************************************
' PARAMETER COMPONENT SELECTION CHANGED EVENT HANDLERS
'*********************************************************************************************************************************************
Case Is = DashboardExtenderFunctionType.ComponentSelectionChanged

 

If (args.FunctionName.XFEqualsIgnoreCase("ValidateDatesForRefresh")) Then


Dim taskResult As New XFSelectionChangedTaskResult

taskResult.ModifiedCustomSubstVars.Add("DashboardToHide_RPTA", "9_NoFilterSelected_RPTAV")

taskResult.ModifiedCustomSubstVars.Add("ReportLabelHeight_RPTA", "*")
taskResult.ModifiedCustomSubstVars.Add("FilterLabelHeight_RPTA", "0")

taskResult.ChangeCustomSubstVarsInDashboard = True
Return taskResult

K
Krishna
April 5, 2023

Are you sure this is working ? I am not able to get it working. Can you share more details. I followed the same but it is not working.

G
Gidon_Albert
September 9, 2023

So if I understnad this right, in :

 

 

taskResult.ModifiedCustomSubstVars.Add("DashboardToHide_RPTA", "9_NoFilterSelected_RPTAV")

 

 

=> DashboardToHide_RPTA is the paramter

=> "9_NoFilterSelected_RPTAV" is the value we assign to this parameter

And by using setting :

 

 

taskResult.ChangeCustomSubstVarsInDashboard = True

 

 

OneStream will use "9_NoFilterSelected_RPTAV" when |!DashboardToHide_RPTA!| is referenced. Is this correct?

Is there a way to get the value assigned to |!DashboardToHide_RPTA !| in the previous run of the current dashboard to avoid another value from another user from being used by the current user?

 

Terms & ConditionsAccessibility statement