Added value through the use of Fiplana

Time to value 6 months until first applications go live

Return on investment: 1 day instead of 1.5 days of monthly effort to create the forecast and agile reports through self-service BI approach


Lufthansa CityLine was looking for an alternative to its predominantly static reporting system based on SAP BW. In addition, the airline's controlling department wanted to optimize cost planning specifically with regard to the degree of automation, reliability and transparency of the planning values.

What was the challenge?


  • There was no BI self-service for the business departments, so many individual steps were implemented manually.
  • The report development was slow and cost a lot of time.
  • The maintainability of the BI system environment was very tedious and had to be simplified.


  • The SAP-ERP based cost planning process had to be replaced as it was not efficient enough and cost a lot of capacity
  • Planning had to be created from various data sources
  • A system-supported target and actual cost unit accounting could only be mapped with high effort

Lufthansa CityLine: Solution with Fiplana

The main arguments in favor of the solution with Fiplana were the ability to function both as a frontend and to cover the ETL process in the backend, as well as the high flexibility in dealing with source systems and analyses, and the self-service functions. Lufthansa uses Qlik Sense as the source system for its data. Fiplana allows data to be edited directly in the Qlik interface or new data to be entered in Qlik Sense. In addition, Fiplana contains complex planning functionalities, such as the transfer of reference data or planning execution based on real history data. In order to take relevant developments into account and to bridge the gap between the planned values created in the previous year and the current actual values, a rolling forecast should also be mapped. Thomas Bayer and Patrick Lowski, Co-Project Managers Controlling2.0@CLH at Lufthansa CityLine, explain: "We had previously planned the "Expected Actual" (VI) - as we call the forecast - in Excel and reported it to the Group.

We always had to manually post the projected actual cost items individually in the system or import them via uploads. We wanted to automate this input process instead. INFORM then implemented the budget planning, planned cost unit accounting and VI processes in an agile process, even putting in the odd night shift to develop an algorithm for calculating the projected actual, for example," Bayer and Lowski continue. In the future, it will increasingly be possible for the airline to see in a BI system exactly which engine or aircraft is causing which costs. "Actual cost accounting will provide us with the significant added value of then being able to derive statements at cost unit level during the year, as well as being able to identify differences from planned rates. All this is only possible because of Fiplana."


Sales & Inside Manager
Would you like to learn more about our solution for dynamic reporting and optimized cost planning? Let our experts advise you now.

Plan. Analyze. Elevate.
Optimize your financial planning with Fiplana.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram