Forum Discussion

grillin7's avatar
grillin7
New Contributor II
2 years ago

get data value from BRApi.Finance.Data.GetDataCellUsingMemberScript

Hi, I'm trying to get the amount of an objDataCellInfoUsingMemberScript but I couldn't get the data, I'm trying this: objDataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScri...
XFBR
  • JackLacava's avatar
    JackLacava
    2 years ago

    Not sure what you're trying to do with that string roundtrip. This should work:

    Dim myCell As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, _
    "myCube", _
    "S#MyScenario:E#MyEntity: ... etc etc") 
Dim myValue as Decimal = myCell.DataCellEx.DataCell.CellAmount

    Generally speaking, it's safer to work with Decimal values than Doubles, as they are less prone to "surprises" when rounding. If you have to drop it into a formula, there are a number of approaches, this is the one I like:

    api.Data.FormulaVariables.SetDecimalVariable("myFixedAmount", myValue)
api.Data.Calculate("A#Target = A#Source * $myFixedAmount")

     

JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

Not sure what you're trying to do with that string roundtrip. This should work:

Dim myCell As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si, _
    "myCube", _
    "S#MyScenario:E#MyEntity: ... etc etc") 
Dim myValue as Decimal = myCell.DataCellEx.DataCell.CellAmount

Generally speaking, it's safer to work with Decimal values than Doubles, as they are less prone to "surprises" when rounding. If you have to drop it into a formula, there are a number of approaches, this is the one I like:

api.Data.FormulaVariables.SetDecimalVariable("myFixedAmount", myValue)
api.Data.Calculate("A#Target = A#Source * $myFixedAmount")

 

  • kberry's avatar
    kberry
    New Contributor III
    2 years ago

    The Member Script Builder is also handy in these cases. Here is an example from the Design & Reference Guide:

    Dim MemberscriptBldr = New MemberscriptBuilder("V#YTD:A#Cash")
MemberscriptBldr.SetFlow("None").SetOrigin("Import").SetIC("None").SetAllUDsToNone()
Dim Memberscript As String = MemberscriptBldr.GetMemberscript()
Dim objDataCell As DataCell = api.Data.GetDataCell(Memberscript)
  • grillin7's avatar
    grillin7
    New Contributor II
    2 years ago

    Hello sir,

    Thank you a lot.

    that solution works.

    I think the problem was with the double variable, I put decimal and it works perfectly, thank you.

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    Hi Jack - I have a quick question. Can I do something like below ?

     

     

    Dim Cbe As String = "Base"
								Dim Msct As String = "E#1:C#Local:S#Actual:T#2023M6:V#YTD:A#1025000:F#Check_Movement:O#Top:I#Top:U1#PC_Root:U2#Dept_Root:U3#LOB_Root:U4#Prod_Root:U5#None:U6#None:U7#Source:U8#None + E#1:C#Local:S#Actual:T#2023M6:V#YTD:A#1025000:F#Check_Movement:O#Top:I#Top:U1#PC_Root:U2#Dept_Root:U3#LOB_Root:U4#Prod_Root:U5#None:U6#None:U7#CVC:U8#None + E#1:C#Local:S#Actual:T#2023M6:V#YTD:A#1025000:F#Check_Movement:O#Top:I#Top:U1#PC_Root:U2#Dept_Root:U3#LOB_Root:U4#Prod_Root:U5#None:U6#None:U7#Acq:U8#None"
								
								Dim myCell As DataCellInfoUsingMemberScript = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,Cbe,Msct)
Dim myValue As Decimal = myCell.DataCellEx.DataCell.CellAmount

     

     It is not working and returning 0 

    • JackLacava's avatar
      JackLacava
      Honored Contributor
      2 years ago

      "Member Script" is a set of coordinates to a single cell. What you're trying to do is actually evaluating a GetDataCell formula. Just use api.Data.GetDataCell for that, and it should work.

      • Krishna's avatar
        Krishna
        Valued Contributor
        2 years ago

        Thanks Jack. I am doing this in extender business as part of Form Event to check the cell status  rule not in Finance,