Level 2 sprint 3 INV02 Country summary module

[Donna Marie]

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??

[VIGNESH.M]

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.

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

[Donna Marie]

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']

[VIGNESH.M]

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

[Donna Marie]

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'?

[VIGNESH.M · Accepted solution]

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

[Younes]

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

[einas.ibrahim]

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.ibrahim]

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.

[Younes]

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