MD_ThingMeasured

Dimension

Natural gas, water, waste water, steam, chilled water, electricity, etc. - whatever material or "thing" is being measured.

The business key for this table is the thing measured plus the category. E.g., we may be measuring "Energy Consumed," but that alone does not uniquely identify an entry here. For that we need also the category, which in this case is "Energy."

In cases where things like an ambient air temperature are being measured, we use a generic thing measured lable: Temperature. The category in this case may be "Weather" (if the data comes from, e.g., a weather station) or "Operations" if the temperature is being measured for some internal component or fluid level.

This table should be joined, through a fact table, with a unit of measurement (e.g., kilowatt hours). Similar materials or things being measured should, where possible, use identical units of measurement. If necessary, conversions should be done to achieve this.

The designation "thing measured" is deliberately vague, since a measurement may be not only of a material, but also of things like blade rotation speeds, circuit breaker cut ins, and other non-material states or activities.