Forum Discussion

MarkBird's avatar
MarkBird
Contributor III
2 years ago

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

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 ...
Data Management
Data Sources
Import
Workflow
MarcusH's avatar
MarcusH
Valued Contributor
2 years ago

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: 

https://community.onestreamsoftware.com/t5/ONECommunity-Blog/Unleashing-the-Power-of-OneStream-Event-Handlers-Enhancing-User/ba-p/23695