MODLRCreating Product Dimension
To begin let's create the dimension called Product and choosing the dimension type as Standard.
In this dimension we will add two hierarchies, one that lists totals by Brand (Default) and another which is a simple list of Products (All Products). You can copy paste the hierarchies from the Dimensional Data file downloaded earlier.
The Default Dimension with totals by brand:
All Products by Brand
Stationmaster
Pencil
Binders
Paper
Pen
Pen Set
Coolers Complete
Cooler Cups
Cooler Cups (Recyclable)
Cooler 4 Litre Bottle
Cooler 6 Litre Bottle
Cooler 8 Litre Bottle
Cooler Base Station XL2
Cooler Base Station XL3
Coffee Pro
Coffee Filter Machine
Coffee Capsule Machine
Ground Coffee 500mg
Ground Coffee 1kg
Ground Coffee 2kg
Ground Coffee 4kgAll Products by Brand
Stationmaster
Pencil
Binders
Paper
Pen
Pen Set
Coolers Complete
Cooler Cups
Cooler Cups (Recyclable)
Cooler 4 Litre Bottle
Cooler 6 Litre Bottle
Cooler 8 Litre Bottle
Cooler Base Station XL2
Cooler Base Station XL3
Coffee Pro
Coffee Filter Machine
Coffee Capsule Machine
Ground Coffee 500mg
Ground Coffee 1kg
Ground Coffee 2kg
Ground Coffee 4kg
The All Products dimension will a simple list:
All Products
Pencil
Binders
Paper
Pen
Pen Set
Cooler Cups
Cooler Cups (Recyclable)
Cooler 4 Litre Bottle
Cooler 6 Litre Bottle
Cooler 8 Litre Bottle
Cooler Base Station XL2
Cooler Base Station XL3
Coffee Filter Machine
Coffee Capsule Machine
Ground Coffee 500mg
Ground Coffee 1kg
Ground Coffee 2kg
Ground Coffee 4kgAll Products
Pencil
Binders
Paper
Pen
Pen Set
Cooler Cups
Cooler Cups (Recyclable)
Cooler 4 Litre Bottle
Cooler 6 Litre Bottle
Cooler 8 Litre Bottle
Cooler Base Station XL2
Cooler Base Station XL3
Coffee Filter Machine
Coffee Capsule Machine
Ground Coffee 500mg
Ground Coffee 1kg
Ground Coffee 2kg
Ground Coffee 4kg