Modelling an Event Flow

View previous topic View next topic Go down

Modelling an Event Flow

Post  AndyBarber on Fri Mar 18, 2011 11:25 am

Hi All,

I'm pretty new to data modelling and don't know the best approach to this particular problem.

I have a user who can go through multiple events before completing a process, each event could be performed multiple times or skipped completely. With the completion of each event (or repeat of each event) a record of information gathered at the event will be gathered. The content of each event is different from event to event.

e.g. Event flow could be 1 - 2 - 2 - 3 - (event 4 omitted) - 5 - 5 - 6 (end)
and at each event gathers a different set of data.

Hope someone out there can take pity on me somewhat and gently push me in the right direction.

Many Thanks in advance,

Andy

AndyBarber

Posts : 2
Join date : 2011-03-18

View user profile

Back to top Go down

Re: Modelling an Event Flow

Post  meb97me on Tue Mar 29, 2011 5:48 am

If each event is completely different then you may need a seperate FACT table for each Event Type to caputure the specific details about what happened for each occurence for that event.

However you could then probably do with a Process Summary FACT table as well which would capture the FACTS about the Process

maybe something like this

ProcessSKCustomerSKStepNumberEventSKDateSKStepCompletedProcessCompleted
110112011010110
110222011010510
110322011010710
110432011011010
110552011011410
110652011011910
110762011012311
220112011010410
220222011010810
220332011011210
220442011011410
220542011012110
220662011012811

meb97me

Posts : 34
Join date : 2010-07-28

View user profile

Back to top Go down

Re: Modelling an Event Flow

Post  frankee787 on Tue Nov 27, 2012 1:59 am

If each event was NOT COMPLETELY different and was just a change of status, then how would we model this?

Specifically how would one Model Status changes in dimensional modelling?

Regards,
Franklin

frankee787

Posts : 6
Join date : 2012-11-26

View user profile

Back to top Go down

Re: Modelling an Event Flow

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