Solved
How can I run a sequence before loading data into the cube?
Hi Everyone.
I want to delete the existing data using a BR before loading the new values through Export to Cube. I tried this approach, but the newly loaded data gets deleted.

I also modified my DataQualityEventHandler BR to run before the event, but the newly loaded data still gets deleted.
Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DataQualityEventHandlerArgs) As Object
Try
'Define a switch to control event processing, since many of these are reference examples we do not want them to run all the time
Dim processEvents As Boolean = True
'Set the default return values
Dim returnValue As Object = args.DefaultReturnValue
args.UseReturnValueFromBusinessRule = False
args.Cancel = False
'Evaluate the operation type in order to determine which subroutine to process
Select Case args.OperationName
Case Is = BREventOperationType.DataQuality.ProcessCube.NoCalculate
'Execute a Data Management job after process cube runs for a no calculate step
If args.IsBeforeEvent Then
Me.XFR_HandleProcessCubeNoCalculate(si, globals, api, args)
End If
'Me.XFR_HandleProcessCubeNoCalculate(si, globals, api, args)
End Select
Return returnValue
Catch ex As Exception
Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try
End FunctionI would appreciate it if someone could help me resolve this issue.
