Creating the Department Dimension
Create a new dimension called Department and this will have two hierarchies, one for the full company structure and another which just focuses on our Profit Centres which are our storefronts and our online department.
js
All Departments
Advertising & Marketing
Finance
Information Technology
Legal
Management
Stores
Brisbane 01
Melbourne 01
Melbourne 02
Sydney 01
Sydney 02
Sydney 03
Online
All Departments
Advertising & Marketing
Finance
Information Technology
Legal
Management
Stores
Brisbane 01
Melbourne 01
Melbourne 02
Sydney 01
Sydney 02
Sydney 03
Online
Add a new Hierarchy called Retail Stores
js
All Stores
NSW
Sydney 01
Sydney 02
Sydney 03
VIC
Melbourne 01
Melbourne 02
QLD
Brisbane 01
AU
Online
All Stores
NSW
Sydney 01
Sydney 02
Sydney 03
VIC
Melbourne 01
Melbourne 02
QLD
Brisbane 01
AU
Online