Writing to the Cube using Confirmation Rule?

Ok, I did some test and it works, but it throws an error message and prevents the confirmation rule from succeeding:

But you can catch the error using the try keyword, here is the code I used for the test:

Try
	Dim oneMemberSriptAndValue As New MemberScriptAndValue("Houston", "Cb#GolfStream:E#[South Houston]:C#Local:S#Actual:T#2022M3:V#YTD:A#Headcount:F#NewHires:O#Forms:I#None:U1#MatMgt:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None", 99999, False, "")
	Dim MemberScriptAndValueList As New List(Of MemberScriptAndValue)
	MemberScriptAndValueList.Add(oneMemberSriptAndValue)
	brapi.finance.Data.SetDataCellsUsingMemberScript(si, MemberScriptAndValueList)
Catch ex As Exception
	'Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try

args.ConfirmationRuleArgs.DisplayValue = api.Data.GetDataCell("A#Headcount:U1#MFG:U2#Top:U3#Top:U4#Top:O#Top").cellAmount

If args.ConfirmationRuleArgs.DisplayValue = 0 Then
     Return False
Else
     Return True
End If

Hope this helps