Workflow Import - Clearing cube data in v9

Question

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.

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

&nbsp;

StevenFinkell · Answer

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.&nbsp;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.&nbsp;&nbsp;

SimonHesford · Answer

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&nbsp;

ASides · Answer

I recently observed the same behavior in a v9.1 application.

When our application was v8.x, a clear (of stage data), retransform, and load cleared data from the cube. In v9.1, I receive the "No valid DataKeys (...)" error on the retransform step.

TyeshaAdams · Answer

Thank you for your response.&nbsp; This is helpful!&nbsp; This will work for us if we need to clear all the workflow channels within a specific workflow but in some cases, we only need to clear one workflow channel.

JackLacava · Answer

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

Forum Discussion

Workflow Import - Clearing cube data in v9

6 Replies

Related Content

Workflow import data overwritten

Import data using multiple workflow profles

Locking one 'import' workflow profile locks all other 'import' workflow profiles of that WF/Period

Workflow Profiles

Clear data from Workflow import