I have one module called SAP inventory detail which consists of one numbered list, and other module called Aggregate Demand schedule which consists of another numbered list. I need to fetch the line item called demand from Aggregate Demand Schedule to SAP inventory Detail module. Can anyone please help me on this.
Just to add to @abhi1017 you will either use LOOKUP or most likely SUM if the dimensions of your target module are different. If you are using the same dimensions, you can just reference it.
Remember this point though. Very important... In order to use SUM, you will have to reference a list formatted line item, preferably from a System Module. (See DISCO). That list formatted line item MUST be one of the dimensions (lists) in your TARGET module.
You got this @1635834 If you need any help writing the formula, send a note here. Also, make sure you tell us what the lists you are using in the SOURCE module (SAP) and the TARGET module.
Ok, I think I understand now. The screenshots really helped.
Anaplan cannot "guess" the mapping so you have to explicitly define the relationship between those two lists in order to join them, just like with any relational table.
The best strategy here is to first decide if there is a 1:many mapping between the lists. If so, you're in luck and this will be an easy exercise. If there is a many:many relationship, you're in for quite a challenge.
1:1 or 1:many.
In this case victory is achieved by getting the TARGET module's list mapped.
So in your system module for your SOURCE create a list formatted line item, maybe called TARGET MAP, that uses the TARGET list.
Assign each SOURCE line item to the correct TARGET line item.
Now, in the TARGET module use the SUM function. Your formula will look like this: TRANSACTION LINE ITEM[SUM: SYSTEM MODULE.TARGET MAP]
If at all possible try to have this done outside of Anaplan because you'll have to create a two dimensional mapping module in order for this to work. It's not pretty.
If you have to use Anaplan, be prepared for a large module and a lot of headaches.
Create a module that uses both the SOURCE list and the TARGET list
Create two line items, one that has the allocation percentage and one that has the calculated value.
For each mapping, you will need to assign an allocation percentage of the SOURCE to each TARGET. The allocation percentages must total 100% for each SOURCE value.
Example: If you have SOURCE: A (100) and B (200) and TARGET C and D. A is 60% to C and 40% to D. B is 20% to C and 80% to D. So C = 100 (60+40) and D = 200 (40 + 160).
Now in your TARGET module you can use the SUM function on the calculated value in your mapping module.