01-18-2023 08:33 PM - last edited on 05-02-2023 10:25 AM by JackLacava
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!
Solved! Go to Solution.
01-19-2023 04:30 AM - edited 01-19-2023 04:55 AM
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.
01-19-2023 04:30 AM - edited 01-19-2023 04:55 AM
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.
01-20-2023 10:39 AM
Thanks Jack, your explanation is very helpful. I will consider picking up the Financial Rules & Calculations handbook.