Department or Organization/Company

View previous topic View next topic Go down

Department or Organization/Company

Post  jryan on Thu Oct 25, 2012 8:12 am

Hi,

The DW that we're building will need to hold data for serveral different companies, all of which have different departments.

I'm not sure whether to have an Organization dimension, as Kimball shows in Ch7 of the DW toolkit, or whether to have seperate Department and Company dimensions.

I generally name a dimension at is most granular level, which would be Department. But the trouble with that is that Company is so key for the users that they may not realise that they have to go to the Department dimenson to start analysing by Company. The reverse is true also if I callled the dim Company, then they may not realise that they have to go to the Company dimension in order to start analysing by Department.

I'm curious to know what other people have done in this scenario?

Thank you

jryan

Posts : 33
Join date : 2010-09-27

View user profile

Back to top Go down

Re: Department or Organization/Company

Post  ngalemmo on Thu Oct 25, 2012 5:34 pm

You have three options:

1. Two dimension tables with two FK's on the fact.

2. One dimension table whose NK is company/department and replicate the company information on the rows.

3. Implement a hierarchy with one dimension table contains rows for companies and departments with a bridge table to allow rollups.
avatar
ngalemmo

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

View user profile http://aginity.com

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