question about measurement event
3 posters
Page 1 of 1
question about measurement event
Hello,
I know that fact tables correspond to measurement event.
please give me an example of a business process that contain multiple measurement event,so that every measurement event correspond to one fact table.
I know that fact tables correspond to measurement event.
please give me an example of a business process that contain multiple measurement event,so that every measurement event correspond to one fact table.
fahime- Posts : 8
Join date : 2013-11-14
Re: question about measurement event
Order fulfillment fact table.
Measures:
Count of days between Submitted to Received
Count of days between Received to Accepted
Count of days between Accepted to Complete
Count of days between Complete to Shipped
Measures:
Count of days between Submitted to Received
Count of days between Received to Accepted
Count of days between Accepted to Complete
Count of days between Complete to Shipped
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: question about measurement event
excuse me my friend,
I'm looking for an example that one business process have multiple measurement event,so that every measurement event must be in one single fact table.
therefore finally I will have more than one fact table
I'm looking for an example that one business process have multiple measurement event,so that every measurement event must be in one single fact table.
therefore finally I will have more than one fact table
fahime- Posts : 8
Join date : 2013-11-14
Re: question about measurement event
I thought that is what I gave you, but I'm sure I'm confused as to what you are trying to accomplish.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Modeling Question - Accumulating Snapshot vs. Event Transactions
» Modelling an Event Flow
» Swiss cheese and dimensional design
» how to model an event log
» The age problem
» Modelling an Event Flow
» Swiss cheese and dimensional design
» how to model an event log
» The age problem
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|