Dimension attributes, or new dimension

View previous topic View next topic Go down

Dimension attributes, or new dimension

Post  cjrinpdx on Thu Aug 04, 2011 9:15 pm

I have a factless fact table that is used to track the relationships between events and employees. The event dimension has a city and state, as well as status, type, etc., that the users would like to slice-and-dice by in Excel. Are there any benefits of taking the city and state from the event and creating a location dimension; and adding the LocatioKey to the factless fact table? Thanks.

cjrinpdx

Posts : 51
Join date : 2011-07-14
Location : Portland, OR

View user profile

Back to top Go down

Re: Dimension attributes, or new dimension

Post  BoxesAndLines on Fri Aug 05, 2011 8:50 am

Yes, that is a better design. Text attributes in the fact table impact performance.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Dimension attributes, or new dimension

Post  VHF on Fri Aug 05, 2011 10:01 am

Sounds like the City and State are already attributes in the Location dimension. The OP was was asking if there would a benefit to having a separate Location dimension.

My answer would be "no" for what you are doing now. Users can slice-and-dice using any attribute in any dimension. The only scenario I can think of where there would be some benefit to having Location be a separate dimension would be if there were other fact tables that related to Location. With a conformed Location dimension you would be able to drill-across fact tables if you wanted to compare event attendance with some other location-specific fact.

VHF

Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US

View user profile

Back to top Go down

Re: Dimension attributes, or new dimension

Post  Jeff Smith on Fri Aug 05, 2011 10:46 am

I like having a Geographic dimension what rolls up data by City, County, State. If Block Group is available, Block group to Census Tract, County, State is a nice hierarchy. If regions have been created, I usually add them to the geographic dimension.

If it's a stand alone dimension, it can be reused for other subjects such as, store locations, customers, etc. Which can be nice if you want to create a summary table with measures from multiple fact tables rolling up to geography.


Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Dimension attributes, or new dimension

Post  cjrinpdx on Fri Aug 05, 2011 12:45 pm

Thank you for your posts.
I do have other fact tables that relate to Location, so I will create a new Location dimension. Good point about creating a conformed Location dimension and using it to drill-across fact tables. Thanks again!

cjrinpdx

Posts : 51
Join date : 2011-07-14
Location : Portland, OR

View user profile

Back to top Go down

Re: Dimension attributes, or new dimension

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