Child with multiple parents

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

Accepted answers

@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

All comments

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

ManjunathKN

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.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…