Parameter for SQL

Question

When I have a BR, and need to pull in a parameter, I use the following statement or one similar, I create the parameter in a Dashboard.
'Dim scenario As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, "Forecast_Scenario")
How do you bring a parameter into SQL ?  I tried the above and it doesn't work.  I would like to set a parameter such as date, and then bring the parameter inside SQL, the same way I do as a BR.
Thanks for your help in advance.
Tom

Krishna · Accepted Answer

I currently have the value hardcoded in the SQL, but wanted to create a parameter if possible. Thanks for your help, I really appreciate it.

Tom - Assume the below is the parameter in the BR

Dim Date As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(si, False, ParamName)
In the SQL You will be calling the String
WHERE SQL COL NAME = '" & Date & "'"

The ParamName is created in the Dashboard Parameter.

Hope this helps!

Krishna · Answer

Tom - See below in Parameters This is a connector rule example. WHen you are calling SQL inside the BR.' Dim wfYear As String = periodName.Substring(0,4)' Dim wfMonth As String = periodName.Substring(5) 'Where Clause whereClause.Append("WHERE YEAR = '" & wfYear & "'") whereClause.Append("AND PERIOD ='" & wfMonth & "'" )

Sign up

Login with SSO

Login to the OneStream Community

Login with SSO