The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Issue with multiple data load steps at year end
Hi everyone, My client loads data through a classing import step throughout all the months of the year. In addition to that, they asked to set up 3 additional import steps (P13, P14, P15) to be used...
Henning
OneStream Employee
OneStream EmployeeHi, as you are loading data via the workflow, the data uses the concept of the Level 2 Workflow Data Unit.
https://documentation.onestream.com/1385607/Content/Design%20and%20Reference/Workflow%20Guides/Data%20Units.html?Highlight=data%20unit
"The workflow data unit is the default level used by the workflow engine to control, load, clear, and lock data. Workflow level data loads from the staging data mart to the cube, and is cleared and locked at a granularity level that includes the account dimension by default."
Because you are mapping data to different accounts, the previous loads to accounts that hold (previous) data but are not mapped to anymore as part of the following load (e.g. P13), the data is not cleared and remains.
Make sure to clear and complete the previous load step to clear all data from the corresponding load.