Business Intelligence Solutions
UFIS®/ MIS is the UFIS®-module for comfortable and flexible management information reporting. Comprised of an Oracle database, a Crystal Reports® Server (product of Business Objects® ) and the replication mechanism to interface with the UFIS® AODB, UFIS®/ MIS-CRS offers functions for user and data management, security, system management and reporting. The report module allows both user-driven reporting as well as specific standard reports, which are packaged according to typical user needs in separate application packages. Since historical , operational and seasonal AODB data are included in the replication process, data warehousing and on-line analysis (OLAP) are supported. Furthermore, UFIS®/ MIS may be used as a basis to develop a company-wide MIS by extending the data included into the MIS-reporting to other data sources.
MIS and Reporting
Crystal Reports® / Crystal Reports® Server is the basis for all reporting in UFIS®. A variety of configurations can be implemented to allow for simple report viewing, interactive reporting or full report creation. The level of functionality available is dependent on your specific needs and those of the MIS users.
Pre-configured (“canned”) reports are available as report packages (alpha-numerical, graphical) covering movement statistics, passenger statistics, freight statistics and resource statistics:
- for traffic management controlling (TMC),
- for resource management controlling (RMC),
- for facility management controlling (FMC) and
- for airport marketing controlling (AMC).
Additionally, by using raw AODB data from areas including traffic, facility and resource information, the system allows for easy, customer-specific enhancement of the delivered MIS by the controlling or IT department.
The following figure shows an example of a controlling-report with mixed alphanumerical and graphical display (also for navigation purposes), drill-down, sorting and document-link functionalities.
The look-and-feel of reports is more or less configurable. Preferences often depend on the role the system plays within the respective company, whether it is considered as a reporting-tool or a management information system.
In addition to the general, complex reporting functionalities provided by Crystal Reports®, raw data (in/for Excel®) are often required for easy to handle, individual, ad-hoc evaluation. Since almost everyone in Controlling (and outside) knows how to handle Excel® as an individual analysis-tool, data is provided in Excel®-format. As an option, UFIS®/MIS-DGE (Data Generation for Excel) is delivered with file output for three different data sets regarding traffic management (daily, seasonal), resource management (daily) and airport marketing (raw data for statistics), covering most of the requirements for in-depth controlling.
Data Management / Database
Historical, operational and seasonal AODB data are included in the replication process, which is activated on a regular basis, extracting altered or new data from the operational AODB. Additionally, logical and numerical operations are performed on the data to enhance MIS performance. In this way, a resilient central repository is created for all of your reporting needs, from standard reporting to complex OLAP and data warehouse management.
The MIS also provides capabilities to connect to external systems using persistent storage like: Oracle, DB2, SQL Server, Sybase and Informix as well as flat ASCII files and XML. The use or adaptation of these interfaces can be offered optionally.
Security
UFIS®/MIS provides named user access and authorization at all levels of reporting as well as at the database level. Standard reports and ad-hoc reports are accessible only to authorized users for viewing. Report creation is controlled using the same mechanisms, both at the report writer level and again at the database level.
Database access is limited to authorized users. Access can be restricted at the database, table, record and field level. Sensitive data can be encrypted at the database level, and is supported by the report writer.
Oracle database system resources, including hardware capacity, can be limited based on user access and group roles. Database system resources can be monitored for statistical purposes and to allocate resources, but also to implement additional security measures.
