Skip to main content
Member
Feb 27, 2026 7:14 AM UTC
Question

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])") 

 

2 replies

Expert
Mar 3, 2026 2:39 PM UTC

Syntax looks OK - what's the error?

Gert_vanderBijl
OneStream Employee
OneStream Employee
Mar 11, 2026 11:02 AM UTC

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")