Hello folks,
I am new to anaplan and stucked at one small requirement.
We are having two modules i.e. Module 1 - Product segment (Defined in List for different products) with transportation cost line item and Module 2 - Transportation cost for Each segment in line items (input). Need to know how can i link the transportation cost of each segment to module 1?
What an awesome question! And way to go for choosing Anaplan! It's a great platform.to work with.
You have two options to help you link these two modules together but the key ingredient is that you MUST have a relationship defined somewhere between the product segment and the product cost. That relationship must contain a LIST formatted line item.
Hope that helps!
Create a line item subset (LISS) from the module containing the line items.
Add a new line item to module 2 but add the LISS in the applies to in addition to the other dimensions.
Use COLLECT() to pull the data from the line items comprising the LISS into the new line item.
This action has effectively converted the data held across multiple line items into a single line item containing the LISS. This can be used via a mapping to pull the data into module 1.
Now create a system module dimensioned by the LISS containing a list formatted line item referencing the list from module 1.
Create a mapping which assigns a list item from module 1 to every item in the LISS.
Using the SUM function sum the data from the new line item in module 2 which contains the LISS.
The mapping will now sum each line item into the respective list item as per the mapping in the systems module.