Forum Discussion

TyeshaAdams's avatar
TyeshaAdams
New Contributor III
2 days ago

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 clear the stage data, then run import/validate/load to clear the data that was imported to the cube.  Now, this option only clears the data from stage and in order to clear the data loaded to the cube, we have to use a data management step.  In our case, this is now difficult because the data loaded may be specific to workflow channels and also use multiple dimension criteria and not just Entity (used by DM step).  Is anyone else having this issue?  Are there any other methods to removing the imported data via csv file from the cube other than a DM step?

 

If we try to run the old process in v9.  Clear, then Retransform, Load to clear cube data.  This error appears.

 

Import
Workflow

2 Replies

  • StevenFinkell's avatar
    StevenFinkell
    New Contributor II
    2 days 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. 

     

  • SimonHesford's avatar
    SimonHesford
    Contributor II
    14 hours ago

    The issue is with the data in the file you are importing i.e. following transformation there are no valid data lines to load to the cube. You have to have a least one valid line of data. As you were clearing the cube I suspect you were loading a zero amount data line so you need to make sure that you are not suppressing zeros (the default behaviour for OneStream imports) . In any case Steven has highlighted a better process/method for performing the clear manually from the workflow so you should probably move to using that