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.

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

All Stores
	NSW
		Sydney 01
		Sydney 02
		Sydney 03
	VIC
		Melbourne 01
		Melbourne 02
	QLD
		Brisbane 01
	AU
		Online