United States Air Force-MICAP/AWP
The U.S. Air Force needed to migrate two antiquated analytics reporting applications, the WSMIS/RAM and SAV systems, to a newer application in order to provide more current supply deficiency and maintenance information to key personnel. Evanhoe & Associates, working as a subcontractor on the Lockheed Martin team, assisted in the creation of the Mission Capability (MICAP)/Awaiting Parts (AWP) Analysis application in GCSS-AF Data Services and migrated data from the former systems, enabling Air Force analysts to find all of these metrics at a single source. This application has streamlined the data load cycle, making key Business Intelligence (BI) information more accessible and useful to the Air Force.
MICAP, or Mission Capability, is the status of a weapon system to accomplish its assigned mission. AWP, or Awaiting Parts, indicates that an end item or subsystem is awaiting maintenance because the parts to repair it are not available. The reporting starts when a “partial mission capable” (PMC) or “not mission capable” (NMC) item is identified, and stops when the item is received at the base or depot, or when the requirement is cancelled. The MICAP/AWP Analysis application is comprised of an integrated Business Intelligence (BI) tool suite: OLAP (On-line Analytical Processing), an ad-hoc query capability, and pre-formatted standard reporting. The OLAP and ad-hoc query functionality provide extensive flexibility for grouping, filtering, ordering, and summarizing the MICAP and AWP applications to the analyst’s demand. Using the application, an analyst can view both the high-level MICAP/AWP picture and drill down to the individual incidents behind the metrics, both their current state and the historical perspective. This new application has eliminated several intermediate systems, processing the relevant MICAP and AWP transactions directly from the source system.