Skip to main content
A
alex
Newcomer
January 19, 2023
Solved

No parent members appearing in FilterMembers data buffer?

  • January 19, 2023
  • 1 reply
  • 0 views

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 data buffer and examine my results, however, I'm only seeing the base member data and none of the parents.

Could anyone provide me any suggestions on how to pull all of this data into a single data buffer? And can anyone tell me why my data buffer doesn't produce the results I'm expecting?

Thanks!

Best answer by JackLacava

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 https://amzn.to/3XtBVU0, which explains the inner workings of databuffers in detail.

1 reply

J
OneStream Employee
JackLacavaOneStream EmployeeAnswer
OneStream Employee
January 19, 2023

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 https://amzn.to/3XtBVU0, which explains the inner workings of databuffers in detail.

    A
    alexAuthor
    Newcomer
    January 20, 2023

    Thanks Jack, your explanation is very helpful. I will consider picking up the Financial Rules & Calculations handbook.

    Terms & ConditionsAccessibility statement