Skip to main content
gui_iannuzzi
Member
Nov 1, 2023 2:09 PM UTC

Alternate Hierarchy in Accounts dimension

Hello,

We are doing an implementation and my client needs to be able to have one legal hierarchie and one management hierarchie, the twist is I need to be able to share the accounts between the two.

Example:

Legal parent

     Account

Management parent

     Account (Shared)

I can't use extensibility because the two hierachies share no similarity whatsoever, the only thing they share is GL accounts. In my Oracle days that would be a piece of cake, but for some reason I can't make it work in OneStream Accounts dimension.

Thanks in advance

 

3 replies

IftaqarAhmed
Member
Nov 1, 2023 2:25 PM UTC

You can Select the member(s) and the "Add" the relationship. Can't you?

IftaqarAhmed_1-1698848690640.png

IftaqarAhmed_0-1698848648097.png

Hope this helps!

 

gui_iannuzziAuthor
Member
Nov 1, 2023 2:28 PM UTC

This is the error it gives me:

gui_iannuzzi_0-1698848899137.png

 

IftaqarAhmed
Member
Nov 1, 2023 4:09 PM UTC

I am not sure if you followed the below steps but here's what I did:

Refer to the screenshots below:

Step 1: Copy the Parent/Base member you want to bring into the alternate structure. (#1 and #2 in Fig-1)

IftaqarAhmed_2-1698855044488.png

Step 2: Go to the Alternate Structure and 'Paste Relationships (Add)' As First Child (#3- #5 in Fig-2)

IftaqarAhmed_3-1698855065926.png

P.S. The idea is the same - Copy a Parent node or the Base member. It will copy the relationships based on the node selected.

Hope this helps!

Terms & ConditionsAccessibility statement