Forum Discussion

vijay's avatar
vijay
New Contributor III
3 years ago

Multiple cell values in Databuffer same intersection

hi ,   Am getting mutiple values from the databuffer for the same intersection. Database has  Status1 ,Value1  then up to ...Status 12 ,Value 12...  I beleive that only the Staus 12 and Value 12 co...
Finance
EricOsmanski's avatar
EricOsmanski
Icon for OneStream Employee rankOneStream Employee
3 years ago

In a monthly scenario, Value 1-12 represents the months. Value 1 would be M1, Value2 is M2, and so on. In order to only pull Value 12, you would need to specify a time period in your Data Buffer. An example of this would be "T#" & api.Time.GetYearFromId(api.Pov.Time.MemberId) & "M12", but there are multiple ways to do so.