Thanks very much for the information. It sounds very good. It seems like a breath of fresh air. I'm new to this and I'm trying to think it over.
So in my Inspection Fact table, should I place a boolean flag to determine if it is broken or not? And i guess if I want to know if a broken part is severely broken and not operational, i could put another flag for not operational?
I'm still trying to understand what i should learn from this. What principle applies.
Thanks. I think i like this solution. I'm giving it more thought.