OLAP Newsletter Customer Feature Sept 07

SAS Scandanavian Airlines have implemented a new Financial Business Intelligence platform. They use Oracle Database 10g with OLAP, RAC and OWB. For querying, they use Oracle Application Express as well as Discoverer and Spreadsheet Add In. 350 users access the Budget and Planning application and the predefined reports.

Technical Solution:

The solution implemented is a 2 node RAC Database and a single Oracle Application Server architecture. There are 13 cubes, with approximately 300 OLAP measures. Cubes are mostly 6 dimensional, with up to 10 hierarchies per dimension. Data is entered from Excel, as well as fed from the General Ledger daily. Oracle Application Express provides drill through reporting from Oracle OLAP to General Ledger detail.

The solution evolved from 2 existing Oracle Financial Analyzer implementations (used with HyperRoll), and consolidates information from 2 Oracle Financials applications to a single source. The solution was also chosen for its scalability and performance, and the ease of the security administration is seen as a huge bonus. The administration and consolidation of the systems has meant significant cost savings.

Also important to SAS Scandanavian Airlines was the flexibility of the architecture being able to accommodate business changes and wider scope as part of their ongoing evolution.

Görel Lagercrantz, Director SAS Financial Systems, The SAS Group states "The consolidation of information from multiple applications, coupled with ease of administration, lower licence and support costs, and reduced consulting support, will result in a 40% reduction in cost of ownership compared to our previous budgeting applications.  Additionally the Oracle database with the OLAP option gives us scalability, functionality and performance for our 350 user base, and an open foundation from which to develop in the future".

The solution was implemented by and this information is courtesy of SAS Scandanavian Airlines and Oracle Consulting in Sweden.

About SAS Scandanavian Airlines:

The SAS Group, the Nordic region’s largest listed airline and travel group, offers air transportation and airline-related services from its base in Northern Europe. SAS Scandinavian Airlines, Spanair and Blue1 are members of the world’s largest global airline alliance – Star Alliance™. The Group also includes the airlines Widerøe and airBaltic as well as the partly owned airline Estonian Air and the business area SAS Aviation Services.



Copyright © 2004, 2007 Oracle. All rights reserved.