From acquisition to reporting – the data flow for dynamic reporting with zenon, as used in ISO 50001 energy management (part 3: Reporting)
Now, as all relevant historical data is consistently stored in respective data archives, we are prepared to enter the next stage, namely to exploit the information in the context of general and specific trends. Means to comprehensively access (centrally or distributed) information sources is, once more, key. Moreover, the required values have to be selected, matched and interrelated in order to generate meaningful Key Performance Indicators (KPIs). This is where zenon Analyzer comes into play. Its seamless integration into the overall data flow of a zenon application builds the foundation of a meaningful and reliable reporting system at the transition point between production and corporate management level.
What does this look like in practice?
In applications like ISO 50001 energy management it is beneficial to collect consumption related data centrally, e.g. on a dedicated resource consumption server. However, in order to relate energy consumption with general productivity figures (e.g. OEE), it is typically also necessary to relate series of measurements and key figures from separate sources. For example, the ISO 50001 standard recommends the determination of so called Energy Performance Indicators (EnPI). Examples range from the simple caluculation of “consumed electricity per shift and/or equipment unit” to more demanding calculations, such as “electricity costs for the provision of air pressure, related to each produced unit”.
A system for a high-performance and reliable determination of EnPIs facilitates internal and external performance reviews and benchmarking.
zenon Analyzer offers comprehensive functionalities to generate, visualize and deliver reports. In the context of a zenon application, a variety of report templates can be directly applied. This means that specific attributes of variables, such as related equipments, shifts or administrative units like cost centers, can be used directly for filtering and statistical evaluations. A data-access architecture based on abstracted connectors allows access to both realtime SCADA data as well as historical values and database archives. Mechanisms of report synthesis are largely based on the Microsoft Reporting Services technology, including web-based configuration and user interfaces. Stored procedures and user-defined functions are integrated into the data preparation processes in order to allow for high-performance reporting cycles.
Quite naturally, reports can be automatically generated, e.g. depending on a fixed schedule, in the case of specific events or when particular values are exceeded. Respective actions simply have to be configured, so that a user can find the according document (PDF, Excel etc.) in the defined folder or document archive.
The ability to integrate information from various data sources into a consistent and clearly arranged data flow is fundamental with respect to advanced energy data management.
In all stages, flexibility is required to integrate various sources of information and to preserve sufficient space for new ideas and approaches. This seems to be crucial for companies to be able to retain the technical and analytical capabilities to support their business and, ultimately, to maintain their competitive position.