Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

question about measurement event

3 posters

Go down

question about measurement event Empty question about measurement event

Post  fahime Thu Nov 14, 2013 5:09 am

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.

fahime

Posts : 8
Join date : 2013-11-14

Back to top Go down

question about measurement event Empty Re: question about measurement event

Post  BoxesAndLines Thu Nov 14, 2013 10:39 am

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
BoxesAndLines
BoxesAndLines

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

Back to top Go down

question about measurement event Empty Re: question about measurement event

Post  fahime Thu Nov 14, 2013 11:10 am

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

fahime

Posts : 8
Join date : 2013-11-14

Back to top Go down

question about measurement event Empty Re: question about measurement event

Post  BoxesAndLines Thu Nov 14, 2013 12:06 pm

I thought that is what I gave you, but I'm sure I'm confused as to what you are trying to accomplish.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

question about measurement event Empty Re: question about measurement event

Post  ngalemmo Thu Nov 14, 2013 12:33 pm

Orders, fulfillment, invoicing.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

question about measurement event Empty Re: question about measurement event

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum