Modelling a related facts scenario

View previous topic View next topic Go down

Modelling a related facts scenario

Post  arfoot653@gmail.com on Wed Feb 01, 2012 6:20 am

Hi,

Iam working on modelling a dimensional warehouse for a ticketing system. I have a accumulating snapshot fact table and the grain is individual ticket and there are a few dimensions involved. An individual ticket can be related to few other tickets in the system. How do i model this scenario?

Should this be a table where i store the fact id of the ticket and fact id of the related tickets, so that they can be joined with the fact table to retrieve the attributes?

Thanks in Advance.

arfoot653@gmail.com

Posts : 9
Join date : 2012-02-01

View user profile

Back to top Go down

Re: Modelling a related facts scenario

Post  ngalemmo on Thu Feb 02, 2012 10:36 am

Maybe, it depends. Is there a hierarchy among a group of tickets? How does one ticket relate to others?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Modelling a related facts scenario

Post  arfoot653@gmail.com on Fri Feb 03, 2012 10:18 am

There are two cases. 1) Some tickets could be identified as realted to another Global ticket, which becomes the parent of the ticket. 2) Some tickets could be raised to address an already entered ticket, in which case its considered a related ticket, no hierarchy, but related.

Thanks,
Arun.

arfoot653@gmail.com

Posts : 9
Join date : 2012-02-01

View user profile

Back to top Go down

Re: Modelling a related facts scenario

Post  hang on Fri Feb 03, 2012 6:24 pm

It sounds like a role playing dimension by ticket. Is the ticket number a degenerate dimension (DD)? If it is, then put DD in different columns in the fact table. Otherwise have ticket SK by different aliases in your fact table like a normal role playing dimension.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Re: Modelling a related facts scenario

Post  arfoot653@gmail.com on Sat Feb 04, 2012 4:38 am

Hi hang,

Thx for your reply. For the global ticket i had done a role playing dimension, since every ticket can be related to only one global ticket. But one ticket can be related to variable number of multiple tickets. So role playing dimensions are ruled out.

Thanks,
Arun.

arfoot653@gmail.com

Posts : 9
Join date : 2012-02-01

View user profile

Back to top Go down

Re: Modelling a related facts scenario

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