Forum Discussion

OELM's avatar
OELM
New Member
1 year ago

Managing Hierarchies with multiple Parents

Hello,

I have a table in which I am managaing all the Child-Parent Relationships of all dimensions. However when it comes to one particular dimension, I have a problem and I can't use the PATH function because I have multiple hierarchies within this dimension (meaning that I have for the same Child multiple Parents). To make it easier to understand here is an example:

 

The cost center VVP3 is in my main hierarchy but it is also part of Marketing Cost centers hierachy and thus having both Marketing & VP2 as a Parent.

 

 

 

 

Is there any workaround to solve this problem?

 

Thanks in advance