Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
4 years ago

Writing to the Cube using Confirmation Rule?

Originally posted by James Kirkby Hello: I want to have a confirmation rule write a value to a single intersection (api.data.calculate) by either calling a finance business rule or writing the ca...
Confirmation Rules
ChristianW's avatar
ChristianW
Valued Contributor
4 years ago

Did your consultants try to use:

 

Dim dataCellExs as new list(of DataCellEx)
...
brapi.finance.Data.SetDataCellsUsingMemberScript(si, MemberScriptAndValueList)

 

This simulates a manual input, you can only write to o#forms (not to o#import).

ChristianW's avatar
ChristianW
Valued Contributor
4 years ago

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