OneStream Community

Tom · 06-03-2024

Hi Everyone, These tables house information about the Environment tables, and also the Application Tables. It would be ideal to have not only know information on the fileds in these 2 tables mainly are the fields in GB or Tera Byte, but also the best...

Tom · 04-19-2024

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 · 04-18-2024

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 · 04-19-2024

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

Tom · 04-19-2024

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 · 04-19-2024

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 · 04-18-2024

We are on version 6.8 and upgrading soon to 7.4

Tom · 04-18-2024

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

Information for the table fields XFW_OSD_Envtablesizes, XFW_OSD_Apptablesizes

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