Technique for managing conformed dimensions with different granularity

View previous topic View next topic Go down

Technique for managing conformed dimensions with different granularity

Post  ezryder on Mon Jul 02, 2012 5:08 am

Technique for managing conformed dimensions with different granularity

I have two business processes which take measurements at two levels within one conformed dimension.

One business process has information at the city level, and the other business process has information at the state level.

My question is what is the best way to implement this conformed dimension?

Would I be best having a dimension table something like this:

Dimension_Sid City State Country
1 Dover Delaware USA
2 Wilmington Delaware USA
3 Not recorded Delaware USA
4 Montgomery Alabama USA
5 Not recorded Alabama USA
6 Birmingham Alabama USA
7 Not recorded Illinois USA
8 Chicago Illinois USA
9 Springfield Illinois USA

Or would I have two separate but conformed dimension tables like this:

Dimension_Sid City State Country
1 Dover Delaware USA
2 Wilmington Delaware USA
3 Montgomery Alabama USA
4 Birmingham Alabama USA
5 Chicago Illinois USA
6 Springfield Illinois USA

Dimension_Sid State Country
1 Delaware USA
2 Alabama USA
3 Illinois USA

Or does it not really matter, or is there a better way?


ezryder

Posts : 2
Join date : 2011-09-15

View user profile

Back to top Go down

Re: Technique for managing conformed dimensions with different granularity

Post  BoxesAndLines on Mon Jul 02, 2012 9:31 am

You can do it either way. Having just a state dimension can sometimes be useful independent of a city, state, zip, msa, etc, type hierarchy. The grain of the fact tables using a dimension doesn't have any impact on whether the dimension is conformed.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Technique for managing conformed dimensions with different granularity

Post  ngalemmo on Tue Jul 03, 2012 1:47 am

Agreed. Conformity is more a matter of the attribute values being consistent rather than using the same physical table.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Technique for managing conformed dimensions with different granularity

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum