ContributionsMost RecentMost LikesSolutionsRe: SQL in BR gets syntax errors, but runs from Data Adapter So then I could still insert variables and be done with it? "SELECT crpdta.F0902.GBLT, crpdta.F0902.GBCO, crpdta.F0902.GBSBL, crpdta.F0902.GBOBJ, crpdta.F0902.GBSUB, crpdta.F0902.GBMCU, ...Re: SQL in BR gets syntax errors, but runs from Data Adapter I just figured out the answer to my own question, as you were typing your response. Thank you for responding. As it so happens, you cannot have any spaces at the end of a line when calling the SQL ...SQL in BR gets syntax errors, but runs from Data Adapter Has anybody seen this error? If so, how did you fix it? I can run the SQL query in question from a Data Adapter just fine, but when trying to run it from a BR I get the above error. At this ...SolvedRe: Importing from QAD Ledger FYI, we were finally able to get the ODBC connection stable. It wasn't a OneStream issue and we are able to use a database connection thankfully. Re: Importing from QAD Ledger We are trying to use a database connection, but the ODBC connection keeps randomly disonnecting. CAN you use a database connection to QAD? We are hoping to use a database connection and SQL to pull...Importing from QAD Ledger Has anybody been able to create a database connection to the QAD ledger system to import data to OneStream? We are having a nasty time getting SQL to pull from it. SolvedRe: composite mapping rule by period MarcusH, This looks like a great solution. I'm in the same boat, except I don't have any dimensions that are not being mapped. Any suggestions? Re: Load to Multiple Scenarios? Thanks! I will read up on this. It sounds interesting and may very well do the trick. And perhaps I'm going about this the wrong way. What I'm trying to do is "extend" Actuals. In other words, i...Load to Multiple Scenarios? Is there a way to load to multiple scenarios from one Workflow? Example, from the below Workflow POV, I want to load to the Actual_PP scenario, but also to the Forecast_PP scenario. I ...Re: Populating Future period in a Cube View [deleted]