Forum Discussion

MarkBird's avatar
MarkBird
Contributor III
8 months 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
Contributor III

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

MarkBird's avatar
MarkBird
Contributor III
8 months ago

MarcusH thanks for this,  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.