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
Solved
Get selected value from Combo Box and use it in a Table View
I have a dashboard that has 2 components,.
1. A Combo Box that is populated with a sql query in a Bound List Parameter.
2. A Spreadsheet that is populated with a Table View. The table view is g...
Thank you for the response.
I wasn't ablet to get BRApi.Dashboards.Parameters.GetLiteralParameterValue to pickup the parameter from the Combo Box.
However I used args.CustSubstVarsAlreadyResolved("parameterNameHere") and assigned that to a string variable. That did work. It got the parameter value from the combo box.
Thank you for the response.
I wasn't ablet to get BRApi.Dashboards.Parameters.GetLiteralParameterValue to pickup the parameter from the Combo Box.
However I used args.CustSubstVarsAlreadyResolved("parameterNameHere") and assigned that to a string variable. That did work. It got the parameter value from the combo box.
Could you please provide the sample BR ? for the parameter from ComboBox ?
p_Select_Year is the Parameter.
There was a larger issue at play here, I first set this up on a 6.8x version and it wasn't working (The table view in a dashboard wasn't picking up the selection from the combo box) then I tried it on a 7x version and it worked.
Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As SpreadsheetArgs) As Object
Try
Select Case args.FunctionType
' Case Is = SpreadsheetFunctionType.Unknown
Case Is = SpreadsheetFunctionType.GetCustomSubstVarsInUse
If args.TableViewName.XFEqualsIgnoreCase("UserLogonActivity")
Dim paramList As New List(Of String)
paramList.Add("p_Select_Year")
Return paramList
End If
Case Is = SpreadsheetFunctionType.GetTableView
If args.TableViewName.XFEqualsIgnoreCase("UserLogonActivity")
Dim currentYear As String = args.CustSubstVarsAlreadyResolved("p_Select_Year")
Return GetUserLogonActivity(Si,currentYear)
End If
' Case Is = SpreadsheetFunctionType.SaveTableView
End SelectReturn Nothing
Catch ex As Exception
Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try
End Function