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

fc's avatar
fc
Contributor
1 year ago

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...
Workflow
fc's avatar
fc
Contributor
1 year ago

Thanks for the answer

Is this the only way to do it? We would like to ask the client to perform the least number of actions possible, so ideally we would like to automate this action. But if there is no other way we'll certainly do that

Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
1 year ago

Well, as always, there are many ways to Rome. You could also set up a Clear Data Data Management step and assign this to a Process step in the workflow or trigger it in a different way.

Or you can clear the stage data, retransform and load 'nothing'.

Depending on the requirements, the latter might be better as it is more pointed and does not clear out all data on O#Import in a given data unit.

 

 

Make sure you document everything for your client. (Fully) Automating this bares the risk of users not knowing what is happening to their data when clear, reload, ... processes are running in the background without the users specifically and knowingly triggering any of that.