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

Sweez's avatar
Sweez
Contributor
2 years ago
Solved

DataBuffer Limitations?

Can anyone confirm if a GetDataBuffer function only pulls back real data?  In other words it will not return dynamically calculated data (say from a dynamic account) or derived data?  Trying to understand the limiitation of what data the function will and will not return.  Thanks.   

Finance
  • JackLacava's avatar
    JackLacava
    2 years ago

    Yeah, sorry, I had a brain fart. I was thinking of api.Data.GetDataCell, which will resolve dynamic accounts. GDBF will only contain real data, aggregated dynamically to parent accounts(/flows/origin/etc) if requested.

5 Replies

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    Well, it depends on where you're actually using it and how, but databuffers can indeed contain data from DynamicCalc accounts. More coffee is needed for my brain to operate today.

    • Sweez's avatar
      Sweez
      Contributor
      2 years ago

      Thank Jack for the response.  The context is use in a finance business rule used by a data managment job.  If I create a databuffer (i.e. Dim myDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula) my question is will it contain derived data if it exisits in that databuffer, as well as will it pull back data if a dynamic account is used in the filter.  In my testing I only seem to be able to bring back real data,  

      • JackLacava's avatar
        JackLacava
        Icon for OneStream Employee rankOneStream Employee
        2 years ago

        Yeah, sorry, I had a brain fart. I was thinking of api.Data.GetDataCell, which will resolve dynamic accounts. GDBF will only contain real data, aggregated dynamically to parent accounts(/flows/origin/etc) if requested.

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    Yes @ I agree with Jack.  Here is an example 

     

    If Not srcDataBuffer Is Nothing Then
	
	For Each srccell As DataBufferCell In srcDataBuffer.DataBufferCells.Values
		If srccell.CellAmount <> 0  And srccell.CellStatus.IsRealData Then
			

End If
Next 
End If