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 (incidents in HPSM or ServiceNow respectively) from subsidiaries in Germany and abroad, including the creation of reports and upgrading existing systems to new versions. Due to the upcoming replacement of the supported systems by new BI solutions this support also includes tasks for the decommissioning of this data warehouse in particular affiliates.
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.