Why do some of the dimension elements (Bureau Number, Serial Number, COG, NIIN, CAGE, Part Number) have null values but report data (BCM, Failure Count, etc.)?
This occurs when there is data for a specific element, but the dimension in question cannot be found. For example, a BCM reported against a CAGE and Part Number, but that CAGE / Part Number combination could not in turn be matched to a Repairable NIIN and COG from the Price File or Haystack. In the case of a Bureau Number with null data, it could be that data was reported against a TEC, such as Common Support Equipment, which does not report against a specific Bureau Number.
