Headstart on a Geography Dimension

Use this table to get started with a Geography Dimension. The next step for me will be to add zip codes or a County/Town/Neighborhood breakdown. Different clients will have different needs. You could store this table separate from a further breakdown and then either snowflake them in the Cube's Data Source View or use a named query in the Data Source view to combine them and star them.

ID	Name	ParentID
1	US	1
2	Northeast Region	1
3	Midwest Region	1
4	South Region	1
5	West Region	1
6	New England Div	2
7	Mid-Atlantic Div	2
8	East North Central Div	3
9	West North Central Div	3
10	South Atlantic Div	4
11	East South Central Div	4
12	West South Central Div	4
13	Mountain Div	5
14	Pacific Div	5
15	Maine	6
16	New Hampshire	6
17	Vermont	6
18	Massachusetts	6
19	Rhode Island	6
20	Connecticut	6
21	New York	7
22	New Jersey	7
23	Pennsylvania	7
24	Wisconsin	8
25	Michigan	8
26	Illinois	8
27	Indiana	8
28	Ohio	8
29	Missouri	9
30	North Dakota	9
31	South Dakota	9
32	Nebraska	9
33	Kansas	9
34	Minnesota	9
35	Iowa	9
36	Delaware	10
37	Maryland	10
38	District of Columbia	10
39	Virginia	10
40	West Virginia	10
41	North Carolina	10
42	South Carolina	10
43	Georgia	10
44	Florida	10
45	Kentucky	11
46	Tennessee	11
47	Mississippi	11
48	Alabama	11
49	Oklahoma	12
50	Texas	12
51	Arkansas	12
52	Louisiana	12
53	Idaho	13
54	Montana	13
55	Wyoming	13
56	Nevada	13
57	Utah	13
58	Colorado	13
59	Arizona	13
60	New Mexico	13
61	Alaska	14
62	Washington	14
63	Oregon	14
64	California	14
65	Hawaii	14