01-17-2023
11:53 PM
- last edited on
05-02-2023
10:31 AM
by
JackLacava
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.
Solved! Go to Solution.
01-18-2023 04:29 PM
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
01-18-2023 04:29 PM
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
04-05-2023 03:14 PM
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.
04-05-2023 08:38 PM
I answered my own question. I was passing the incorrect parameters. Param Name Vs ComboBox Name. Thanks.
3 weeks ago - last edited 3 weeks ago
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?