5 Tips to Improve Your mySAP CRM Reports and Analytics

  • by Penny Silvia, Managing Director, SAP Analytics, Deloitte Consulting
  • October 15, 2005
These five data modeling tips help you create a comprehensive mySAP CRM data warehouse using SAP Business Information Warehouse functionality to bring together data from the necessary disparate sources.
Key Concept

Modeling CRM data differs from modeling other data in SAP Business Information Warehouse (BW) in several aspects. For example, mySAP CRM uses a closer interface to BW than other transaction systems such as R/3, allowing for real-time updating. It gets data back from BW so that actions can be initiated based on the results, and is therefore a loop scenario that requires that you think about how your data will be sent to and from your CRM system. Finally, CRM analytics aren’t “pure” analytics (drilling down to find a root cause). Instead they derive information, trends, and patterns from historical data.

When looking at your overall mySAP CRM implementation efforts, you cannot overlook the reporting and analytics requirements for monitoring and measuring your key customer metrics. While you can get or derive certain core reports directly within mySAP CRM, the vast majority of your reporting and analytic time and efforts will be in SAP Business Information Warehouse (BW).

SAP BW 3.5 and mySAP CRM have a unique relationship — a real-time updating of data that allows you immediate visibility to your CRM transaction. This means that you can execute standard reports or conduct data mining activities and know that you have the most up-to-date information available.

Penny Silvia

Penny Silvia is managing director, SAP Analytics, for Deloitte Consulting. She is part of the cross-sector executive leadership team for the SAP service line at Deloitte Consulting, responsible for developing service offerings and go-to-market strategies for SAP Analytics and SAP HANA-based solutions including SAP S/4HANA and SAP BW/4HANA. This includes both internally and externally focused activities, sales enablement, solution development, client strategies, and thought leadership.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.