3.4.3 Activity: Create Country Summary Module (SYS08 SKU Details)

akrem

Having issue with SYS08 SKU Details "Country Made In" formula tried both formulas. I believe its because its a list that I am searching in but not sure best resolution would be ?

Formula:

'SYS07 Distribution Center Details'.Country[LOOKUP:'SYS07 Distribution Center Details'.Country ]

Error:

The dimension of mapping used for lookup doesn't match any dimension of the result

OR

Formula:

'SYS08 SKU Details'.Country Made In = 'SYS07 Distribution Center Details'.Country[LOOKUP: 'SYS08 SKU Details'.Distribution Center]

Error:

'SYS08 SKU Details'.Country Made In has LIST:G3 Location format but the formula resolves to LIST:G2 Country format

Dikshant

Try to make it G2 Country list format and formula as PARENT(Supplied By)

Dikshant

akrem

Thanks that partially fixed it, it looks like I am missing a bunch of distribution centers, maybe I did not properly import not sure. Any idea how to adjust the distribution center to reflect properly?

The Demand 04 system does know how to link to the distribution center

Dikshant

Check previous lessons, you must get a file for the same mapping.

Dikshant

This is the Data, you can copy paste in your module.

	Code	Supplied By
Nutzo Bar_EN	P001EN	New York
Nutzo Bar_FR	P001FR	Paris
Nutzo Bar_SP	P001SP	Rio de Janeiro
Nutzo Bar_GE	P001GE	Dusseldorf
Nutzo Bar_IT	P001IT	Rome
Nutzo Bar_IN	P001IN	Mumbai
Nutzo Bar_JA	P001JA	Tokyo
Nutzo Bar
Raising the Bar_EN	P002EN	San Francisco
Raising the Bar_FR	P002FR	Paris
Raising the Bar_SP	P002SP	Rio de Janeiro
Raising the Bar_GE	P002GE	Dusseldorf
Raising the Bar_IT	P002IT	Rome
Raising the Bar_IN	P002IN	Mumbai
Raising the Bar_JA	P002JA	Tokyo
Raising the Bar
Cookie Crumbs_EN	P003EN	Toronto
Cookie Crumbs_FR	P003FR	Paris
Cookie Crumbs_SP	P003SP	Rio de Janeiro
Cookie Crumbs_GE	P003GE	Dusseldorf
Cookie Crumbs_IT	P003IT	Rome
Cookie Crumbs_IN	P003IN	Mumbai
Cookie Crumbs_JA	P003JA	Tokyo
Cookie Crumbs
Do-nutty Buncha Munch_EN	P004EN	Vancouver
Do-nutty Buncha Munch_FR	P004FR	Paris
Do-nutty Buncha Munch_SP	P004SP	Rio de Janeiro
Do-nutty Buncha Munch_GE	P004GE	Dusseldorf
Do-nutty Buncha Munch_IT	P004IT	Rome
Do-nutty Buncha Munch_IN	P004IN	Mumbai
Do-nutty Buncha Munch_JA	P004JA	Tokyo
Do-nutty Buncha Munch
Nougats-N-Cream_EN	P005EN	Mexico City
Nougats-N-Cream_FR	P005FR	Paris
Nougats-N-Cream_SP	P005SP	Rio de Janeiro
Nougats-N-Cream_GE	P005GE	Dusseldorf
Nougats-N-Cream_IT	P005IT	Rome
Nougats-N-Cream_IN	P005IN	Mumbai
Nougats-N-Cream_JA	P005JA	Tokyo
Nougats-N-Cream
Nougatacious_EN	P006EN	London
Nougatacious_FR	P006FR	Paris
Nougatacious_SP	P006SP	Rio de Janeiro
Nougatacious_GE	P006GE	Dusseldorf
Nougatacious_IT	P006IT	Rome
Nougatacious_IN	P006IN	Mumbai
Nougatacious_JA	P006JA	Tokyo
Nougatacious
High noon bar_EN	P007EN	Edinburgh
High noon bar_FR	P007FR	Paris
High noon bar_SP	P007SP	Rio de Janeiro
High noon bar_GE	P007GE	Dusseldorf
High noon bar_IT	P007IT	Rome
High noon bar_IN	P007IN	Mumbai
High noon bar_JA	P007JA	Tokyo
High noon bar
CooCoolicious_EN	P008EN	Melbourne
CooCoolicious_FR	P008FR	Paris
CooCoolicious_SP	P008SP	Rio de Janeiro
CooCoolicious_GE	P008GE	Dusseldorf
CooCoolicious_IT	P008IT	Rome
CooCoolicious_IN	P008IN	Mumbai
CooCoolicious_JA	P008JA	Tokyo
CooCoolicious
That's a Fine Howdy Do!_EN	P009EN	Auckland
That's a Fine Howdy Do!_FR	P009FR	Paris
That's a Fine Howdy Do!_SP	P009SP	Rio de Janeiro
That's a Fine Howdy Do!_GE	P009GE	Dusseldorf
That's a Fine Howdy Do!_IT	P009IT	Rome
That's a Fine Howdy Do!_IN	P009IN	Mumbai
That's a Fine Howdy Do!_JA	P009JA	Tokyo
That's a Fine Howdy Do!
Dr. Mocho_EN	P010EN	New York
Dr. Mocho_FR	P010FR	Paris
Dr. Mocho_SP	P010SP	Rio de Janeiro
Dr. Mocho_GE	P010GE	Dusseldorf
Dr. Mocho_IT	P010IT	Rome
Dr. Mocho_IN	P010IN	Mumbai
Dr. Mocho_JA	P010JA	Tokyo
Dr. Mocho
Craklin Nikklins_EN	P011EN	San Francisco
Craklin Nikklins_FR	P011FR	Paris
Craklin Nikklins_SP	P011SP	Rio de Janeiro
Craklin Nikklins_GE	P011GE	Dusseldorf
Craklin Nikklins_IT	P011IT	Rome
Craklin Nikklins_IN	P011IN	Mumbai
Craklin Nikklins_JA	P011JA	Tokyo
Craklin Nikklins
Franutbutter Krisp_EN	P012EN	Toronto
Franutbutter Krisp_FR	P012FR	Paris
Franutbutter Krisp_SP	P012SP	Rio de Janeiro
Franutbutter Krisp_GE	P012GE	Dusseldorf
Franutbutter Krisp_IT	P012IT	Rome
Franutbutter Krisp_IN	P012IN	Mumbai
Franutbutter Krisp_JA	P012JA	Tokyo
Franutbutter Krisp
Unichunky Krisp_EN	P013EN	Vancouver
Unichunky Krisp_FR	P013FR	Paris
Unichunky Krisp_SP	P013SP	Rio de Janeiro
Unichunky Krisp_GE	P013GE	Dusseldorf
Unichunky Krisp_IT	P013IT	Rome
Unichunky Krisp_IN	P013IN	Mumbai
Unichunky Krisp_JA	P013JA	Tokyo
Unichunky Krisp
PlanutButter Krisp_EN	P014EN	Mexico City
PlanutButter Krisp_FR	P014FR	Paris
PlanutButter Krisp_SP	P014SP	Rio de Janeiro
PlanutButter Krisp_GE	P014GE	Dusseldorf
PlanutButter Krisp_IT	P014IT	Rome
PlanutButter Krisp_IN	P014IN	Mumbai
PlanutButter Krisp_JA	P014JA	Tokyo
PlanutButter Krisp
Chocolates
Anapoppers_EN	P015EN	London
Anapoppers_FR	P015FR	Paris
Anapoppers_SP	P015SP	Rio de Janeiro
Anapoppers_GE	P015GE	Dusseldorf
Anapoppers_IT	P015IT	Rome
Anapoppers_IN	P015IN	Mumbai
Anapoppers_JA	P015JA	Tokyo
Anapoppers
Juicy Lucy gummies_EN	P016EN	Edinburgh
Juicy Lucy gummies_FR	P016FR	Paris
Juicy Lucy gummies_SP	P016SP	Rio de Janeiro
Juicy Lucy gummies_GE	P016GE	Dusseldorf
Juicy Lucy gummies_IT	P016IT	Rome
Juicy Lucy gummies_IN	P016IN	Mumbai
Juicy Lucy gummies_JA	P016JA	Tokyo
Juicy Lucy gummies
Bite Me!_EN	P017EN	Melbourne
Bite Me!_FR	P017FR	Paris
Bite Me!_SP	P017SP	Rio de Janeiro
Bite Me!_GE	P017GE	Dusseldorf
Bite Me!_IT	P017IT	Rome
Bite Me!_IN	P017IN	Mumbai
Bite Me!_JA	P017JA	Tokyo
Bite Me!
LocoMongo_EN	P018EN	New York
LocoMongo_FR	P018FR	Paris
LocoMongo_SP	P018SP	Rio de Janeiro
LocoMongo_GE	P018GE	Dusseldorf
LocoMongo_IT	P018IT	Rome
LocoMongo_IN	P018IN	Mumbai
LocoMongo_JA	P018JA	Tokyo
LocoMongo
Smacker Packer_EN	P019EN	San Francisco
Smacker Packer_FR	P019FR	Paris
Smacker Packer_SP	P019SP	Rio de Janeiro
Smacker Packer_GE	P019GE	Dusseldorf
Smacker Packer_IT	P019IT	Rome
Smacker Packer_IN	P019IN	Mumbai
Smacker Packer_JA	P019JA	Tokyo
Smacker Packer
Sweet-n-Swirlie_EN	P020EN	Toronto
Sweet-n-Swirlie_FR	P020FR	Paris
Sweet-n-Swirlie_SP	P020SP	Rio de Janeiro
Sweet-n-Swirlie_GE	P020GE	Dusseldorf
Sweet-n-Swirlie_IT	P020IT	Rome
Sweet-n-Swirlie_IN	P020IN	Mumbai
Sweet-n-Swirlie_JA	P020JA	Tokyo
Sweet-n-Swirlie
Souroly polies_EN	P021EN	Vancouver
Souroly polies_FR	P021FR	Paris
Souroly polies_SP	P021SP	Rio de Janeiro
Souroly polies_GE	P021GE	Dusseldorf
Souroly polies_IT	P021IT	Rome
Souroly polies_IN	P021IN	Mumbai
Souroly polies_JA	P021JA	Tokyo
Souroly polies
TinyBarns_EN	P022EN	Mexico City
TinyBarns_FR	P022FR	Paris
TinyBarns_SP	P022SP	Rio de Janeiro
TinyBarns_GE	P022GE	Dusseldorf
TinyBarns_IT	P022IT	Rome
TinyBarns_IN	P022IN	Mumbai
TinyBarns_JA	P022JA	Tokyo
TinyBarns
Wibbles_EN	P023EN	London
Wibbles_FR	P023FR	Paris
Wibbles_SP	P023SP	Madrid
Wibbles_GE	P023GE	Dusseldorf
Wibbles_IT	P023IT	Rome
Wibbles_IN	P023IN	Mumbai
Wibbles_JA	P023JA	Tokyo
Wibbles
Rompers_EN	P024EN	Edinburgh
Rompers_FR	P024FR	Paris
Rompers_SP	P024SP	Madrid
Rompers_GE	P024GE	Dusseldorf
Rompers_IT	P024IT	Rome
Rompers_IN	P024IN	Mumbai
Rompers_JA	P024JA	Tokyo
Rompers
HyperLemones_EN	P025EN	Melbourne
HyperLemones_FR	P025FR	Paris
HyperLemones_SP	P025SP	Madrid
HyperLemones_GE	P025GE	Dusseldorf
HyperLemones_IT	P025IT	Rome
HyperLemones_IN	P025IN	Mumbai
HyperLemones_JA	P025JA	Tokyo
HyperLemones
AnaFrazzles_EN	P026EN	New York
AnaFrazzles_FR	P026FR	Paris
AnaFrazzles_SP	P026SP	Madrid
AnaFrazzles_GE	P026GE	Dusseldorf
AnaFrazzles_IT	P026IT	Rome
AnaFrazzles_IN	P026IN	Mumbai
AnaFrazzles_JA	P026JA	Tokyo
AnaFrazzles
Connected sweeties_EN	P027EN	San Francisco
Connected sweeties_FR	P027FR	Paris
Connected sweeties_SP	P027SP	Madrid
Connected sweeties_GE	P027GE	Dusseldorf
Connected sweeties_IT	P027IT	Rome
Connected sweeties_IN	P027IN	Mumbai
Connected sweeties_JA	P027JA	Tokyo
Connected sweeties
Blasters_EN	P028EN	Toronto
Blasters_FR	P028FR	Paris
Blasters_SP	P028SP	Madrid
Blasters_GE	P028GE	Dusseldorf
Blasters_IT	P028IT	Rome
Blasters_IN	P028IN	Mumbai
Blasters_JA	P028JA	Tokyo
Blasters
Sours
SF Bay Water Taffy_EN	P029EN	Vancouver
SF Bay Water Taffy_FR	P029FR	Marseille
SF Bay Water Taffy_SP	P029SP	Madrid
SF Bay Water Taffy_GE	P029GE	Dusseldorf
SF Bay Water Taffy_IT	P029IT	Rome
SF Bay Water Taffy_IN	P029IN	Mumbai
SF Bay Water Taffy_JA	P029JA	Tokyo
SF Bay Water Taffy
Viking Cream_EN	P030EN	Mexico City
Viking Cream_FR	P030FR	Marseille
Viking Cream_SP	P030SP	Madrid
Viking Cream_GE	P030GE	Dusseldorf
Viking Cream_IT	P030IT	Rome
Viking Cream_IN	P030IN	Mumbai
Viking Cream_JA	P030JA	Tokyo
Viking Cream
Rocket Fizz_EN	P031EN	London
Rocket Fizz_FR	P031FR	Marseille
Rocket Fizz_SP	P031SP	Madrid
Rocket Fizz_GE	P031GE	Dusseldorf
Rocket Fizz_IT	P031IT	Rome
Rocket Fizz_IN	P031IN	Mumbai
Rocket Fizz_JA	P031JA	Tokyo
Rocket Fizz
The York Chew_EN	P032EN	Edinburgh
The York Chew_FR	P032FR	Marseille
The York Chew_SP	P032SP	Madrid
The York Chew_GE	P032GE	Dusseldorf
The York Chew_IT	P032IT	Rome
The York Chew_IN	P032IN	Mumbai
The York Chew_JA	P032JA	Tokyo
The York Chew
The Crusher_EN	P033EN	Melbourne
The Crusher_FR	P033FR	Marseille
The Crusher_SP	P033SP	Madrid
The Crusher_GE	P033GE	Dusseldorf
The Crusher_IT	P033IT	Rome
The Crusher_IN	P033IN	Mumbai
The Crusher_JA	P033JA	Tokyo
The Crusher
Ana-lisious_EN	P034EN	New York
Ana-lisious_FR	P034FR	Marseille
Ana-lisious_SP	P034SP	Madrid
Ana-lisious_GE	P034GE	Dusseldorf
Ana-lisious_IT	P034IT	Rome
Ana-lisious_IN	P034IN	Mumbai
Ana-lisious_JA	P034JA	Tokyo
Ana-lisious
Bubbles Salt Water Taffy_EN	P035EN	San Francisco
Bubbles Salt Water Taffy_FR	P035FR	Marseille
Bubbles Salt Water Taffy_SP	P035SP	Madrid
Bubbles Salt Water Taffy_GE	P035GE	Dusseldorf
Bubbles Salt Water Taffy_IT	P035IT	Rome
Bubbles Salt Water Taffy_IN	P035IN	Mumbai
Bubbles Salt Water Taffy_JA	P035JA	Tokyo
Bubbles Salt Water Taffy
Hypercrusher_EN	P036EN	Toronto
Hypercrusher_FR	P036FR	Marseille
Hypercrusher_SP	P036SP	Madrid
Hypercrusher_GE	P036GE	Dusseldorf
Hypercrusher_IT	P036IT	Rome
Hypercrusher_IN	P036IN	Mumbai
Hypercrusher_JA	P036JA	Tokyo
Hypercrusher
ChewyBlock_EN	P037EN	Vancouver
ChewyBlock_FR	P037FR	Marseille
ChewyBlock_SP	P037SP	Madrid
ChewyBlock_GE	P037GE	Dusseldorf
ChewyBlock_IT	P037IT	Rome
ChewyBlock_IN	P037IN	Mumbai
ChewyBlock_JA	P037JA	Tokyo
ChewyBlock
The Big Apple_EN	P038EN	Mexico City
The Big Apple_FR	P038FR	Marseille
The Big Apple_SP	P038SP	Madrid
The Big Apple_GE	P038GE	Dusseldorf
The Big Apple_IT	P038IT	Rome
The Big Apple_IN	P038IN	Mumbai
The Big Apple_JA	P038JA	Tokyo
The Big Apple
Funky Town_EN	P039EN	London
Funky Town_FR	P039FR	Marseille
Funky Town_SP	P039SP	Madrid
Funky Town_GE	P039GE	Dusseldorf
Funky Town_IT	P039IT	Rome
Funky Town_IN	P039IN	Mumbai
Funky Town_JA	P039JA	Tokyo
Funky Town
Twisted Ana_EN	P040EN	Edinburgh
Twisted Ana_FR	P040FR	Marseille
Twisted Ana_SP	P040SP	Madrid
Twisted Ana_GE	P040GE	Dusseldorf
Twisted Ana_IT	P040IT	Rome
Twisted Ana_IN	P040IN	Mumbai
Twisted Ana_JA	P040JA	Tokyo
Twisted Ana
Corny Chew_EN	P041EN	Melbourne
Corny Chew_FR	P041FR	Marseille
Corny Chew_SP	P041SP	Madrid
Corny Chew_GE	P041GE	Dusseldorf
Corny Chew_IT	P041IT	Rome
Corny Chew_IN	P041IN	Mumbai
Corny Chew_JA	P041JA	Tokyo
Corny Chew
Berry Jet_EN	P042EN	New York
Berry Jet_FR	P042FR	Marseille
Berry Jet_SP	P042SP	Madrid
Berry Jet_GE	P042GE	Dusseldorf
Berry Jet_IT	P042IT	Rome
Berry Jet_IN	P042IN	Mumbai
Berry Jet_JA	P042JA	Tokyo
Berry Jet
Taffy
Connutty_EN	P043EN	San Francisco
Connutty_FR	P043FR	Marseille
Connutty_SP	P043SP	Madrid
Connutty_GE	P043GE	Dusseldorf
Connutty_IT	P043IT	Rome
Connutty_IN	P043IN	Mumbai
Connutty_JA	P043JA	Tokyo
Connutty
Bay Sludge Fudge_EN	P044EN	Toronto
Bay Sludge Fudge_FR	P044FR	Marseille
Bay Sludge Fudge_SP	P044SP	Madrid
Bay Sludge Fudge_GE	P044GE	Dusseldorf
Bay Sludge Fudge_IT	P044IT	Rome
Bay Sludge Fudge_IN	P044IN	Mumbai
Bay Sludge Fudge_JA	P044JA	Tokyo
Bay Sludge Fudge
Fuddy Duddy_EN	P045EN	Vancouver
Fuddy Duddy_FR	P045FR	Marseille
Fuddy Duddy_SP	P045SP	Madrid
Fuddy Duddy_GE	P045GE	Dusseldorf
Fuddy Duddy_IT	P045IT	Rome
Fuddy Duddy_IN	P045IN	Mumbai
Fuddy Duddy_JA	P045JA	Tokyo
Fuddy Duddy
Fudgy Block_EN	P046EN	Mexico City
Fudgy Block_FR	P046FR	Marseille
Fudgy Block_SP	P046SP	Madrid
Fudgy Block_GE	P046GE	Dusseldorf
Fudgy Block_IT	P046IT	Rome
Fudgy Block_IN	P046IN	Mumbai
Fudgy Block_JA	P046JA	Tokyo
Fudgy Block
Goulden Nugget Fudge_EN	P047EN	London
Goulden Nugget Fudge_FR	P047FR	Marseille
Goulden Nugget Fudge_SP	P047SP	Madrid
Goulden Nugget Fudge_GE	P047GE	Dusseldorf
Goulden Nugget Fudge_IT	P047IT	Rome
Goulden Nugget Fudge_IN	P047IN	Mumbai
Goulden Nugget Fudge_JA	P047JA	Tokyo
Goulden Nugget Fudge
Moscone_EN	P048EN	Edinburgh
Moscone_FR	P048FR	Marseille
Moscone_SP	P048SP	Madrid
Moscone_GE	P048GE	Dusseldorf
Moscone_IT	P048IT	Rome
Moscone_IN	P048IN	Mumbai
Moscone_JA	P048JA	Tokyo
Moscone
The Hubba Bubba_EN	P049EN	Melbourne
The Hubba Bubba_FR	P049FR	Marseille
The Hubba Bubba_SP	P049SP	Madrid
The Hubba Bubba_GE	P049GE	Dusseldorf
The Hubba Bubba_IT	P049IT	Rome
The Hubba Bubba_IN	P049IN	Mumbai
The Hubba Bubba_JA	P049JA	Tokyo
The Hubba Bubba
CPX (Cashews and peanuts)_EN	P050EN	New York
CPX (Cashews and peanuts)_FR	P050FR	Marseille
CPX (Cashews and peanuts)_SP	P050SP	Madrid
CPX (Cashews and peanuts)_GE	P050GE	Dusseldorf
CPX (Cashews and peanuts)_IT	P050IT	Rome
CPX (Cashews and peanuts)_IN	P050IN	Mumbai
CPX (Cashews and peanuts)_JA	P050JA	Tokyo
CPX (Cashews and peanuts)
Marshmallow Hub_EN	P051EN	San Francisco
Marshmallow Hub_FR	P051FR	Marseille
Marshmallow Hub_SP	P051SP	Madrid
Marshmallow Hub_GE	P051GE	Dusseldorf
Marshmallow Hub_IT	P051IT	Rome
Marshmallow Hub_IN	P051IN	Mumbai
Marshmallow Hub_JA	P051JA	Tokyo
Marshmallow Hub
Mud City_EN	P052EN	Toronto
Mud City_FR	P052FR	Marseille
Mud City_SP	P052SP	Madrid
Mud City_GE	P052GE	Dusseldorf
Mud City_IT	P052IT	Rome
Mud City_IN	P052IN	Mumbai
Mud City_JA	P052JA	Tokyo
Mud city
PlanItfudge_EN	P053EN	London
PlanItfudge_FR	P053FR	Marseille
PlanItfudge_SP	P053SP	Madrid
PlanItfudge_GE	P053GE	Dusseldorf
PlanItfudge_IT	P053IT	Rome
PlanItfudge_IN	P053IN	Mumbai
PlanItfudge_JA	P053JA	Tokyo
PlanItfudge
Fudge
All Products