FACT or DIM or both?

View previous topic View next topic Go down

FACT or DIM or both?

Post  gary1975 on Mon Jun 17, 2013 8:13 am

Hi  
  
I am really struggling with the design of one of my Star Schemas. The granularity of the Star Schema is Individual Engagements. This is a transactional model that captures every engagement with an individual. Each engagement is captured in the FACT with the dimensions Engagement Type, Individual, and Location etc.... 
 
Engagements have Engagement Outputs not all Engagements have Outputs and there is even Engagements Outputs without an Engagement. I started to design a Star Schema around Engagement Outputs but most of the Dims are the same as Engagements apart from 'Enagement Output Type'. Also some of the questions the business wants to answer are around the types of outputs that came from an Engagement. But they still want to answer questions such as “Count of Unique individuals engaged in career planning” Career planning being an Engagement Type. 
 
Should I try and have the one FACT containing Engagements and Engagement Outputs? If so would Engagements become a Dimension?   
 
Thanks,
 
Gary

gary1975

Posts : 2
Join date : 2013-06-17

View user profile

Back to top Go down

Re: FACT or DIM or both?

Post  Mike Honey on Wed Jun 19, 2013 12:23 am

Hi Gary,

I would probably keep Engagements and Engagement Outputs as separate Facts, as they clearly have unique granularity.  Mixing granularity in one Fact table is almost always not a good idea.
 
Good luck!
Mike
avatar
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

View user profile http://www.mangasolutions.com

Back to top Go down

Re: FACT or DIM or both?

Post  gary1975 on Wed Jun 19, 2013 10:37 am

Thanks Mike

gary1975

Posts : 2
Join date : 2013-06-17

View user profile

Back to top Go down

Re: FACT or DIM or both?

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