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
Solved
Data Table that retains a Member's Aggregation Weight?
Hi,
I'm trying to build a dashboard that reviews all of the members in certain dimensions and ensures it has all of the members rolling up to the top properly. To do this, I'm trying to find the table in the back end of OneStream to find the Aggregation Weight.
Does anyone know where that table is retained?
Thanks,
Ben
Hi,
It is in "Relationship" table. UDAggWeight column
Hope it helps
Liliya
4 Replies
Hi,
It is in "Relationship" table. UDAggWeight column
Hope it helps
Liliya
Hi Lilly!
This is perfect, thank you! What about in the "Entity" Dimension for the "Is Consolidated" Dimension? Do you know where that field is held?
Also, is there a list or database of these things you learned from?
It is in MemberProperty table. Please see this community post for the codes: Member PropertyID Data Dictionary | OneStream Community.
There is some warnings there regrading using these values
- JackLacava
OneStream Employee
If you think this should be easier, go vote on Display Aggregation Weight in Cube View | OneStream Community š
