UEUH.com

“While some well-planned as the need for salt, the demand for de-icing of course seasonal, short-term impact greatly on weather conditions. In order for this plan plausible, can the developed system we work with intelligent forecasts, based on experience, “says DI (FH) Stephan Leitner, project manager at the RISC Software GmbH RISC Software GmbH, together with the FAW GmbH solution developed. Both companies are members of the fiveIT Hagenberg.

Sophisticated architecture

That the objectives of such a project can not be achieved solely by to just create a BI front-end over the existing data landscape – such as manufacturers of such tools suggest you – is clear when one looks at the technical challenges that were overcome in the framework of the project : multiple heterogeneous data sources from core operational systems, the need for widely varying intervals, filling the relevant areas of the consolidated data base, or the realization of a rolling plan is under consideration of the monthly values.

“The core of the system is a central staging area, which was implemented using Oracle technologies. Here the source data from the operational systems will be prepared accordingly, adjusted and transformed into a so-called star schema. On this model is based on a second layer of a Microsoft SQL Server, which provides the data via Analysis Services MOLAP objects as the front end according to the technical requirements. In this way, the respective strengths of both technologies are optimally combined, “explains Mag Stefan Wagner, Director for Business Intelligence and Database Technologies GmbH of FAW, the cornerstone of the system architecture.

As a front end for Planning, Evaluation and Reporting the product of the Delta Master of Bissantz & Company GmbH is used.

User-centered approach

As proved as important a factor for a BI project of this size are tailored to the needs of end users matched project organization and procedure. Here it was, the requirements in the context of the extended features of a modern BI solutions in the areas of warehousing, production, logistics and distribution and the cross section of functions and cost centers Cost to collect and coordinate between them.

“A key factor was the efficient distribution of tasks between RISC and FAW. could While we know well because of our longstanding cooperation with the salt Austria AG its business processes and data, and therefore support the requirements management optimally, the BI experts FAW GmbH have been in the early stages to the creation of prototypes for individual departments to focus, which were refined in the evolutionary sequence. So we managed to put one hand short-term demand changes in the project ad hoc and of complying with the tight schedule, “said Stephan Leitner.

“Through the cooperation with FAW and RISC we managed to put the central reporting and planning system of salt pans Austria AG within the short project period of just over one year to complete new legs. This custom is now our management tool that figures are available, which it needs to be able to take in processing our target markets across Europe, the right decisions, “notes DI Dietmar Ember, in conclusion.

www.fiveIT.net