• Instead of creating multiple flags, create a new dimension describing the status or outcome of the inspection. This new dimension could have values like: New, Operational, Some wear, Schedule repair, Not operational, Broken. This could provide some insight to the lifespan of the part, since a part starts as New, gets inspected a couple of times and finally replaced.

    You might want to consider a Reason dimension to the repair fact, describing the reason of the repair: Scheduled, Emergency, Broken.