slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
mySAP CRM Detailed View CRM Analytics: Analysis Process Designer (Release BW 3.2) PowerPoint Presentation
Download Presentation
mySAP CRM Detailed View CRM Analytics: Analysis Process Designer (Release BW 3.2)

Loading in 2 Seconds...

play fullscreen
1 / 17

mySAP CRM Detailed View CRM Analytics: Analysis Process Designer (Release BW 3.2) - PowerPoint PPT Presentation


  • 175 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'mySAP CRM Detailed View CRM Analytics: Analysis Process Designer (Release BW 3.2)' - ashlyn


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
analysis process designer
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
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
APD – Single Data Process
  • Combine different steps into a single data process

Source 1

Target

Source 2

Filter

Add

Merge

Data Process

apd architecture
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

slide7

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:

slide8

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

slide9

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

slide10

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
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
APD - Example

Select Source for your Data

Read Data from any InfoProvider

apd example1
APD - Example

Transform your Data

Merge Business Partners from Two Different Sources

Select Specific Business Partners

apd example2
APD - Example

Store your Data

Store Data in a Transactional ODS Object

Preview Data

apd example3
APD - Example

Transfer your Data

Select a CRM System

apd example4
APD - Example

Deploy your Data

further information
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

è