The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

marcobobbiesi's avatar
marcobobbiesi
New Contributor III
2 years ago

IsValid Destination / IsDesinationWithin the constrain / DataBuffer Log for errors

Hi guys we frequently work with data buffer (or sometimes even with setcell) and there's a problem for which I coudn't find a solution. E.g. we have an allocation setting the values to certain inter...
Finance
ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
2 years ago

I wasn't investigating it, but did you try:

Dim myCell As DataBufferCell
myCell.CellStatus.Invalid

 

marcobobbiesi's avatar
marcobobbiesi
New Contributor III
2 years ago

Hi Christian,

thank you for the hint... but apparently this does not work.

'Here I define a target cell, replacing the soure account with the plug, where the target flow is not valid. Then I used CellStatus.Invalid to determine the whether the target cell is valid (which is not).

Dim targetcell As New DataBufferCell(cell)
targetcell.SetAccount(api, PlugAcc)
api.LogMessage(" OK1 invalid " & cell.CellStatus.Invalid & " " & cell.DataBufferCellPk.GetMemberScript(api) )
api.LogMessage(" Ko1 invalid " & targetcell.CellStatus.Invalid & " " & targetcell.DataBufferCellPk.GetMemberScript(api) )

'This is what OS prints, both seem to be valid (Invalid = FALSE)
OK1 invalid False A#23411021:F#F015:O#Import:I#VAAG:U1#GBBAHNOTHER:U2#Package:U3#AUT:....
Ko1 invalid False A#21558311:F#F015:O#Import:I#VAAG:U1#GBBAHNOTHER:U2#Package:U3#AUT ....


'But if I actually check wether the flow is within the contraint, OS correctly highlights it's not. Of course, doing something like that for all dimension would not be very efficient, considering that i want to log this during a consolidation / allocation process

Dim tCellFlowValid As Boolean = api.Account.IsFlowICOrUDMemberWithinConstraintMember(targetcell.DataBufferCellPk.AccountId, BRApi.Finance.Dim.GetDimPk(si, "cFlow"), targetcell.DataBufferCellPk.FlowId )
Dim sCellFlowValid As Boolean = api.Account.IsFlowICOrUDMemberWithinConstraintMember(cell.DataBufferCellPk.AccountId, BRApi.Finance.Dim.GetDimPk(si, "cFlow"), cell.DataBufferCellPk.FlowId )
api.LogMessage("Flow Valid Source: " & sCellFlowValid & " FlowValid Dest: " & tCellFlowValid)

'PRINTED:
Flow Valid Source: True FlowValid Dest: False


Do you believe I did something wrong or this "Cellstatus.invalid" thing is meant for something else?