Unable to clear stage data

STDN
New Contributor III

Hi All,

 

I am unable to clear the staging data even after doing " Clear" from import and "Clear all imported data from Cube" by giving right click on the period, Can anyone suggest how to clear that?

 

 

Thanks in Advance

7 REPLIES 7

Steven
Contributor II

Is this because your workflow is completed?

You may need to revert the workflow (get rid of the green checkbox) to clear your stage data.

Can you show a screenshot?

LisaS
New Contributor III

I'm having the same issue. I working on importing some of our historical information and we'd previously imported data through a connector that I need to clear out. At that import step, I hit the clear on the Import step and there is no data shown there anymore but when I run reports etc. the data is still there on O#Import like clearing the import didn't do anything.

LisaS_0-1693340265504.png

 

Steven
Contributor II

That "X Clear" button clears the data out of the stage table; not out of the cube.  To clear the data from the cube, you need to click the parent workflow, then right click the parent workflow and select "Clear all Import Data from the cube"

Steven_0-1693408796555.png

 

LisaS
New Contributor III

That clears the imports from the workflow but the previously loaded data is still in the cube.

Steven
Contributor II

how did you load the "previously loaded data" into the cube?

CMBPM
New Contributor II

Hi STDN, 

I hope you have found an answer by now but a work around for this is to Clear like did then go through the workflow steps without re-loading. So this would be selecting "Retransform", "Validate", "Load to Cube" (depending on steps). This will essentially load nothing to the cube. You can then go back and Load and Transform from step 1.

Other options are to run Data Management for a "Clear Data". If you wanted to just clear import, you can make the Forms and Adjustments False in the Data Management settings.

CMBPM_0-1694699388552.png

-Colin

 

Hugo_Jimenez
New Contributor

Hi colin,

If I need clear data import to the specific group of Account, what is the best option ?, I try using the formula set data 0 and the clearcalulate data but that process is very slowly and the datamanagement is very fast but clear all data import and i need clear an specifict group of account