Clear data from Workflow import

Forum|Forum|4 years ago
March 14, 2022
10 replies
1 view

Hey everyone -

How do I clear data from these workflow manual imports automatically?

Right now, I've been going through each month one by one. Wondering if there is a BR that can run them all together and clear up data from those specific imports and time dimension.

Here are the steps I want to follow:

Navigate to import that needs to be cleared > Clear > Re-Transform > Validate > Load Cube

C

ckattookaran

You can create an Extender rule that mimics a load using the following.

Dim impProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wfCurrentClusterPk, "filename or dm name", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromFileUpload, True)

You can change the loadmethodtypes to do replaces. I've not tried that with a blank file though.

W

WHERE1equals1Author

Hi ckattookaran

I'm not intending to load a blank file. I want the WF to "Clear" data by itself, and run the validation-load steps period by period.

Last night, I figured out a different solution and it works. It's mainly defining the workflow (using as WFUnitClusterPk) and using brapi.import.process to execute the various steps (Clear Data, Retransform, Validate, Load).