mySAP CRM Detailed View CRM Analytics: Analysis Process Designer (Release BW 3.2)

1. mySAP CRMDetailed View CRM Analytics:Analysis Process Designer (Release BW 3.2)

2. CRM Analytics Architecture

3. Analysis Process Designer • Benefits • Access, transform, and deploy information using a single data process • Visualize and interact with the information flow in your data process • New Developments • Process Mass Data NEW

4. APD - Overview • The Analysis Process Designer (APD) is a workbench with an intuitive visual interface that enables you to visualize, transform, and deploy your data from your business warehouse. It combines all these different steps into a single data process that you can easily interact with. • Use APD to pre-process your data: • Read data from different sources and write it to a single location • Transform data to optimize reporting • Ensure high data quality by monitoring and maintaining the information stored in your data warehouse • Deploy key performance indicators and analytical results to your operational processes in CRM

5. APD – Single Data Process • Combine different steps into a single data process Source 1 Target Source 2 Filter Add Merge Data Process

6. APD - Architecture SAP CRM Business Partner Marketing Attribute Business Partner Table Interaction Center Cache SAP BW Analysis Process Designer Analytical Results Transaction rsanwb Key Performance Indicators Transactional ODS, Master Data InfoProvider

7. APD – Sources/Targets Read and write from the following sources and targets : Sources: Characteristic: Read data from an InfoObject Master Data InfoProvider: Use an InfoCube, ODS object, or Multi-Provider as source Query: Read data from a query Flat File: Read data from a flat file CRM System: Transfer results to a CRM system Master Data: Update an InfoObject master data Survey Target Group: Create a survey target group in BW ODS Object: Load results back to a transactional ODS Data Targets:

8. APD – Transformations Overview Use the following transformations to modify your data: Filter: Restrict the amount of data to be processed Aggregation: Group and aggregate data according to specific fields Join: Merge data from two different sources Sort: Sort the data according to the selected fields Transpose: Transform a flat data record into a list Regression: Run a linear regression Routine: Implement any transformation with ABAP

9. APD – Transformations in Detail Filter Customer Sales 1 $ 550 2 $ 300 3 $ 250 4 $ 600 Customer Sales 1 $ 550 3 $ 250 Aggregation Customer Sales Date 1 $ 550 01/2001 1 $ 300 01/2001 1 $ 250 01/2001 3 $ 600 11/2001 3 $ 400 11/2001 Customer Sales Date 1 $ 1100 01/2001 3 $ 1000 11/2001 Join Customer Age 1 25 2 35 3 60 4 18 Customer Sales Age 1 $ 550 25 2 $ 300 35 3 $ 250 60 4 $ 600 18 2 3 Customer Sales 1 $ 550 2 $ 300 3 $ 250 4 $ 600 1

10. APD – Transformations in Detail Sort Customer Sales 1 $ 550 2 $ 300 3 $ 250 4 $ 600 Customer Sales 3 $ 250 2 $ 300 1 $ 550 4 $ 600 Transpose Customer 01/2001 03/2001 11/2001 1 $ 550 $250 - 2 $ 300 $600 $400 Customer Sales Date 1 $ 550 01/2001 1 $ 250 03/2001 2 $ 300 01/2001 2 $ 600 03/2001 2 $ 400 11/2001 Regression (Linear) y = ax + b

11. APD – Process Overview Step 2. Transform Data Step 1. Select Data Step 3. Store Data Step 4. Transfer Data BW Step 5. Deploy Data Interaction Center CRM Campaigns

12. APD - Example Select Source for your Data Read Data from any InfoProvider

13. APD - Example Transform your Data Merge Business Partners from Two Different Sources Select Specific Business Partners

14. APD - Example Store your Data Store Data in a Transactional ODS Object Preview Data

15. APD - Example Transfer your Data Select a CRM System

16. APD - Example Deploy your Data

17. Further Information CRM Training Course CR900 and TACRM6 (Partner) è mySAP CRM Analytics SAPNET Alias: CRM-Analytics è Direct contact: CRM Product Management: Ramine.Eskandari@sap.com Stefan.Kraus@sap.com è