Child with several parents in hierarchy

[EmmelineM]

Hi all,

I would like to create a hierarchy with 3 levels of lists: 1. Entity > 2. Direction > 3. Department.
In the level "2. Direction", I want items to belong to several Entities. It is the same for Department level (a Department can belong to several Directions). I need to create a data hub and then a spoke model.

In the picture below you can find an example of my problem:

I don't really know how to populate my 2.Direction list in the spoke model. In my data hub, I've created 3 flat lists: Entity, Direction and Department. I don't know how to roll up my list 2.Direction into my 1.Entity list when it comes to the spoke model.
I was thinking about using a numbered list for both Direction and Department in my spoke model? I don't know how I can export these items from the data hub to the spoke model (I can import them manually, but that is not the point).

Thank you in advance for your answers

[JaredDolich]

@EmmelineM

Great question and one that occurs a lot. I have two suggestions:

1. (recommended) You can make each direction unique, like Marketing|Sales and Retail|Sales. In the system module for direction you can parse the code and create a line item with FINDITEM to a separate flat list that contains the direction values, for example Sales. Then you can use SUM or LOOKUP on the Sales Direction..
2. 另外，您可以创建一个相交模块，有些将其称为计算模块（Disco），该模块处理了许多映射。一个列表包含该实体，一个包含方向。您可以创建一个具有列表并使用布尔值的模块来指示关系（这会产生很多稀疏性），也可以创建一个仅包含有效组合的单独列表。

[ChrisAHeathcote]

@EmmelineM

It is possible to create as many hierarchies as is required. However, a child can not have multiple parents within the same hierarchy.

In your data hub create a module dimensioned by each list. Add line items for code, name and parent code. Use formula to populate code and name. You will need to manually allocate each item to a parent by entering its respective code against each list item.

Create a saved view for each module where you only show the code, name and parent code. You will need a view each time you need to allocate a new parent. Create a parent code for each distinct hierarchy. We will use this to create the various hierarchy lists in the spoke model.

Create another saved view where you do not include the parent. We use this to create a set of flat lists in the spoke model.

在Skok Model中创建您需要的所有列表；平面列表和每个层次结构。对于层次结构，将属性添加到列表中，并通过三个平面列表来维数。这些将用于跨层次结构映射。

Import all your lists into the spoke model as flat lists first by selecting the 'Connect to Anaplan,' option when selecting to import and list.

Find the saved view from the selection and map the line items in the source view to the items in the list. Import using code if you have one other use name.

Repeat this process for each saved view for the remaining hierarchy lists ensuring that you also map the code into the properties.

Once all import actions are run you should have a full suite of hierarchies containing the various parents and mapping into the corresponding flat lists contained within the properties.

Good luck,

Chris

[社区成员115881 · Accepted solution]

Hi Emmeline,

I suppose it depends on the context and whether the children should be unique or can be assigned simultaneously to various Entities.

In the below example I simply created a numbered list where each child bears the name of a direction (using the display name).

This is easy to automate using a simple Boolean and an import action.

I hope this helps,

Regards

Douglas