trafikuppföljning och lönsamhetsstyrning på sas iris – internal route information system
TRANSCRIPT
Trafikuppföljning och lönsamhetsstyrning på SAS
IRIS – Internal Route Information System
Introduction
SAS Group– Approx. 1200 departures per day– 29 million passengers– Approx. 250 aircraft– Revenue 53 195 MSEK– SAS, Blue1, Widerö, (Spanair)
Production systems• Applications that plans and produces all SAS flights.• Applications that optimizes the usage of crew, aircarft
in SAS network
SAS Group IT
IT & Business Control
G u n n ar F a lckS T O U V
Infrastructure
T o m m y Lu n d inS T O P N
NDP Im plem entation
M a g nu s R o sénS T O P S
IT Architecture &Program M anagem ent
B jö rn F ag e rste d tS T O P B
L e na Fo rsg rénS T O P Y
H e lle H a n senC P H P Y
P ia P erssonS T O H B
C la u s N ie lsenC P H H B
Com m ercial Systems
L e na B o strömS T O P H
H e n rik D a rreC P H P G
Production Systems
Jo n as B e rgg renS T O P G
Ja n V ilh e lm senC P H R D
Revenue M anagem entSystems
Jö rn P e te r P e te rsenC P H R D
Decision Support
D a n A n de rsenS T O P C
SAS G roup IT
M a ts F a g erlu ndS T O D V
26MAR2008
Challenges for SAS
A changing industry• New distribution strategies• Spot market/customer loyalty• Deregulation• Differentiation of product and servicesSAS focus• Increased revenue• Decrease unit cost• Optimize production• Quicker releases of new products and services• ExpansionIT Prerequisites• EDW migration• Proactive infrastructure development
Decisions supported by New Iris
Decisions• Development of the network• Resource allocation• Aircraft investments• Product and service evaluation• Profitability comparisons and evaluations
Process• Budget, actual, prognosis
Functional scope of NewIRIS
New IRIS main objective• Measures the profitability in SAS production• ABC, cost distribution and revenue calculation system• Route profitability analysis on flight/date level• Aircraft profitability analysis on flight/date level• Profitability analysis
– Revenues– Different types of costs (cost of sales, Traffic variable
costs, production variable cost and OH) and KPI’s
Functional scope of NewIRIS• Collecting data from source system already on
flight/date level or on month level needed to be distributed to flight/date level
• Volumes from source systems are used to calculate new cost/revenues items using costs and distribution models
• Manual Data Entry needed to insert costs and values• For each process (month) the result of the whole year
is recalculated based on current price lists and retro transactions from feeding system. Therefore retro effects is calculated
• Analysis of currency effects. Note: Consolidation currency SEK.
• Enable both Standard reporting and ad-hoc reporting
Main entities in IRIS - ITEMThe entities are:• Items• Route hierarchy• Dimensions
Items• There are two types of items: Financial or Volume.• Approximately 160 basic items. • Approximately 95 items are calculated values from
models, i.e. price models (35) or distribution models (60).
• 65-70 items are directly from source systems:– 31 TRAF, 8 SPI, 6 Acco, Buco & Proco , 5 Cargo, 5
Charges, 4 Fuel, 4 NRP, 5 TP, 1 OAL
Main entities in IRIS – Route hierarchy
Route hierarchy• Route hierarchy from Group number until top level
route• Route hierarchy flight to SEG/LEG level. There are
about 4500 SEG/LEG per year.• There are approximately 350.000 Flight/dates per year. • All calculations and analysis in NewIRIS is made on the
current route hierarchy, i.e. costs and distribution models will be recalculated if route hierarchy is modified.
• All costs and distribution values are inserted on route.
Main entities in IRIS – Rest of dimensions
Dimensions maintained manually:• Station hierarchy• Service class (C and M)• Booking classDimensions maintained automatically:• Aircraft hierarchy (incl ACREG), from TRAF• Sales hierarchy, from EDW• Currency, from EDW (about 30 selected currencies)Other critical entities• BAP code (budget, actual and forecast).• Financial year, each financial year can have a different
set of models.• Process version. Each data set being handled in
NewIRIS is connected to a process version. Each PV is connected to a BAP and FY. For each PV it is defined which accounting periods that are valid. There are typical 13 PV’s for Actual in one FY.
New Iris
Data Sourcing Data StorageReporting &Application
Exchange area
ETL
Profit tool
LandingArea
StageArea
ReportSupp.
eDW
Repository
ETL Support
Manual input
Calc. Modeler
Data exchange
ETL Process
New IRIS, Logical overview
Profit tool
Operational data entry users
Calc Admin
BaseStorage
SourceSystems
Errorcorr
DimMgmnt
VersionMgmnt
SSIS-processes(System developer)
SSIS-processes
Input archive
ErrorArea
Report usersSystem manager & System configurator
input
System manager
System configurator
ODBC access Platform internal access
Report Server
Q & A