1. technology and computing
2. enterprise technology
3. enterprise resource planning

ASUG Orlando
Why should we buy and implement
BI, BOBJ, BPC and HANA?
May 14-16, 2012
[ JUERGEN LINDNER
SAP POINT OF CONTACT
MEMBER SINCE: 1998
[Edmund Manrique
Vice President
TekLink International
[ LINDA WILSON
ASUG INSTALLATION MEMBER
MEMBER SINCE: 1999
[ ATUL PATANKAR
ASUG INSTALLATION MEMBER
MEMBER SINCE: 2000
[
Presentation Abstract:
Why should we buy and
implement BI, BOBJ, BPC and
HANA?
How do we know if it is worth
our investment of time and
resources? As a extremely high
volume distributor, we need to
quantify our real returns before
starting.
Real Experience. Real Advantage.
2
[
We want to share our experience as a universal case study on
nderstanding and howe we quantifying the value of BW, BOBJ, Data
Services, BPC, and HANA . We will explain and demonstrate:
•
Fact finding and clarification process
•
Scoring and quantification of pain points and benefit
Prioritizing initiatives, while doing due diligence on multiple solutio
Understand what HANA to use. BW for HANA, ECC for HANA, RD
for HANA
Real Experience. Real Advantage.
3
[
Three things attendees will learn:
Assessment what to implement first, and to assess the right
scope and roadmap
Measuring Value for a BI, BPC and HANA
 Solution. What tools can be used to quantify value.
Share our lessons Learned both from the business and the
technology.

Real Experience. Real Advantage.
4
[ Agenda
 SAP BO Data Services with SAP ECC Use Cases
 Extract from SAP ECC to Non-SAP Table
 Load Data from Non-SAP Table to SAP ECC
 SAP BO Data Services with SAP BW Use Cases




Extract from SAP BW to Non-SAP table
Extract from Non-SAP table and Load to SAP BW (with Delta)
Extract from SAP and Non-SAP, in a single flow and load to SAP BW
Web Service Push Based Real-time Data Acquisition from BO DS Source in SAP BW
 SAP BO Data Services with SAP HANA Use Cases
 Load Non-SAP Data to SAP HANA
 Load SAP ECC Data to SAP HANA
 Q&A
Real Experience. Real Advantage.
5
[ Data Services and SAP ECC (Connectivity Options)
Connectivity options available in Data Services 3.x
ABAP Dataflow
 Generates and executes an ABAP program on the SAP Application Server that reads data
from an SAP table and outputs that data to a staging file.
 Requires the configuration of an access/transfer mechanism (e.g. shared directory/FTP)
Remote Function Call (RFC) Read Table
 An RFC is made to read the contents of an SAP table
 For very small datasets only (<1000 records)
RFC/BAPI function calls
 For lookups, not for mass data transfer
 For very small datasets only
IDOCs
New in Data Services 4.0
Business Content Extractors (Data Sources)
 Can support Delta With the ODP Data Replication API (for those Business Content
Extractors that support it)
Real Experience. Real Advantage.
6
[ Extract Data from SAP ECC (Extractor)
Define a Batch Job.
Use Query Transform to Map
Source fields to Target
Use ECC Extractor as Source
Use SQL Table as Target
Data Flow
Sales Data Extraction form SAP ECC to Non-SAP Table
Real Experience. Real Advantage.
7
[ Extract Data from SAP ECC (Table)
Data Flow
Steps:
1.
2.
3.
4.
Define a Batch Job.
Define ECC Table as Source
Create the target SQL Table and use it as Target in the Data Flow
Use Dataservices Query Transform and map source fields to target
Extract Customer Table from ECC to Non-SAP Table (Directly)
Real Experience. Real Advantage.
8
[ Load Data in a Custom Table in ECC (IDOC)
 Data Flow
Steps:
1.
2.
3.
4.
Define a Batch Job.
Define ECC IDOC as Target
Use Dataservices Query Transform
Use Row_Generation Transform to generate one IDCO per Row
Load Non-SAP Table Data to ECC using IDOC
Real Experience. Real Advantage.
9
[ Load Data in a Custom Table in ECC (RFC)
In SAP ECC (Create a Custom RFC on a Table)
Steps:
1. Define a Batch Job.
2. Use Dataservices Query Transform to Call the RFC Function
Load Non-SAP Table Data to ECC using RFC
Real Experience. Real Advantage.
10
[ Extract from SAP BW to Non-SAP table
In SAP BW
1. Use DSO (DataStore Object) as source
2. Create a Open Hub Destination as Third-Party Destination Type
• Specify RFC Destination to connect to DataServices
3. Field Definitions are pulled from DSO
4. Define a DTP (with mapping from DSO to Open Hub Destination)
5. Create a Process Chain to Run the DTP
In Data Services Designer
1. Create a DataStore with SAP BW as Source
2. Import Open Hub in DataServices
3. Build Batch Job and Data Flow with Open Hub as Source and SQL
Table as Target
4. Set the Attribute ‘Web_Service_Enabled’ as YES for the Batch Job
Real Experience. Real Advantage.
11
[ Extract from SAP BW to Non-SAP table
Data Flow
In the Open Hub, Select Open Hub table and Process Chain name
Real Experience. Real Advantage.
12
[ Load Data from Non-SAP table to SAP BW
In SAP BW
1. Create a new DataSource Under ‘DataServices System’ with
• DataServices Repository Name
• DataServices Job Server Name
• DataServices RFC Destination Program ID
• Define the Fields manually
2. Define an Info Package on DataServices DataSource
• Specify the DataServices Job Name
In Data Services
1. Define a Batch Job.
2. Create SQL Server Table to Store the Status of Load with Timestamp
3. Create a Workflow with function to get Last good upload Timestamp
and pass it to the Job for Extracting Delta
4. Create a Dataflow with KNA1_SQL table in SQL Server as Source and
BW DataSource as Target
Real Experience. Real Advantage.
13
[ Load Data from Non-SAP table to SAP BW
Timestamp based Delta Mechanism
Work Flow
Function in Workflow to Get and Update the Upload Status and Timestamp
Can also use Data Services ‘Table Comparison’ Transform to generate
Delta (Refer to DS Reference Guide for details)
Real Experience. Real Advantage.
14
[ Load data from ECC and Non-SAP to SAP BW
Data Flow
Specify Join
Real Experience. Real Advantage.
15
[ Data Push to SAP BW using Web Service
In SAP BW
1. Create a Web Services Data Source with Real-time Data Acquisition Supported
• Define the fields
• Upon Activation, it creates a RFC function based Web Service in BW
2. Get the WSDL for the Web Service using transaction WSADMIN
[http://tli-101.tli.com:50004/sap/bc/srt/rfc/BIC/CQZASJ_WS00001000?wsdl]
3. Create a DSO and DTP to transform and load the Data
4. Setup Daemon for the Real-time Data Acquisition
In Data Services Designer
1. Create a Web Service based DataStore with the WSDL from SAP BW
2. Create a Batch Job with two Query transforms and a Row_Generation transform
• One Query Transform to create nested XML structure needed to be passed to
the Webservice Function
• Other Query Transform to map nested values to the Web Service function
• Use Row_Generation Transform to create one Web Service function call per
row in the Source Data Store
3. Add a Schedule for the Batch Job in Data Services Management Console
Real Experience. Real Advantage.
16
[ Data Push to SAP BW using Web Service
Web Service Push based RDA Data Source in BW
Real Experience. Real Advantage.
17
[ Data Push to SAP BW using Web Service
Data Flow
Map Nested Data to Webservice Function Call
Real Experience. Real Advantage.
Dummy File to See
the output of the Web
Service call
18
[ Load Non-SAP Data to SAP HANA
Load a table from MS SQL Server Database to SAP HANA
1.
2.
3.
4.
5.
Create an ODBC Data Store in DS to Connect to MS SQL Server DB
Create an ODBC Data Store in DS to Connect to SAP HANA DB
Create a Batch Job in DS to load data from SQL Server Table (OH_BILL) to SAP HANA
using Template Table in HANA Data Store as Target
Execute the Bath Job
Verify the Table and Data in SAP HANA
Data Flow
* You can use Template Table if you want to create
exact same table structure as the Source Table
Real Experience. Real Advantage.
19
[ Load Non-SAP Data to SAP HANA
Verify Data Structure & Data in SAP HANA
Real Experience. Real Advantage.
20
[ Load SAP ECC Data to SAP HANA
Steps by Step
Import
SAP
metadata
via Data
Services
into
HANA
Create a
connection
to an SAP
target
system
Import SAP
metadata
into Data Services
Real Experience. Real Advantage.
Create a
Data
Services
job to
load
HANA
Import HANA
metadata back into
Data services
Preview
uploaded data
in HANA
Execute a Data
service job to
load HANA
21
[ Load SAP ECC Data to SAP HANA
In HANA Studio
Configure Import Server with Data Services server
 Specify the Data Services Host (IP Address)
 Specify the Data Services Repository Name
Import the Meta Data for the Table using DS Connection
 Select the Target HANA System to Import Meta Data to
 Select The Source Connection (Automatically displays SAP Connections from Data
Services which was configured in Previous Step – Import Server Configuration)
Real Experience. Real Advantage.
22
[ Load SAP ECC Data to SAP HANA
Data Flow
Verify Data in HANA
Real Experience. Real Advantage.
23
[
BI Strategy &
Roadmap
Real Experience. Real Advantage.
TekLink’s Proprietary Roadmap Fishbone
[
ROADMAP APPROACH
TekLink’s Roadmap Fishbone takes the client’s unique situation against our evaluation tools to evaluate the
proper approach leveraging SAP Tools and applications including cutting edge technologies such as HANA,
Mobility, SBO (Dashboards, Advanced Analysis, WebI, Crystal Reports, Data Services) and BPC.
Real Experience. Real Advantage.
TekLink’s Proprietary Methodology: BI Roadmap
[
DATA GATHERING
STRATEGY
PROCESS
INFORMATION SYNTHESIS
TECHNOLOGY
STRATEGY
• Interviews with key executives of the client to
identify the key strategic drivers for the company’s
future success.
• Understand the overriding Company pain-points
from a business and / or information technology
perspective.
•
Understand current limitations and / or speed
bumps preventing company from reaching it’s
business goals due to software and technology
limitations or it’s implementation limitations
• Understand key executive expectations of IT and
SAP given current or future software purchase
plans (see SAP Bill of Materials section) or in cases
where the implementation may not have net met
the full ROI as the business may have expected.
Real Experience. Real Advantage.
SAP Bill of
Materials
(Optional)
DETAILED
ASSESSMENT
(some docs
optional)
FINAL
ROADMAP
TekLink’s Proprietary Methodology: BI Roadmap
[
DATA GATHERING
PROCESS
STRATEGY
INFORMATION SYNTHESIS
TECHNOLOGY
PROCESS
• Interviews with the levels underneath the key
executives of the client to identify the key
Operational and Tactical drivers for the
company’s future success.
•
Understand the overriding Company painpoints from a business and / or information
technology perspective.
•
Understand current limitations and / or speed
bumps preventing company from reaching it’s
business goals due to software and technology
limitations or it’s implementation limitations
• Understand the expectations of IT and SAP
given current or future software purchase plans
(see SAP Bill of Materials section) or in cases
where the implementation may not have net met
the full ROI as the business may have expected.
Real Experience. Real Advantage.
SAP Bill of
Materials
(Optional)
DETAILED
ASSESSMENT
(some docs
optional)
FINAL
ROADMAP
TekLink’s Proprietary Methodology: BI Roadmap
[
DATA GATHERING
STRATEGY
PROCESS
INFORMATION SYNTHESIS
TECHNOLOGY
TECHNOLOGY
• Understand the SAP technology ‘in-play’
for the client, namely:
• Roadmap may be based off of
current shelf-ware
• Roadmap may be based off of
future software purchase plans (see
SAP Bill of Materials section)
• Roadmap may include latest SAP
Technology or heavily hardware
influenced technology such as HANA
or ‘in-memory’ applications
•
Given technology ‘in-play’ and guidance
of client, evaluate technology strengths and
weaknesses with respect to client strategy,
goals, and pain-points
Real Experience. Real Advantage.
SAP Bill of
Materials
(Optional)
DETAILED
ASSESSMENT
(some docs
optional)
FINAL
ROADMAP
TekLink’s Proprietary Methodology: BI Roadmap
[
DATA GATHERING
STRATEGY
PROCESS
INFORMATION SYNTHESIS
TECHNOLOGY
SAP Bill of Materials
• Where an appropriate option, Roadmap
may be based off of future software
purchase plans (see SAP Bill of Materials
section)
• An evaluation of alternate SAP Bill of
Material applications may be done from a
TCO point of view as well as a pro / con
evaluation of the various software
alternatives. E.g.:
• BW on HANA vs.
• BWA vs.
• HANA RDS solutions vs.
• HANA OLTP vs.
• …..
•
Working with SAP Sales or Value
Engineering is assumed.
Real Experience. Real Advantage.
SAP Bill of
Materials
(Optional)
DETAILED
ASSESSMENT
(some docs
optional)
FINAL
ROADMAP
TekLink’s Proprietary Methodology: BI Roadmap
[
DATA GATHERING
STRATEGY
PROCESS
INFORMATION SYNTHESIS
TECHNOLOGY
DETAILED ASSESSMENT
•Taking all the previous interviews and data
points, various proprietary calculations are
undertaken.
• A qualitative analysis is performed using
Harvey Balls weighing.
• Where work is done in tandem with SAP
VE, hard ROI numbers will be used as part
of the calculation for the project
prioritization matrix (quantitative).
•
Where possible dual plotting can provide
an effective message for a prioritization
matrix of direct (quantitative) and indirect
(qualitative) analysis.
• The prioritization matrix then becomes the
basis for the Final Roadmap
recommendation and sequence of projects
providing the most ROI
Real Experience. Real Advantage.
SAP Bill of
Materials
(Optional)
DETAILED
ASSESSMENT
(some docs
optional)
FINAL
ROADMAP
TekLink’s Proprietary Methodology: BI Roadmap
[
DATA GATHERING
STRATEGY
PROCESS
INFORMATION SYNTHESIS
TECHNOLOGY
FINAL ROADMAP
• With a final combination of deliverables
from the other sections, a Final Roadmap
recommendation of SAP Tools, Projects,
Sequencing, Constraints, along with TCO is
presented and backed up with analysis and
corresponding data.
•
The Final Roadmap recommendation is
not done in isolation but in fact as part of a
collaboration with the client itself. This is
key as a recommendation cannot be
effective without multiple iterations and
dialogue with the client.
Real Experience. Real Advantage.
SAP Bill of
Materials
(Optional)
DETAILED
ASSESSMENT
(some docs
optional)
FINAL
ROADMAP
[
Sample HANA + SBO Deliverables
and Architecture
Real Experience. Real Advantage.
Tool Evaluation – In-memory analytics
Options with BI Suite (BOBJ)
[
BI Foundation Options
Pros
Cons
A. HANA
B. BW on HANA
C. BW as EDW + BWA
Options with BEx
D. BW as EDW
+ SAP RDS Solutions (side car)
E. Bare Bones
(‘In-Memory’ Solution Only - BWA or BW on HANA
using BEx front-end.
No BI Suite / BOBJ).
F. No additional Software for BW implementation
Tool Evaluation
• HANA Options are explored taking into consideration Client Financial, Business or
Technology Constraints.
• Once a Foundation of viable options is chosen, pros and cons related to the clients specific
situation are analyzed
Real Experience. Real Advantage.
TCO Calculation – In-memory analytics
[
Options with BEx
Options with BI Suite (BOBJ)
BI Foundation Options
HW
Cost
License
Cost
Maint.
Cost
Implementation Cost
2012
2013
2014
AMS Costs
2012
2013
2014
A . HANA
B. BW on HANA
C. BW as EDW + BWA
D. BW as EDW
+ SAP RDS Solutions (side
car)
E. Bare Bones
(In Memory Solution Only
i.e. BWA or BW on HANA.
No BI Suite / BOBJ).
F. No additional Software
for BW implementation
TCO Assessment:
• Each HANA Option are explored taking into consideration Client Financial, Business or
Technology Constraints from a TCO point-of-view.
• TekLink works with the client to complete the TCO matrix according to the evaluation criteria
needed for an ROI or Cost/Benefit Project Assessment
Real Experience. Real Advantage.
Tool Evaluation – Front-Ends
A. BI Suite (BOBJ)
WebI
Maturity
C W R
F
x
Users
x
x
x
All
x
x
x
Executive / Management
x
x
x
Power Users
x
x
x
Consumers
Crystal
x
x
Consumers
Mobile
x
x
All
Dashboards
Analysis (Office Version)
x
Analysis (Web Version)
B. BEx
BEx Analyzer (Excel Version)
Maturity
R
F
x
x
x
x
All
x
x
x
Consumers
x
x
x
All
x
x
Executive / Management
BEx Web Analyzer
BEx Broadcaster
BEx Web Application Designer
Real Experience. Real Advantage.
Users
C W
x
2012
2013
2014
…
2012
2013
2014
…
Move to
BOBJ
[
Tool Evaluation – Additional Options
[
Additional Options
Maturity
C W R
A. SBO Accelerated Explorer
Users
F
x
Analysts
x
x
Developers
x
x
x
IT
D. Integrated Planning (Build it in to
BW)
x
x
x
All But IT built/IT owned
E. SAP BusinessObject Planning and
Consolidation (BPC)
x
x
x
All But IT + Business
built/ Business owned
B. Data Services
C. NLS
Additional Options
A. SBO Accelerated Explorer
B. Data Services
C. NLS
D. Integrated Planning (Build it in to
BW)
E. SAP BusinessObject Planning and
Consolidation (BPC)
Real Experience. Real Advantage.
x
Pros
2012
2013
2014
Cons
…
HANA - Hardware Sizing & Architecture
[
As part of the assessment, you may choose to have our
Technology COE define your HANA hardware sizing and
architecture.
Real Experience. Real Advantage.
SBO - Hardware Sizing & Architecture
[
As part of the assessment, you may choose to have our
Technology COE define your SBO hardware sizing and
architecture.
Real Experience. Real Advantage.
[
 Thank you.
Real Experience. Real Advantage.
39