170 likes | 398 Views
mySAP CRM Detailed View CRM Analytics: Analysis Process Designer (Release BW 3.2). CRM Analytics Architecture. 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
E N D
mySAP CRMDetailed View CRM Analytics:Analysis Process Designer (Release BW 3.2)
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
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
APD – Single Data Process • Combine different steps into a single data process Source 1 Target Source 2 Filter Add Merge Data Process
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
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:
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
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
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
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
APD - Example Select Source for your Data Read Data from any InfoProvider
APD - Example Transform your Data Merge Business Partners from Two Different Sources Select Specific Business Partners
APD - Example Store your Data Store Data in a Transactional ODS Object Preview Data
APD - Example Transfer your Data Select a CRM System
APD - Example Deploy your Data
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 è