Forum Discussion

jaideepk26's avatar
jaideepk26
New Contributor
4 months ago

GetDataBufferUsingFormula

Can someone check if there's any mistake in the below 2 lines. I am unable to execute the BR
 
 
Dim sourceBuff As DataBuffer
Dim srcED As String = args.CustomCalculateArgs.NameValuePairs("sourceEffectiveDate")
Dim selectedScenario = args.CustomCalculateArgs.NameValuePairs("selectedScenario")
Dim dmTime = api.Pov.Time.Name
Dim account = args.CustomCalculateArgs.NameValuePairs("account")
 
sourceBuff = api.Data.GetDataBufferUsingFormula($"FilterMembers(T#{dmTime}:S#{selectedScenario}:U4#Approved_Status:U6#Total_Audit:U7#{srcED}, [A#{account}.Base])") 

 

Admin
Finance
Parsing
System
XFBR

2 Replies

  • Gert_vanderBijl's avatar
    Gert_vanderBijl
    Icon for OneStream Employee rankOneStream Employee
    3 months ago

    Hi, could it be that you forgot to define the type, meaning:
    Dim dmTime As String = api.Pov.Tme.Name
    Dim account As String =  args.CustomCalculateArgs.NameValuePairs("account")