3.4.3 Activity: Create Country Summary Module

Question

Hi,

I have a doubt in level 2 sprint 3.4.3 Activity: Create Country Summary Module

I did the following :-

Step 1 → Created a new column "Country Made in" in SYS08 SKU details

Step 2 → Wrote a formula Parent(Supplied By) to bring parent of the location i.e. country in  "Country Made in" column

Step 3 → I have written the formula for safety stock flag count as 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product Family, SUM: 'SYS08 SKU Details'.Country Made in]

My doubt is that in below image P3SKU → P1 Product family says auto aggregation so should i use SUM to aggregate in my formula or not ?

if SUM is not to be used, i have doubt that i have learnt that if there is many to one relationship and source and target dimension is not same then sum should be used.

is there any problem in my understanding somewhere ? Pls guide.

Thanks in advance.

Namdev Gurme · Answer

Hi @sarthakkajle Yes use SUM function with Country made in column.

Namdev Gurme · Answer

Hi @sarthakkajle Yes use SUM function with Country made in column.