Fuzzy relationships between fact and dimensions

View previous topic View next topic Go down

Fuzzy relationships between fact and dimensions

Post  cjrinpdx on Mon Jul 18, 2011 1:16 pm

I have a fact table that represent a line item on an order. I have an employee dimension that links to the fact table. My issues is that sometimes the order line items are associated with a group and not an employee. We could create a group dimension, but we donít want the users to have to sometimes link to the employee dimension and sometimes link to the group dimension (in Excel). I would hate to add the groups to the existing employee dimension. Any suggestions?

cjrinpdx

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

View user profile

Back to top Go down

Re: Fuzzy relationships between fact and dimensions

Post  BoxesAndLines on Mon Jul 18, 2011 3:32 pm

What is a group?
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Fuzzy relationships between fact and dimensions

Post  cjrinpdx on Mon Jul 18, 2011 3:36 pm

It is a group of employees.

cjrinpdx

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

View user profile

Back to top Go down

Re: Fuzzy relationships between fact and dimensions

Post  BoxesAndLines on Mon Jul 18, 2011 3:37 pm

It sounds like a nice hierarchy on employee. Why don't you want to add it?
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Fuzzy relationships between fact and dimensions

Post  cjrinpdx on Mon Jul 18, 2011 3:53 pm

In my fact table I have a FK names SalesPersonKey that uses the role-playing dimension SalesPeson that is based on the employee dimension. In the source system they sometimes populate the SalesPerson field with a user's name, and sometimes with a group's name. I was thinking of adding the groups to the employee dimension not as an additional attribute, but as if the group was an employee. Clear as mud....?

cjrinpdx

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

View user profile

Back to top Go down

Re: Fuzzy relationships between fact and dimensions

Post  BoxesAndLines on Mon Jul 18, 2011 4:02 pm

Got it. Unless you know which employees belong to which groups, I don't see a work around here other than to keep groups in the employee dim. BTW, the application data modeler should be removed of their responsibilities. :-)
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Fuzzy relationships between fact and dimensions

Post  cjrinpdx on Mon Jul 18, 2011 4:13 pm

Thanks!

cjrinpdx

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

View user profile

Back to top Go down

Re: Fuzzy relationships between fact and dimensions

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