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.
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.
