Transcript SAS Accessing SAP R/3 Features

Richard Foley
Product Manager SAP Integration
Copyright © 2005, SAS Institute Inc. All rights reserved.
Copyright © 2005, SAS Institute Inc. All rights reserved.
Understand and Deploy
Deploy
With
SAP
Copyright © 2005, SAS Institute Inc. All rights reserved.
Business
Process
Understand
With
SAS
SAS OLAP Viewer
SAS Enterprise Guide
Agenda
SAP
Stored Process
SAS
Web
Services
SOAP, XML
etc
SAS
ODBO
SAP XI
SAP BW
SAP R/3 Data
Data
Access
-QueryCubes
-InfoCubes
-ODS
RFC
Workspace Server
SAS Metadata
Metadata
Cache
Data
Surveyor
Copyright © 2005, SAS Institute Inc. All rights reserved.
SAP
MetaData
Repository
SAP R/3 Integration
SAP
SAS
Stored Process
SAS
Web
Services
SAP R/3 Data
Data
Access
RFC
Workspace Server
SAS Metadata
Metadata
Cache
Data
Surveyor
Copyright © 2005, SAS Institute Inc. All rights reserved.
SAP
MetaData
Repository
SAS Accessing SAP R/3
Features
Key Benefits
 Full access to all data
structures
 Granularity of the data is at
the detail level
 Direct access to SAP
metadata.
 Ability to access any and all
SAP environments
 Ability to combine R/3 data
with non SAP data
 Supports standard
SAP logon
authorization
 Automatically adheres to
existing SAP security rules
for user access to data
 Unix & Windows platforms
 Flexibility for architect
Copyright © 2005, SAS Institute Inc. All rights reserved.
Real-Time Data Quality
SAP Client
DFClent
Transactional
Data
Copyright © 2005, SAS Institute Inc. All rights reserved.
DFServer
SAS Solution Integration Architecture
Example SAP
SAS Solution
SAP R/3
Copyright © 2005, SAS Institute Inc. All rights reserved.
HCM
FM
SRM
ABM
ITM
SPM
SAS® Solution Adapters for SAP
Features
Key Benefits
 ETLQ routines are predefined and
customizable
 Fast answers to
questions about your
customers, suppliers
and internal
organization.
 Automates building of
data model for
corresponding SAS
Solution
 Ability to enrich SAP
data with non SAP data
 SAP data sources are
pre-defined
 Ensures decision
makers have the
information required to
make decisions based
on real facts
Copyright © 2005, SAS Institute Inc. All rights reserved.
 Quick implementation
e.g. weeks not months
SAS OLAP Viewer
SAS Enterprise Guide
SAP BW Integration
SAP
ODBO
SAS
Stored Process
SAS
Web
Services
SAP BW
-QueryCubes
-InfoCubes
-ODS
Data
Access
RFC
Workspace Server
SAS Metadata
Copyright © 2005, SAS Institute Inc. All rights reserved.
Metadata
Cache
Data
Surveyor
SAP
MetaData
Repository
Infocube to Star Schema
Copyright © 2005, SAS Institute Inc. All rights reserved.
SAS Accessing SAP BW
Features
Key Benefits
 Full access to
InfoCubes and ODS
Objects
 Fast answers to questions
about your customers,
suppliers and internal
organization.
 Direct access to SAP
metadata
 Supports standard
SAP logon
authorization
 Unix & Windows platforms
Copyright © 2005, SAS Institute Inc. All rights reserved.
 Ability to enrich SAP BW with
non SAP data
 Automatically adheres to
existing SAP security rules
for user access to data
 Supports SAP BAPIs
 Flexibility for architect
Advanced Analytics integrated with
Reporting





Forecasting
Data Mining
Optimization
Design of Experiments
Integrated With MSOffice
Copyright © 2005, SAS Institute Inc. All rights reserved.
Netweaver Integration
Stored Process
SAS
Web
Services
Data
Access
SOAP, XML
etc
SAS
SAP
SAP XI
SAP BW
SAP R/3 Data
-QueryCubes
-InfoCubes
-ODS
Workspace Server
SAS Metadata
Metadata
Cache
Data
Surveyor
Copyright © 2005, SAS Institute Inc. All rights reserved.
SAP
MetaData
Repository
SAP
Netweaver
SOAP
Web
Service
SAP XI
Portal
HTTP
(middle tier
Java or .Net
code)
Copyright © 2005, SAS Institute Inc. All rights reserved.
SAS Server
IOM
(ie, SAS Stored
Process Server
or SAS
Metadata
Server)
Case Study – Manufacturing
Pro-Active Business Intelligence
Execute
Track
ERP
What
Happens If
Intelligence
Platform
Model
Analyze
Why Did It
Happen
What
Happened
Goals

Lower Inventory Overhead

Improve Product Quality Control

Improve Global Sales Force Operations
Challenges
US Disparate Data Sources
Europe ?
Asia Pacific ?
SAP R/3
SAP BW
R/3 System
Compliance System
Legacy Data
External Data
Other Data Sources
Intelligent Architecture
Operational Systems
Enterprise Data
Warehouse
Cleanse Data During ETL
Open Meta Data Repository
Intelligent Architecture
Operational
Systems or
ODS
Analytical Cube
Power User
Statistician
Analyst
Enterprise Data
Warehouse
Data Mart
Open Meta Data Repository
Business
Users
Results

Improve Operational Efficiency

Decrease Shelf Inventory

Impowered sales force with shelf-life management
by predicting parishable products shelf life

Increase production quality with data mining to
obtain new 6 Sigma measurements.
It’s not SAS or SAP, but SAS and SAP
Kimberly-Clark Europe
Issy Aydiner, Finance Director Supply Chain
“SAS is the industry standard in this area. It’s also easy-to-use and has good
reporting capabilities. With SAS at the heart of the solution, we can do all
the supply chain modeling, simulation and planning we need.
SAS is used for the ‘top down’ part of the process: taking numbers from
the General Ledger and breaking these numbers down into unit costs: for
example, costs related to storage locations. This data then feeds into the
SAS Value Chain Analytics application, along with data from SAP R/3,
which covers the ‘bottom up’ part of the process.
The combination of the two approaches is unique and provides KimberlyClark Europe with accurate and actionable cost information at all levels of
the business.
Questions