In my thesis I worked with SAP’s Customer Relationship Management module and Business Warehouse data warehouse software. My main object was the integration of these two systems. First of all, I had to examine the structure and the functioning of the CRM and the BW. A gas company authorized me to see the application of these systems in real life. I made a review of CRM and BW workflows, business objects and data model, because it was necessary for the planning.
I created the prototype of the integration in HP’s test system. At this point the main object was creating a well functioning connection between the two systems. I defined a source system in BW and background users for both sides. Then I transferred the global settings from the CRM to the BW. I activated the datasources in CRM and replicated them to the BW. CRM has many datasources, so I decided to build the prototype on the datasources of business opportunities, which have two separate parts: header and body. Accordingly I created two infocubes. Following the ETL (Extract, Transform, Load) operations I defined the right objects and rules. I created infopackages to load data from the source system into the entry layer of the BW (the PSA – Personal Staging Area). I defined transformation rules and DTPs (Data Transfer Process) to transfer data between the PSA and the infocubes. I created a multiprovider which joins the two infocubes, then I made a report on it with BW’s reporting tools, Query Designer and Analyzer.
Beside the planning of the integration my task was comparing the reporting tools and technologies of the CRM and the BW. Since the BW reports were done I made WebDynpro applications in CRM. First I reviewed the MVC (Model-View-Controller) paradigm and the structure of the applications in this programming language. Then I collected the neccessary database tables and fields for the reports. Following the incremental development model I gradually extended my applications with new features. Finally I had a reporting application with selection fields, ALV (ABAP List Viewer) tables and business graphics for the relevant key figures. The table and the graphics ensure dynamic data display depending on the selection values.
I compared the two reporting techologies from different aspects and I made a summary of my whole work.