ContributionsMost RecentMost LikesSolutionsRe: 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] Re: Populating Future period in a Cube View Yes, we push the People Planning data into the cube. We do not have a forecast scenario that we use for People Planning. We just have actual. Our finance users want to see the Actuals "extended" t...Populating Future period in a Cube View Hello, I'm trying to create a cube view that grabs actuals from People Planning and populates the future periods with the latest month of actuals. e.g. in M3, M1=M1 Actuals, M2=M2 Actuals, M3=M3 Ac...Re: Converting Historical Data Hello, TheJogG, This is both a long overdue thank you for your response and a request for clarification. In your last paragraph, are you suggesting that we load the old data, remapped to the new c...
