This is one of 4544 IT projects that we have successfully completed with our customers.

How can we support you?

Support Data Warehouse 2017

Project duration: 1 year

Brief description

In this data warehouse, which is connected to SAP and Clarify or to MS Dynamics, ERP and CRM data is prepared and made available for purposes of analysis.

Supplement

The data warehouse which is the topic of this project is a globally developed reporting solution with single implementations for affiliates both in Germany and abroad. It contains a couple of relational databases both for the data import from several source systems and for the creation of fact and dimension tables. Furthermore, a multidimensional (OLAP) database for analytical purposes is part of the solution. The support project includes supervising the databases and interfaces belonging to the system, performing adjustments and expansions, and processing inquiries relating to these (HPSM incidents) from subsidiaries in Germany and abroad, including the creation of reports and upgrading existing systems to new versions.

Subject description

In this data warehouse solution country specific data and structures from several source systems (CRM, ERP (SAP), global definition data and local source data) are provided for reporting purposes. It is the analytical part of a complete solution with an operational part based on Amdocs Clarify. CRM data are combined with other source data like SAP or SAP BW respectively, consolidated and provided for reporting both as relational and multidimensional (OLAP) data. Among other things this data warehouse provides actual and planning sales values on the basis of single or aggregated customer or material data. Moreover, this solution offers extensive possibilities for service reporting.

Have we sparked your interest?

Ole Knudsen

Key Account Manager

Jetzt Kontakt aufnehmen

Contact now

Download file