Forum Discussion

jteixidor's avatar
jteixidor
New Contributor
6 days ago

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!

Finance

1 Reply

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    10 hours ago

    That is not possible because parent Account values do not exist in the database - the values you see in the parent Accounts are dynamically accumulated from the children members. And it is the same for the Flow and UD dimensions but you have more options there because you can set constraints on these dimensions by Entity. I don't think you will be able to get around having multiple parents in whatever dimension you choose and I can't think of way of doing that using the Account dimension.