Solved

Data Table that retains a Member's Aggregation Weight?

Forum|Forum|1 year ago
June 14, 2025
2 replies
0 views

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

Metadata

Best answer by LiliyaBarabash

Hi,

It is in "Relationship" table. UDAggWeight column

Hope it helps

Liliya

LiliyaBarabashAnswer

Hi,

It is in "Relationship" table. UDAggWeight column

Hope it helps

Liliya

matthewsb419Author

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

If you think this should be easier, go vote on Display Aggregation Weight in Cube View | OneStream Community 😁