Clear data using level 1 data unit (rather than level 2) on data load

Question

Hi all
I was wondering if it is possible to override the default 'clear and load' settings on a data load step from 'Level 2: Workflow Data Unit' to 'Level 1: Cube Data Unit'

Just to give a bit of context:
We perform a data copy from a Budget scenario (using Data Management Sequence) to a Forecast scenario to provide a starting data position for divisions to use when they capture their forecast data.Once the data copy is complete, the process for divisions to update their forecasts is to extract an Excel Fixed File Template on which they will make their changes and additions over the copied Budget data, and then to import that file via their Workflow to the cube.&nbsp;However, when wanting to remove an account for instance, the only way to do so it to load zeros to that account. This is because the load clears by account and not entity. Is it possible to change the load so that it deletes all accounts?
Thanks,
Mark

MarcusH · Answer

The users can clear the data from the cube before loading. See here for more info:
https://community.onestreamsoftware.com/t5/Application-Build/Clear-All-Import-Forms-Data-from-Cube/m-p/14947
If you don't want the users to do that I would guess that you could use a Workflow EventHandler on the ClearAllInputDataFromCube event (write a script to clear all data from Level1 in the After event?). See this excellent blog post for more info:&nbsp;
https://community.onestreamsoftware.com/t5/ONECommunity-Blog/Unleashing-the-Power-of-OneStream-Event-Handlers-Enhancing-User/ba-p/23695

MarkBird · Answer

MarcusH&nbsp;thanks for this,&nbsp; I think it is exactly what we need!
It's not quite as simple as the first option 'Clear All Import/Forms Data from Cube' because we have got seeded data in the scenario that we don't want to clear out.
But I'll look into the workflow event handler query and get back to you.

Krishna · Answer

MarkBird&nbsp; - You can WF event Handler, or you can also use the finance business rule before copying the data into the Forecast.&nbsp;

Forum Discussion

Clear data using level 1 data unit (rather than level 2) on data load

Related Content

Using cube description rather than cube name

Question: Client wants to be able to input parent entity adjustments using forms rather than journals.

FilterMembers using Cb#Cube

Executing DM Step using RESTAPI

Import data using multiple workflow profles