Build a model in Anaplan with a specific hierarchy

Hi,I am currently working on building a model in Anaplan with a specific hierarchy. The hierarchy includes the following levels:

Department (Level 1): Departments A, B, ..., F.
Production Line (Level 2): Production lines 1, 2, ..., 8.
Type of Line (Level 3): Types "S" and "W".
Product (Level 4): Products list .

The desired hierarchy structure is as follows:

Department A:
- Production Line 1
  - Type "S"
    - Product 1
    - Product 2
  - Type "W"
    - Article 55
    - Article 97
- Production Line 2
  - Type "S"
    - Product 4
    - Product 9
  - Type "W"
    - Article 7
    - Article 9
    - Article 97

However, during the data import process to create the lists, I encountered an issue where the import only applies to one production line, and the others fail with the error message: "Another row has already been processed with this key." The problem seems to arise due to each Production Line having two types (S and W).

Unfortunately, I am unable to create a new column in my data source to combine the Production Line and Type of Line, as I need the Line Type summary in my model.

I am seeking assistance in finding a possible solution to create this hierarchy while still maintaining the summary by Line Type. Any guidance or help would be greatly appreciated. Thank you in advance.

Accepted answers

All comments

rob_marshall

@SAtrane

Why are the products listed 1-5000? And if they can span multiple Types (S and W), why not just have a flat list of the true products? Then, the module would be dimensioned by the hierarchy as well as the "flat" product list. If that doesn't work, make the Product piece of the hierarchy a numbered list with the code being a concatenation of the code of the parent and code of the product (S_100, W_100).

HimanshuRaj

Hi @SAtrane

You need to follow below steps to solve the issue:

Create a staging module of these line items, Dep, Production line, Type, Product
Create 1 more line item Type Code where you need to concat the Production line & Type to make unique code
Create saved views with isfirstoccurrence filters
Make Type list as numbered with a display name property
Create process to update the data, In 3rd action for Type list updation, map Type Code to code, parent to production line and Type to Display name
In last action, map Type Code to Parent and Product to List Name

This way you can update your list without any error.

To create summary of Line Item Type wherever required, you need to create a new Type List with 2 items "S" & "W" and create a mapping module to map this new list to L3 Type list and use this new list to create summaries

Cheers!!

alexpavel

In addition to @Himanshu1998 : The basic rule of a hierarchy: an element can have only 1 parent. In your case, the Type should have multiple parents: Type "S" cannot have setup parent Product Line 1 and Product Line 2.

In order to make a unique element, you need to make the concatenation of Type with its parent Level 2 (Production Line). Not sure how important is to have the Type in the hierarchy.

In your case, Type is a property of the Product (like an alternate hierarchy). So, in order to have in a report Totals by W or S, you need to consider creating a line-item property "Type" and associate the Type at the Product Level.

I would also consider the case to eliminate the Type +Product Line level from the hierarchy and have Product only with 3 Levels and have the Type setup only as Line-item property of the Product (similar case of Role or Country setup as Employee level in the Level 1 course).

Hope it helps

Alex

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!