Forum Discussion

TyeshaAdams's avatar
TyeshaAdams
New Contributor III
6 months ago
Solved

Workflow Import - Clearing cube data in v9

Hello, we recently upgraded to v9 and noticed that we can no longer clear WF imported cube data using the "Clear" option through the workflow import (snip below).  Prior to the upgrade, we could clea...
Import
Workflow
  • StevenFinkell's avatar
    StevenFinkell
    6 months ago

    Hi,

    The clear button in the past only cleared stage data and did not clear the cube data. Only when loading a new file did the load process clear the data unit from the previous file if that same data unit exists on the new file. You can also clear all imported data by right clicking on the period in which you want to clear and select the "clear all 'import' data from cube" selection. 

    That being said, I would look at that processing log to see why you are getting the error you are receiving when reloading a file as it seems to be an issue with the file and not the clear itself. Hope this helps. 

     

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
5 months ago

It's not beyond the realm of possibilities that something in the v9 Stage changes might have modified an old behaviour, so if you're certain that a specific set of actions worked fine in 8 and does not in 9, you might want to validate it with Support.

This said, i agree that there are better ways to clear data, like the one shown by StevenFinkell​ .

Jasper's avatar
Jasper
New Contributor III
2 months ago

JackLacava​ What would the recommend way to clear data loaded through óne specific import child?

StevenFinkell​ 's approach clear's the imports of a whole base input, i.e. all import children in the base input. That's sometimes too broad a brush.

I only know the "clear stage, then transform & load the empty stage" approach, which may now not work anymore. It also has other downsides (e.g. errors when processing/confirming only "loaded entities" and stage is empty). So I'm very curious about the OneStream recommended method!