Same Account Rolling to Different Parents Depending on Entity

Hi everyone,

I’m currently building a OneStream application for a budgeting process and I’m facing a modeling challenge with account aggregation.

The situation is the following:

We have the same source account (for example 600000) across multiple entities. However, depending on the entity, the amount should roll up to different parent accounts in the reporting structure.

Example:

• If Entity A loads Account 600000 = 1000, the amount should roll up to ParentA.
• If Entity B loads Account 600000 = 1000, the amount should roll up to ParentB.

The key requirement is that I would like to keep only one account member (600000) in the Account dimension, without creating multiple target accounts such as 600000_A or 600000_B.

Since the Account hierarchy in OneStream is static, I’m trying to understand what the best design approach would be to handle this type of entity-dependent aggregation.

• Has anyone implemented a similar requirement?
• What would be the recommended way to model this in OneStream while keeping a single account in the CoA?

Any guidance would be greatly appreciated.

Thanks in advance!