Child with multiple parents

adityaplanafin

Trying to make a heirarchy where a child is having multiple parents

Trying to fix it out .How do we suppose to import without getting any error

ManjunathKN

@adityaplanafin 

Thanks for sharing the scenario.
This can be brought up by numbered list

you will have multiple parents and multiple child, you basically have to create a combined list.
like
Company 1- Parent
Product 1 -Child
Product 2 -Child
Company 2 - Parent
Product 1 - Child
and so on.

you can refer to this link on how to build a combination list - https://community.anaplan.com/t5/On-Demand-Courses/Hierarchy-Design-and-Combination-Lists/ta-p/62086 

Thanks,
Manjunath

ManjunathKN

Hi @adityaplanafin 

Multiple parents of same level or different level?

Thanks,
Manjunath

anand.shekhawat

@adityaplanafin 

 

A Child can have only 'One' parent. 

I have never heard of a child having multiple parents in Anaplan. Neither outside Anaplan.

Please enlighten, if you discover something new.

 

¬Anand 

ManjunathKN

@anand.shekhawat @adityaplanafin 

Yes, i have also not heard anything like this. 

A child can have different level of parents like, parent, parent of parent. 
but cannot have different parent in same level. Anaplan cannot aggregate even if you try to have the data by numbered list and without code.

Thanks,
Manjunath

ryan_kohn

If the need for multiple parents is for reporting or output purposes, you can achieve this by building an "alternate hierarchy". You can learn more in this How To video: Modeling Video Series #3: Alternate Hierarchies [20 min], or refer to this other similar question I was able to find on Community: How to create an alternate/Parallel hierarchy. 

 

Your second comment about experiencing an import issue leads me to believe you may actually have a multi-dimensional dataset. If this is the case, you would have to structure your list/module to account for this type of relationship and include some logic to "split" the data between the two parents. Without knowing more about the dataset you're working with, it's hard to provide more specific advice.

 

A common example of a child item having multiple parents is an employee hierarchy, where employees may shift between managers throughout the year. You can review a brief course on Effective Dating in Anaplan here: https://community.anaplan.com/t5/On-Demand-Courses/Effective-Dating-311/ta-p/209 [20 min].

adityaplanafin

same level

 

ManjunathKN

Same Level, it is not possible. 

you have to create different list for the parent to be in same level Like alternative hierarchy. But in the same list you cannot have single child with multiple parents.

Thanks,
Manjunath

adityaplanafin

 

3 seconds ago

 

discuss it with an example

having one column entries as company  1,company 2 ,company 3

another column entries as  product 1 and product 2

Lets keep it simple

 

company 1 ,2,3 are the parent

and product 1 and 2 are the child as  product 1 and  product 2 are coming under company 1 and 2 as their child but product 1   must also have to come under company 3 but because of the firstoccurrence function which anaplan uses i cant do it properly as i want to do

so any help on this please

hope you got the whole scenario

adityaplanafin

Thanks Man

Really appreciated

AdwaitJha

In this case, on the basis of the example, you gave.

Instead of Product 1, you can make two products - Product_1_Company_1 (Parent - Company 1) & Product_1_Company_3 (Parent - Company 3).

That way you can have an analysis for Company 1 & Product 1 pair, Company 3 & Product 1 pair and Product 1 & all companies pair.