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."