Scope statement & ignoring non leaf data

Well, let me start off with a brief introduction to the problem : My client, a large coal mining concern, has a warehouse concerned engineering availabilities - i.e. what the machines are doing at any given point. The fact table, FactAvailabilityHours is related to various dimensions (time et al), and has a measure called Duration - in hours oddly enough.One of those dimensions is a structure representing what a machine was doing - this Dimension is called DimAvailabilityHours.The tables for these are below

Read more...