Skip to main content
Contributor
Oct 6, 2026 9:39 PM UTC
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 Function

I would appreciate it if someone could help me resolve this issue.

sameburnAnswer
Employee - Advisor
Oct 7, 2026 4:44 PM UTC

This blog post explains how to do this No Calc To Calc - Black Diamond Advisory

Hope this helps

2 replies

Contributor
Oct 7, 2026 3:15 PM UTC

Just an idea. Feel free to shoot it down. 

Have you thought of orchestrating this via Data Management sequence?  Add the steps to the sequence in the order you prefer. You could create functions so you don’t have to create multiple extender BR’s. Just callout each function in each steps.
 

 

sameburnEmployee - AdvisorAnswer
Employee - Advisor
Oct 7, 2026 4:44 PM UTC

This blog post explains how to do this No Calc To Calc - Black Diamond Advisory

Hope this helps