Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Technique for managing conformed dimensions with different granularity

3 posters

Go down

Technique for managing conformed dimensions with different granularity Empty Technique for managing conformed dimensions with different granularity

Post  ezryder 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

Back to top Go down

Technique for managing conformed dimensions with different granularity Empty Re: Technique for managing conformed dimensions with different granularity

Post  BoxesAndLines 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.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Technique for managing conformed dimensions with different granularity Empty Re: Technique for managing conformed dimensions with different granularity

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Technique for managing conformed dimensions with different granularity Empty Re: Technique for managing conformed dimensions with different granularity

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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