Location and department (n:m)

View previous topic View next topic Go down

Location and department (n:m)

Post  hennie7863 on Fri Jun 10, 2011 5:34 am

Hi,

My situation is this: i need to create a starmodel with locations and departments (n:m). multiple locations belong to a department and a department can have multiple locations. The grain of fact is on location level. A fact is at one location and not multiple.

I'm thinking about creating a bridge table for the departments and a normal dimension for the location. But the one thing i can not answer is which location belongs to a department (when there is no fact). How to solve this? Should i create a relation between location and department? That doesn't seem very kimball.

Gr,
Hennie

hennie7863

Posts : 31
Join date : 2009-10-19

View user profile

Back to top Go down

found the answer.

Post  hennie7863 on Fri Jun 10, 2011 7:00 am

Okay as i already assumed. I need to create the bridge table variant.

Fact<-locationdim-> locationdepartmentbridge<-department

pg 203 kimball the datawarehouse toolkit second edition.

hennie7863

Posts : 31
Join date : 2009-10-19

View user profile

Back to top Go down

Re: Location and department (n:m)

Post  ngalemmo on Sat Jun 11, 2011 8:02 pm

If the department is related to the fact then it should be a dimension of the fact, along with location. Otherwise, the bridge, as you desribe it would need some means to allocate the measures of the fact to the multiple departments related to the location. It doesn't seem to me that is what you would want to do.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Location and department (n:m)

Post  hennie7863 on Tue Jun 14, 2011 10:12 am

Location is the grain of the fact and location can be part of multiple departments. They want to add the measures at each department (in case of the same locations). Off course not preferable, as you said. I've tried to discourage the customer doing this, but they want it like this.


hennie7863

Posts : 31
Join date : 2009-10-19

View user profile

Back to top Go down

Re: Location and department (n:m)

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