Transcript Slide 1

RAF Logistics (Air) Reporting
The Actuate story so far
Sqn Ldr Alan W Moore
Head of Reporting Services
Management Information Branch
Supply Chain Support (Programmes)
Defence Equipment & Support
Royal Air Force Wyton
RAF Logistics (Air) Reporting - Scope
•
•
•
•
•
RAF Logistics - what we do
How we got Actuate
Data Sources, Product areas & examples
Reporting Service Changes and Benefits
What Next
RAF Logistics - What we do
Logistics (Air) = Engineering and Supply activities for aircraft
• Air Command - operate aircraft
– Daily Servicing (eg. fuel & stores)
– Repairs (limited capability)
– Scheduled Maintenance (not deep maintenance)
• DE&S
– Integrated Project Teams - support to Air Command
• Manage support activities
• Manage range of spares
• Develop modification programmes with Design Authority
• Manage Industry contracts for repair & maintenance
RAF Logistics - What we do
• DE&S (contd.)
– Specialist Areas - examples:
• Inventory Optimisation
• Reliability Centred Maintenance
• Industry (RR, BAe, MAe, LM, Boeing, etc.)
– Design Authority and/or overhaul/repairing
– Contracting - traditional, ILS, availability & capability
– Reporting & data exchanges
RAF Logistics - What we do
Management Information Reporting Services
• Customers - IPT, Commands/MOBs & Industry
• The Reporting Team
– 10 Actuate qualified
– Functions:
• Scrutinise Requirements
• Develop & Test
• Customer Walkthrough
• Release (& manage) Service
• Quality Management System - ISO 9001:2000 approved
• ITIL - IT Service Management
How we got Actuate
Typhoon => Eurofighter
Picture taken at RIAT
Upon introduction of Typhoon aircraft
• Needed a reporting system that would:
– Comply with MOD Architecture and be run over the MOD RLI
– Connect to multiple database sources of differing standards
– Output in multiple graphical formats
– Would minimise development resources
– Provide Web Reports that could be manipulated by Customers
Common Support Services (CSS) - overview
User
Protocol Firewall
Reverse Proxy Server
Domain Firewall
Access Server
HTTP Server
LDAP Server
Application Server
Portal Server
LDAP Directory
QuickPlace
Exchange
Portlet
Self-Service
Portlet
DB2 Database Server
Self-Serve
Database
Air Data
Mart
Other Database Server
(eg Teradata)
Air Data
Mart
Internal Message Service
Bulk Data
Loader
MF - MJDI MIS
SameTime
Metadata Management
External Message
Service
E&AM - LITS & MDS
Transform
BI Tool
Prepare
ACTUATE
ETL Tool Suite
Discover
Staging Server
& File
Processing
Reporting Server
Data Sources:
Workflow
Business
Data Store
LITS API
LITS CADB
RCADB
MJDI MIS
MQ & MQI
Configuration
Manager
Systems
Management
Tools
Terminal Services
Client
Systems
Management
Tools
CMF
Reporting Services - Products
E&AM Subjects (LITS)
Maintenance Time
recording
5%
Maintenance
Personnel
5%
(41 live CADB,
22 with macros)
Asset Location
19%
Maintenance
Management
10%
Data Management
5%
Work Orders
2%
Configuration
5%
Utility
4%
Maintenance
Planning
9%
Engineering
Instructions
7%
Fault Reporting
1%
Fatigue & Lifing
16%
Engine Management
12%
Plus:
• CSA
– Performance
• Materiel Flow
– Asset location
& status
– Demand
management
– Asset forecast
Flight Line
- live data source
Report Parameters
input by customer
Aircraft Controllers Report
on LMU, by aircraft
For airworthy
reports - include
data date-timestamps
MOB/IPT Report
- latest/recent data
Plan Aircraft
Maintenance / View
existing extensions
IPT Report example
- historic data
CSA Report
(factitious data used)
Maintenance event
arisings by system
How
event
was
rectified
Reporting Services - Before Actuate
• What we were doing:
– LITS data no web-based reporting
• Eureka - from Computer Associates
• Smart Server scheduling
• Reports accessed via menus from within application
• Created Access DB services
• Data Mart Service (using DEX - product QinetiQ licensed from
ClearPace)
– MDS
• SQL data extractions to customer
Reporting Services - With Actuate
• What we now do:
– Web-based reporting (visibility - helps diagnose problems)
– Deliver E&AM and MF reports via Air Command portal
• Mix of live, operational and back-office data stores
• Reports available to deployed operational sites (eg. IRAQ )
• Multi data source reports
• Typhoon Reporting
– Introduced New Services
• MJDI, CSA & AwIS reporting
Reporting Services - Actuate Benefits
•
•
•
•
•
•
•
•
Need less reports (use generic - less maintenance & resources)
Visibility of how customers use the reports
Combine data from multiple sources
Add Graphical presentation of data
No more need for macros to be run against report extracts
Ability to do pixel-perfect layouts
Ability to do the difficult jobs due to highly configurable tool
Easier metadata management for developers (knowledge base &
data table linking)
Reporting Services - Next steps
• Future Actuate work
– Convert remaining LITS reports
– Introduce Actuate Query
• When LITS report conversion completed:
– Revisit & make greater use of graphical presentation
– Provide customer with more ability to set trigger levels
• Support BI CC formation
– Additional data sources? (eg. MDS data in EDW)
– Additional reporting requirements?
• Prepare for SOA?
RAF Logistics (Air) Reporting
Questions ????
Sqn Ldr Alan W Moore
Head of Reporting Services
Management Information Branch
Supply Chain Support (Programmes)
Defence Equipment & Support
Royal Air Force Wyton