Dimension is shipyards that open a few months and close for a few. Question on how to model?
2 posters
Page 1 of 1
Dimension is shipyards that open a few months and close for a few. Question on how to model?
Hi,
Our business is a few shipyards where ships arrive, unload material and then leave. A shipyard is open for business for some months, then shuts down for maintenance, then reopens and so on. We are trying to calculate shipyard utilization (i.e. total ship time in shipyard, divided by total Shipyard Open time).
My dimension is Shipyards, which has Shipyard name, Shipyard number. How do we add the particular Shipyard Open Date and Close Date in this dimension? (NOTE: The shipyard is open for several weeks or months at a time, and then closes for several weeks).
Thanks in advance!
Our business is a few shipyards where ships arrive, unload material and then leave. A shipyard is open for business for some months, then shuts down for maintenance, then reopens and so on. We are trying to calculate shipyard utilization (i.e. total ship time in shipyard, divided by total Shipyard Open time).
My dimension is Shipyards, which has Shipyard name, Shipyard number. How do we add the particular Shipyard Open Date and Close Date in this dimension? (NOTE: The shipyard is open for several weeks or months at a time, and then closes for several weeks).
Thanks in advance!
BI Consultant- Posts : 18
Join date : 2011-08-09
Re: Dimension is shipyards that open a few months and close for a few. Question on how to model?
Opening and closing a yard is a business event, wither it is opened or closed is a business state. One or the other should be maintained in fact tables. You may carry current status on the dimension, but it doesn't seem it would be useful for anything.
Similar topics
» Dimensional Model question
» Question about using date dimension keys in other dimension tables
» Question on breaking out Degenerate Dimension to separate dimension
» Question on how to model price lists
» Bridge table for patient diagnosis
» Question about using date dimension keys in other dimension tables
» Question on breaking out Degenerate Dimension to separate dimension
» Question on how to model price lists
» Bridge table for patient diagnosis
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum