How to build Parent/Child hierarchy for different sets of children

Need your help in developing a solution for this requirement. Please see the attached data sheet.We execute Jobs to make Assembly Items by consuming Comp Item numbers (Typically we consume 2 types of Comp item numbers to make one Assembly item). One Assembly item can be made in more than one way.(i.e. We can create two different jobs to consume two different sets of Comp item numbers to make the same Assembly item).Assembly items and some of the comp item numbers have the Configurations attributes assigned to them.

Now requirements is to setup a hierarchy in Anaplan to show for each Assembly Item configuration, what are the different combinations of Comp Item number configurations that we have used.

This dataset will help us to consolidate the required quantity of Comp Item number configurations for the future demand of Assembly item configurations. Planner will then plan his/her procurement of the Comp item number configurations based on this consolidated list.

Thanks in advance

Regards

Prabakaran

upgrade_job_plan_82966.csv

Accepted answers

ChrisAHeathcote

Hi,

Im sorry but I'm not able to provide screenshots.

However, I hope I can explain further.

You need to create a list for every possible combination of components and assign these to their respective parent within a composite hierarchy.

Each child element should be assigned properties which allows you to allocate the required components from a seperate components list.

When you receive an order for a parent you can use these properties to understand what existing levels of stocks you have that can be combined to create them.

How you priorities which components get used to create each parent is a separate issue but algorithms can be built into the process to determine the priority in which components get allocated. An example could be net profit, costs etc.

All comments

kawula.p

You would definitely need to use numbered lists for this hierarchy, although I'm not 100% I understand your requirements here. If Assembly_config was the parent hierarchy (L1) then you could have the Comp_item as L2 with a Comp_config as an attribute, or make the Comp_config L2 and Comp_item as L3. Now the L1 (assembly config) can be a standard list, but L2 and L3 need to be numbered (# list), so in order to build the hierarchy you first need to generate unique lists of 'Comp_item' and 'Comp_config' (use separate views in staging module that holds the .csv data and isfirstoccurrence boolean function for filtering). Would that solve your problem?

ChrisAHeathcote

Hi,

As I understand it list items can have multiple relationships within a hierarchy.

If this is the case then you need to create parallel hierarchies to accommodate all possible combinations.

Create separate lists for all levels in the hierarchy - Assembly items and Comp items
For the lowest level create lists for all possible combinations of comp items making up each Assembly item
For this lowest level assign Comp item properties to identify which comp items combine to create the relevant Assembly item

In total you will have three lists; 1. Assembly Items, 2. Assembly - Comp Items and 3. Comp Items

The first two will be a small composite hierarchy of two levels and the third will allow you to assign properties / attributes to the lowest level which defines which Comp Items roll up into the respective Assembly Item.

praba71

Thanks @kawula.p @ChrisAHeathcote for the response.

Just to make it clear, our requirement is to build the different combinations of components that make up a parent in anaplan so that when we have a demand for a parent, we can analyze which combination will work out best.

One parent will have two components and we have multiple combinations (6-7) for a parent.

Would appreciate if you provide me some simple screenshots for this, as I am still trying to understand your suggestions.

Thanks very much

Regards

Prabakaran

ChrisAHeathcote

Hi,

Im sorry but I'm not able to provide screenshots.

However, I hope I can explain further.

You need to create a list for every possible combination of components and assign these to their respective parent within a composite hierarchy.

Each child element should be assigned properties which allows you to allocate the required components from a seperate components list.

When you receive an order for a parent you can use these properties to understand what existing levels of stocks you have that can be combined to create them.

praba71

Thanks @ChrisAHeathcote

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
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…