- ITtestpapers.com
Download
Report
Transcript - ITtestpapers.com
mySAP 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
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
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.
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
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
InfoProvider
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 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
Data Targets:
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
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
01/2001
01/2001
11/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
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
InfoProvider
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
CR900 and TACRM6 (Partner)
mySAP CRM Analytics
SAPNET Alias: CRM-Analytics
Direct contact:
CRM Product Management:
[email protected]
[email protected]
SAP AG 2003, APD / Ramine Eskandari 17