OneStream Community

Tom

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

Tom

I tested the following SQL in a data adapter, accessing a external table Select * FROM Table WHERE "Cost Center" = 'CC_11111111' ; Data returned here, data adapter worked fine. I am using a Business Rule, and can’t seem to get the BR to work if there...

Tom

Krishna, it worked, I don't understand the syntax '" & Date & "' Thanks so much for your help, I really appreciate it. Tom

Tom

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

Thanks Krisna, I was thinking of creating a parameter like "As of Date", and not a workflow parameter, and then bringing in my parameter into the SQL, right now SQL does not recognize the Parameter.

Tom

We are on version 6.8 and upgrading soon to 7.4

Tom

Snowflake DB, and here is the error I"m getting when running. Error processing Data Management Step 'Load_FDH_Employee_GL_Actuals'. Unable to execute Business Rule 'FDH_To_OS_Refresh'. ERROR [42000] SQL compilation error:syntax error line 1 at positi...

OneStream Community

User Statistics

User Activity

Parameter for SQL

SQL Query to External Table

Re: Parameter for SQL

Re: Parameter for SQL

Re: Parameter for SQL

Re: SQL Query to External Table

Re: SQL Query to External Table