Hi, I am working on an Import/Validate/Load step and built a Connector which gets data from an Application table and a Data source which use the said connector.The connector/Data source seem to work in the sense that that gets pulled in during the im...
Hello all,I am looking to spread budget data across 12 months evenly, however my source is only designated one time.I am looking to split time into all twelve months of the year and divide the amounts accordingly. Is this possible?
Hey all - I'm wondering if anyone has brought in people data (salary/bonus/commission/job type/job title/hire and termination dates/etc. and weekly/biweekly payroll files) into OneStream from Workday. From what I have heard, the payroll and salary da...
With SQL Connector as Data Source, can we automate to Import, Validate and Load multi period and multiyear data (Ex: Jan 2023 till Jan 2026) in such a way the Import, Validate and Load occurs one period after the other sequentially?Query execution ti...
I am setting up a Workflow with a SQL connector data source. I need to be able select a range of periods (start and end period) within the SQL query to extract the balances for multiple periods and load the same to OS cube. Users should have a provis...
