my SAP CRM Detailed View CRM Analytics Analysis

my. SAP CRM Detailed View CRM Analytics: Analysis Process Designer (Release BW 3. 2)

CRM Analytics Architecture ã SAP AG 2003, APD / Ramine Eskandari 2

Analysis Process Designer Benefits n Access, transform, and deploy information using a single data process n Visualize and interact with the information flow in your data process New Developments n Process Mass Data NEW ã SAP AG 2003, APD / Ramine Eskandari 3

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. n Use APD to pre-process your data: Read data from different sources and write it to a single location u Transform data to optimize reporting u Ensure high data quality by monitoring and maintaining the information stored in your data warehouse u n Deploy key performance indicators and analytical results to your operational processes in CRM ã SAP AG 2003, APD / Ramine Eskandari 4

APD – Single Data Process Combine different steps into a single data process Target Source 1 Source 2 Filter Add Merge Data Process ã SAP AG 2003, APD / Ramine Eskandari 5

APD - Architecture SAP CRM Business Partner Marketing Attribute Business Partner Table Interaction Center Cache SAP BW Analytical Results Key Performance Indicators Analysis Process Designer Transaction rsanwb Info. Provider ã SAP AG 2003, APD / Ramine Eskandari 6 Transactional ODS, Master Data

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

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 ã SAP AG 2003, APD / Ramine Eskandari 8

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

APD – Transformations in Detail Sort Customer 1 2 3 4 Sales $ 550 $ 300 $ 250 $ 600 Customer 3 2 1 4 Sales $ 250 $ 300 $ 550 $ 600 01/2001 $ 550 $ 300 03/2001 $250 $600 Transpose Customer 1 1 2 2 2 Sales $ 550 $ 250 $ 300 $ 600 $ 400 Customer 1 2 Date 01/2001 03/2001 11/2001 Regression (Linear) y = ax + b ã SAP AG 2003, APD / Ramine Eskandari 10 11/2001 $400

APD – Process Overview Step 2. Transform Data Step 1. Select Data Step 3. Store Data Step 4. Transfer Data Step 5. Deploy Data Interaction Center BW CRM ã SAP AG 2003, APD / Ramine Eskandari 11 Campaigns

APD - Example Select Source for your Data Read Data from any Info. Provider ã SAP AG 2003, APD / Ramine Eskandari 12

APD - Example Transform your Data Merge Business Partners from Two Different Sources Select Specific Business Partners ã SAP AG 2003, APD / Ramine Eskandari 13

APD - Example Store your Data Preview Data ã SAP AG 2003, APD / Ramine Eskandari 14 Store Data in a Transactional ODS Object

APD - Example Transfer your Data ã SAP AG 2003, APD / Ramine Eskandari 15 Select a CRM System

APD - Example Deploy your Data ã SAP AG 2003, APD / Ramine Eskandari 16

Further Information è CRM Training Course CR 900 and TACRM 6 (Partner) è my. SAP CRM Analytics SAPNET Alias: CRM-Analytics è Direct contact: CRM Product Management: Ramine. Eskandari@sap. com Stefan. Kraus@sap. com ã SAP AG 2003, APD / Ramine Eskandari 17