Technology

Comarch ALTUM Business Performance Management solutions use a full scale data warehouse with Online Analytical Processing (OLAP) technology – a data module that enables complex analytical queries with a rapid execution time. The data warehouse is an independent database with a snowflake structure that includes only those elements that are used during the data analysis. Its specific, multi-dimensional structure makes it possible to supply the necessary data during analysis much faster than an operational (transactional) system.

The data in the warehouse is refreshed once every twenty-four hours during the data transformation cycle known as ETL (Extraction, Transformation, Loading). The database is usually replenished at night (because doing so in the day would overload the system database) but this may be achieved manually (entirely or for selected domains) by the system administrator. The data warehouse is the source of information for the analytical domains in the OLAP technology. These are available to users of Comarch ALTUM Business Intelligence and provide for the rapid and straightforward analysis of multi-dimensional data available within the domain’s framework. Because the OLAP cubes include data that is partially aggregated, even complicated analyses and reports are available ad hoc. The major data presentation tool is the Book of Reports built into Comarch ALTUM, but information from the analytical cubes can also be examined from other analytical tools that facilitate a connection with OLAP, such as MS Excel. Comarch ALTUM Business Intelligence is based on the following components:

• Microsoft SQL Server Database Engine (HD)
• Microsoft SQL Server Integration Services (ETL)
• Microsoft SQL Server Analysis Services (OLAP)
• Microsoft SQL Server Reporting Services (BSC)

Forecasting and data mining

CRM

Back (Business Intelligence)

Have quick access to continuously updated information

With the Comarch ALTUM Business Performance Management tools you do not have to worry about the timeliness of analytical data. The system performs an ETL process (extraction and transformation of data from the transactional database, and then loading it into the data warehouse and OLAP analytical areas) in a way that is both automatic and unnoticeable, usually at night. As a consequence, the very next morning you have access to the most recent, aggregate information prepared for reporting purposes.

Construct and view reports in external tools

Comarch ALTUM fully cooperates with Microsoft applications such as MS Excel. It means that you can analyze information stored in the analytical cubes by importing data into an Excel spreadsheet. This feature allows users, to use data that was input into Comarch ALTUM in their office application. Additionally, since the imported data can be refreshed at regular intervals, there is no need to manually refresh or reload the data.

Invest wisely

Comarch ALTUM Business Performance Management tools use the latest technologies and software solutions such as .NET or Microsoft SQL Server 2008 (with Microsoft SQL Server 2005 compatibility), guaranteeing that the technologies are continually supported and developed. Therefore you can be sure that the system will serve you for many years without the need to replace or upgrade it, which should certainly be taken into account when deciding on the selection of an ERP system.

Forecasting and data mining

CRM

Back (Business Intelligence)