Academy of Better Business

GATX Rail: Implementation of SAP BW

SAP BI serves a GATX corporation and Polish subsidiary

Using SAP BI (Business Intelligence) solutions on the basis of SAP BW data warehouse helps GATX Rail Poland report data in detail, in the form required by external and internal reporting standards in Poland as well as the American shareholder GATX corporation.

Evolution towards SAP BI

In 2004 GATX Rail Poland (under the name DEC) had been using mySAP ERP system for a few years already. The system supported processing business transactions, collected both logistic and financial data.

With company’s development and the requirement to adjust the reporting to GATX corporation stan-dards the reporting needs grew too. Various standard information systems used so far were no longer sufficient.

For some time the situation was solved by develop-ing dedicated reports in ABAP language that could overcome the shortcomings of ERP information tools. However, with the increase of the number of reports available the information needs and users’ expectations grew. It soon became obvious that it was impossible to create dedicated reports for the users’ needs as quickly as the recipients wanted and their maintenance was very expensive.

The company needed a solution that would give direct access to updated, strategic information by means of easy-to-handle user interface.

They needed a solution which would let the users focus on analysing the information and not creating reports and verifying the data delivered. The solution which would eliminate manual operations of consolidating, verifying and completing information for reporting needs.

The company needed a data warehouse. DEC (GATX Rail Poland) chose a solution by the same supplier as their ERP system: SAP BW data information warehouse. It helped save money on licence costs and use the effect of synergy when solutions supplied by one producer were integrated automatically.

Step by step

In June 2004 DEC (GATX Rail Poland) decided to choose BCC as an external partner to give comprehensive support in SAP BI implementations.

According to best practices in Business Intelligence, the project was to be carried out in stages related to particular reporting areas.

Thanks to dividing it into stages the first reports were delivered very soon. The project-related risk was also minimized and the internal DEC (GATX Rail Poland) project team could gradually take over some works connected to consequent project stages.

As regards components, the project involved SAP BW data warehouse version 3.1, with a business content knowledge (predefined metadata that facili-tate connecting the warehouse with ERP system) version 3.2. Most data comes from mySAP ERP 4.7 version. As a basis reporting intinterface an Internet browser was used which gives a possiblity to export data to MS Excel.

Financial data for Poland and for the corporation

The most important for DEC (GATX Rail Poland) were financial reports created for the American shareholder, GATX, hence the first stage of the im-plementation involved financial data.

GATX reporting standards concern the balance sheet, profit and loss statement, cashflow and some managing versions of the financial statement. That is why in preparing reports in BW it was necessary to use financial data from various components of my-SAP ERP, mainly the information from the general ledger, as well as controlling and consolidation data.
Under the project DEC’s (GATX Rail Poland) chart of accounts, based on the Polish accounting standards, and controlling structures (e.g. cost centre structure) were assigned to GATX corporate model (taking into account the chart of accounts used on the basis of GAAP American accounting standards).

For the data taken from ERP system additional mapping tables were prepared. They helped complete standard forms of data analysis on the basis of corporate requirements. Thanks to them it became possibile to report in SAP BW data warehouse both the unprocessed raw ERP data level and processed data to the corporate system requirements.
 
Besides the possiblity to create reports covering actual data, SAP BW data warehouse has been pre-pared to register the planned data, which gives con-trol over plans execution with the use of flexible reporting functions available in the data warehouse. The implementation of the data warehouse in finance finished in August 2004.

Sales reporting

The next area covered by the data warehouse implementation was sales. Naturally it is an area which generates a lot of information that must be analysed quickly and efficiently. Apart from that, in DEC (GATX Rail Poland) it is an area which gives the company information about the number of rail cars available and those used by clients at a particular time.

The project of warehouse implementation in sales lasted from April to August 2005. When compared to the original plan, its scope was extended by sales budgeting elements.
Beside classic sales reporting a very important requirement was an analysis of the condition of leased cars. Such analysis gives information about the number of cars that have been leased, are leased or will be leased by a client; where a particular car was, is or is going to be.

In order to meet those requirements SAP BW warehouse was equipped with special non-standard data structures, and data on contracts, clients’ orders as well as material and clients’ data were taken from mySAP ERP.

The implemented changes have given a possiblity to prepare many managing reports, the most important being:

• Report of ending contracts
• Cars at the client’s disposal as at a chosen day
• Average number of cars and income
• Change in the number of cars leased in a particular period
• The condition of cars per lease rate
•  Lease rates: minimum/ maximum/ average.

Characteristic maintenance activities

A next project of giving access to information through SAP BW has covered maintenance executed by GATX-owned ZNTK plant in Ostróda. Planned and unplanned maintenance works are a priority in keeping cars working.

The third project, called the technical one, made it possibile to report on maintenance activities and improved reporting financial data for technical needs.

The project focused on:

• Taking over the master data of the cars maintained including their classification and statuses (eg. a rail car or its elements like chassis; main-tenance order)
• assuring that the master data coming from various areas in order to obtain information important for maintenance are cohesive with other warehouse elements, like maintenance costs from controlling area. DEC (GATX Rail Poland) speificity required numerous expansions of data of the controlling order and material. indexes in comparison with mySAP ERP standard
• taking over maintenance data from non-standard SAP data sources, developed by DEC (GATX Rail Poland) even before the implementation of SAP BW. It was important to create a solution to handle the so-called delta mechanism, which helps refresh in the warehouse only the data which were changed and not all of them

SAP BW technical project lasted from July to August 2005.

A solution for the whole company

SAP BW project in DEC (GATX Rail Poland) is an example of ‘’interdisciplinary” character of Business Intelligence solutions. To give access to new reports that take data from different SAP modules, separate data had to be made cohesive and connected. Those included: material index (SD module – sales and distribution), maintenance order (PM – plant maintenance /CO - controlling), functional location (PM module). Thanks to that every area could be used during creating reports and data from other modules could be connected.

Reports are a starting point for taking decisions in many areas which affect the efficiency of the company’s operations, its profitability and indirectly even the level of customer service.