Level 2 sprint 3 INV02 Country summary module

Highlighted
Occasional Contributor

Level 2 sprint 3 INV02 Country summary module

I am a loss how to build the formula for the Iine item safety stock flag count in INV02

 

I know this inv02 module is linked to inv01 's  line item safety stock exception count (ending inventory is lower than the safety stock target level)

 

the picture given in Anaplan tutorial is fairly difficult to understand how to link sys 08 Sku details using it's new line item called 'country made in'

 

have attached the picture in here that was given to us in the tutorial

 

The picture shows  aggregation of p3 sku in the sys 08 sku details module

 

can anyone provide any guidance??

10 REPLIES 10
Highlighted
Master Anaplanner/Community Boss

Re: Level 2 sprint 3 INV02 Country summary module

Hi @Donna Marie,

 

From the picture, what I understood is,

 

1. Source Module has TIME and P3 SKU Dimensions,

2. Target Module has TIME, PRODUCT FAMILY AND COUNTRY

 

You need to disaggregate the P3SKU value to Product Family and Country.

001.png

Now you need a mapping between these dimensions to transform the value, you have that mapping in the SYS SKU details module. 

Hint: Check the SUM function and use Country/Product family data in the SYS SKU module

 

Regards,

Vignesh M

 

 

Highlighted
Occasional Contributor

Re: Level 2 sprint 3 INV02 Country summary module

so for the line item Safety Stock Flag Count in INV02 Country summary module, does the formula look like this:

 

'Inv01 inventory ordering'.'safety stock exception count' [ sum: P3 SKU, lookup: 'SYS08 SKU details'.'country made in']

Highlighted
Master Anaplanner/Community Boss

Re: Level 2 sprint 3 INV02 Country summary module

Hi @Donna Marie ,

 

You are close, see your target model dimension(Country/Product family), you need to do sum by target model dimension.

So sum by Product family and Sum by Country made in.

 

~Vignesh M

Highlighted
Occasional Contributor

Re: Level 2 sprint 3 INV02 Country summary module

so I can do this?

 

'inv01...'.'safety exception count'[sum: 'sys08 sku details'.'product']

 

then what about the sum for country by ' country made in'?

Highlighted
Master Anaplanner/Community Boss

Re: Level 2 sprint 3 INV02 Country summary module

Hi,

 

You need to sum by the dimension which presents in the Target module, so you need to sum by Product family, not by Product and sum by Country made in.

Check, SUM Function in Anapedia, Link 

Target Module.Value = Source Module.Value[sum: Dim A, sum: Dim B]

 

~Vignesh M

Highlighted
Contributor

Re: Level 2 sprint 3 INV02 Country summary module

Hello @VIGNESH.M  @Donna Marie 

I tried this formula : 'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Country, SUM: 'SYS08 SKU Details'.Product Family]. But i don't understand. Normaly INV01 does'nt have geography as dimension, so the data displayed at INV01 (source module) is at All Region Level, while INV02 (target) is at country level. So normally, the maaping is used with a LOOKUP and not a SUM. When i try to do it with a lookup, the system says that there is a mapping error. Could you help me ?

Thanks

Younes

Highlighted
Valued Contributor

Re: Level 2 sprint 3 INV02 Country summary module

Hello everyone 
@Younes 
Here is a post (Edited) that I wrote on another group yesterday addressing the same issue.
General steps I take when determining a formula are:

  1. Find out if the data I seek is in another module?
  2. Examen the source and target modules dimensions to determine the appropriate function and if any mapping is needed
  3. Check the summary method 

Now, what exactly is the issue you are facing? Is the formula syntax is wrong or you are getting the wrong values?

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Valued Contributor

Re: Level 2 sprint 3 INV02 Country summary module

Hi

I believe you are "over-summing" here. i.e.summing by dimensions that don't need to be present explicitly in a SUM formula because it'll sum automatically on its own.
Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Level 2 sprint 3 INV02 Country summary module

Hello @einas.ibrahim 

Thank you for help and contributions. This is how i transformed the formula : 'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Country] based on your note.

Younes