Forum Discussion

alex's avatar
alex
New Contributor II
2 years ago

No parent members appearing in FilterMembers data buffer?

Hi, I'm trying to pull in the descendants and the parent member of an account into a data buffer. e.g. something of the form FilterMembers(A#All, A#Gross_Sales.DescendantsInclusive). When I log the d...
  • JackLacava's avatar
    2 years ago

    A databuffer only contains records that can be saved back to the database; which by default means that it will contain, for non-dataunit dimensions, only base data.

    If you are trying to get parent data for non-DU dimensions, you must target the parent itself; OneStream will perform the necessary dynamic rollups, then replace the reference to the member with XFCommon, which means they can be stored back against some other member later.

    Other techniques to get parent data involve using GetDataCell or GetEntityAggregationDataCell, which will produce the necessary rollups in memory.

    I would recommend reading the OneStream Financial Rules and Calculations Handbook, which explains the inner workings of databuffers in detail.