eim solution architecture for bi - sap

90
Jan Rauscher, Jan Fetzer, Customer Insight & Action, Solution Management - Field Enablement April 2011 EIM Solution Architecture for BI A guide to help customers leverage the full potential of SAP EIM solutions

Upload: others

Post on 17-May-2022

6 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: EIM Solution Architecture for BI - SAP

Jan Rauscher, Jan Fetzer,

Customer Insight & Action, Solution Management - Field Enablement

April 2011

EIM Solution Architecture for BI A guide to help customers leverage the full potential of SAP EIM solutions

Page 2: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 2

Legal Disclaimer

This presentation outlines our general product direction and should not be

relied on in making a purchase decision. This presentation is not subject to

your license agreement or any other agreement with SAP. SAP has no

obligation to pursue any course of business outlined in this presentation or

to develop or release any functionality mentioned in this presentation. This

presentation and SAP's strategy and possible future developments are

subject to change and may be changed by SAP at any time for any reason

without notice. This document is provided without a warranty of any kind,

either express or implied, including but not limited to, the implied warranties

of merchantability, fitness for a particular purpose, or non-infringement. SAP

assumes no responsibility for errors or omissions in this document and shall

have no liability for damages of any kind that may result from the use of these

materials, except if such damages were caused by SAP intentionally or

grossly negligent.

Page 3: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 3

The EIM Solution Architecture Guide for BI Guide will:

Provide a comprehensive view on how to leverage and deploy SAP EIM solutions

to support customer analytics and business intelligence strategy

Discuss how to incrementally execute this strategy along a clear growth path,

realizing added value along every step

Propose typical deployment patterns based on best practices and real-world

project experiences

Target Audience

Anyone interested in learning how SAP„s EIM solutions can be best leveraged

while implementing an analytics & business intelligency strategy

Enterprise Information Management Solution Architecture for BI

Page 4: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 4

Data Integration & Quality Management

SAP BusinessObjects Data Services 4.0

SAP BusinessObjects Information Steward 4.0

EDW and Data Marts

SAP NetWeaver Business Warehouse 7.3

SAP NetWeaver BW Accelerator 7.20

SAP HANA 1.0

Sybase IQ 15.2 (basic scenarios)

SAP BusinessObjects Rapid Marts XI 3.2, version for SAP Solutions

RapidDecision® Rapid Marts for Oracle, JD Edwards and PeopleSoft

Master Data Management

SAP NetWeaver Master Data Management 7.1

SAP Master Data Governance (part of SAP ERP 6.0 EhP5)

SAP EIM Solutions considered in this Guide

Page 5: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 5

Data Integration & Quality Management

SAP Data Migration Services

Content & Information Lifecycle Management

SAP NetWeaver Information Lifecycle Management

SAP Extended ECM by Open Text

SAP Document Access by Open Text

SAP Archiving by Open Text

SAP Digital Asset Management by Open Text

SAP EIM Solutions NOT considered in this Guide (yet)

Page 6: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 6

How to read this Guide

This guide proposes 5 customer landscape archetypes

Each archetype is defined by a) the type of enterprise applications used and b) the

data warehousing strategy

Landscape

archetypes

For each recommendation, growth options are discussed, highlighting those SAP

EIM solutions that best complement the solutions that are at the core of the

recommendation

Growth

options

Pick the landscape that best matches your current landscape

Jump directly to that landscape. Skip all other slides.

Customer

landscape

For each landscape archetype, we distinguish different goals (“business drivers”)

that customers may want to achieve

For each goal, we recommend the EIM products best suited to fulfill it

Pick the recommendation that best matches your business need. Jump to it.

Customer

business need

Each recommendation is depicted clearly as an architectural graphic, showing what

SAP EIM solutions are added and how they interact with the rest of the landscape

The value realized through each recommendation is discussed in detail

Value in detail

Page 7: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 7

How to navigate in this Guide

Click to jump to this landscape type

Click to jump to this

recommendation Click to jump back to

recommendation overview

Page 8: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 8

EIM Solution Architecture for BI

Categorization of Customer System Landscapes

non-SAP systems

only

SAP systems only SAP and non-SAP

systems

No

datawarehouse

strategy

System Landscape

Type 1

System Landscape

Type 2

Non-SAP

datawarehouse System Landscape Type 3

SAP BW not considered System Landscape Type 4

SAP BW for SAP

data,

non-SAP DWH for

non-SAP data

not considered System Landscape Type 5

Enterprise Application Systems

Da

taw

are

ho

usin

g S

tra

teg

y

Page 9: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 9

EIM Solution Architecture for BI

Categorization of Customer System Landscapes

non-SAP systems

only

SAP systems only SAP and non-SAP

systems

No

datawarehouse

strategy

System Landscape

Type 1

System Landscape

Type 2

Non-SAP

datawarehouse System Landscape Type 3

SAP BW not considered System Landscape Type 4

SAP BW for SAP

data,

non-SAP DWH for

non-SAP data

not considered System Landscape Type 5

Enterprise Application Systems

Da

taw

are

ho

usin

g S

tra

teg

y

Page 10: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 10

Assumptions on current customer landscape Assumptions

Bottom-Line:

Operational reporting directly on top of the

enterprise systems in an entirely non-SAP

application landscape

Landscape Assumptions:

Customer has no explicit data warehousing

strategy

Direct connectivity between backend and BI

layer

No assumption on BI Tool Suite used

No ETL tool required

Backend landscape does not consist of any

SAP applications

Reporting might not cover all available

backend-data

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP

non-

SAP

non-

SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 11: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 11

SAP BusinessObjects Data Services 4.0

RapidDecision® Rapid Marts for Oracle, JD Edwards and PeopleSoft

SAP BusinessObjects Information Steward 4.0

SAP NetWeaver Master Data Management 7.1

Sybase IQ 15.2

Relevant SAP EIM Solutions for this customer landscape

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 12: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 12

Overall Recommendation

Business Driver Recommendation

Build a trusted reporting layer for your

business

Build an accelerated data warehouse

with Data Services & Sybase IQ

Improve reporting quality through

centrally governed master data

Manage your master data with

SAP NetWeaver Master Data

Management 7.1

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 13: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 13

Recommendation 1: Build an accelerated data warehouse

with Data Services 4.0 & Sybase IQ 15.2 Baseline

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

any database

(Sybase IQ 15.2

recommended)

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP non-

SAP

non-

SAP

Data Services 4.0 is a comprehensive Data Quality & high-end ETL solution that allows customers to

efficiently build the foundation for their data warehouse.

Any database could be used as reporting layer here, but we recommend Sybase IQ 15.2 for huge

acceleration of the data warehouse on low-cost standard hardware, while scaling linearly for high user load.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP

non-

SAP

non-

SAP

Data Services 4.0

Page 14: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 14

any database

(Sybase IQ 15.2

recommended)

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP non-

SAP

non-

SAP

The data warehouse is best leveraged by

adopting Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all

enterprise data assets.

Note: To accelerate implementation, pre-built content from SAP Partner RapidDecision® can be leveraged,

if Oracle, JD Edwards and PeopleSoft is your ERP system.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP

non-

SAP

non-

SAP

Data Services 4.0

Recommendation 1: Build an accelerated data warehouse

with Data Services 4.0 & Sybase IQ 15.2 Growth Options

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

any database

(Sybase IQ 15.2

recommended)

Pre

-bu

ilt co

nte

nt

by S

AP

pa

rtne

rs

Info

rma

tion

Ste

wa

rd 4

.0

Page 15: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 15

SAP NetWeaver MDM 7.1 is geared to consolidate, harmonize and centrally manage master data in SAP and

heterogeneous environments. After redistribution of consolidated master data into the source systems the quality

of the reports will be improved.

To accelerate implementation, pre-built content & predefined services of the SAP NetWeaver MDM Rapid

Deployment Solution (RDS) for customer data integration (CDI) can be used.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP non-

SAP

non-

SAP SAP NetWeaver

Master Data Management 7.1

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP non-

SAP

Recommendation 2: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Baseline

non-

SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 16: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 16

Recommendation 2: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Growth Options

SAP NetWeaver MDM 7.1 is best complemented by

establishing a data warehouse as trusted reporting layer. This will help leverage the master data initiative beyond the

transactional realm, also reporting and analytics is best realized by using Data Services 4.0 and

Sybase IQ 15.2 (see recommendation 1). Optionally, pre-built partner content and Information Steward 4.0 can be

used. The data warehouse can be integrated with MDM 7.1 via the MDM connector and serve as the master data

source and as the distribution target.

Data Services 4.0 fully integrates with SAP NetWeaver MDM 7.1 for improved matching, validating & loading.

SAP NetWeaver Business Process Management 7.2 complements MDM 7.1 for collaborative data creation processes.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP non-

SAP

non-

SAP

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP

non-

SAP

SAP NW

BPM 7.1

Info

rma

tion

Ste

wa

rd 4

.0

Pre

-bu

ilt co

nte

nt

by S

AP

pa

rtne

rs SAP NW

MDM 7.1

Data

Services

4.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

non-

SAP

any database

(Sybase IQ 15.2 recommended)

Page 18: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 18

EIM Solution Architecture for BI

Categorization of Customer System Landscapes

non-SAP systems

only

SAP systems only SAP and non-SAP

systems

No

datawarehouse

strategy

System Landscape

Type 1

System Landscape

Type 2

Non-SAP

datawarehouse System Landscape Type 3

SAP BW not considered System Landscape Type 4

SAP BW for SAP

data,

non-SAP DWH for

non-SAP data

not considered System Landscape Type 5

Enterprise Application Systems

Da

taw

are

ho

usin

g S

tra

teg

y

Page 19: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 19

Assumptions on current customer landscape Assumptions

Bottom-Line:

Operational reporting directly on top of the

enterprise systems in a mixed landscape of SAP

and non-SAP application systems

Landscape Assumptions:

Customer has no explicit data warehousing

strategy

Direct connectivity between backend and BI

layer

Reporting-relevant system landscape consists of

SAP and non-SAP applications

Reporting might not cover all available backend-

data

No assumption on BI tools used

No ETL tool required

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 20: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 20

SAP BusinessObjects Data Services 4.0

SAP BusinessObjects Information Steward 4.0

SAP BusinessObjects Rapid Marts XI 3.2, Version for SAP Solutions

SAP NetWeaver Business Warehouse 7.3

SAP NetWeaver BW Accelerator 7.2

SAP NetWeaver Master Data Management 7.1

SAP Master Data Governance (part of SAP ERP 6.0 EhP5)

SAP HANA 1.0

Sybase IQ 15.2

Relevant SAP EIM Solutions for this customer landscape

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 21: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 21

Overall Recommendation (1/2)

Business Driver Recommendation

Flexibly analyze any volume of real-time

operational data with excellent

performance

Implement operational data marts with

SAP HANA 1.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Build a trusted, company-wide reporting

layer for your business

General Recommendation: Implement

an Enterprise Data Warehouse with

SAP NW Business Warehouse 7.3

Possible Exception: Deploy a data

warehouse based on Data Services 4.0

and Rapid Marts XI 3.2, version for SAP

solutions

Page 22: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 22

Overall Recommendation (2/2)

Business Driver Recommendation

Improve reporting quality through

centrally governed master data

Manage your master data with SAP NW

Master Data Management 7.1 or with

SAP Master Data Governance in SAP

ERP 6.05

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 23: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 23

Recommendation 1.1: Implement an Enterprise Data

Warehouse with SAP NetWeaver Business Warehouse 7.3 Baseline

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

SAP NetWeaver Business Warehouse is an integrated, scalable data warehousing platform delivering

best practice data warehousing processes that comprise business oriented modeling with pre-built

business content, reliable data acquisition, streamlined operations and a sophisticated life cycle

management.

With SAP NetWeaver BW 7.3, customer benefit from enhanced scalability & performance for faster

decision making, reduced TCO, improved development efficiency with simplified configuration und

operational management.

Solution Highlights (General Recommendation)

SAP NetWeaver

Business Warehouse 7.3

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

Page 24: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 24

Recommendation 1.1: Implement an Enterprise Data

Warehouse with SAP NetWeaver Business Warehouse 7.3 Growth Options

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

SAP NetWeaver BW 7.3 is best complemented with

SAP NetWeaver BW Accelerator 7.20 to reach the next level of performance

Data Services 4.0 to add flexibility in extracting non-SAP data and to boost data quality in SAP

NetWeaver BW, SAP ERP and non-SAP systems

Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all enterprise

data assets

Solution Highlights (General Recommendation)

SAP NetWeaver

Business Warehouse 7.3

BWA

7.20

Data Services 4.0

Info

rma

tion

Ste

wa

rd 4

.0

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

Page 25: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 25

any database

(Sybase IQ 15.2 recommended)

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

Data Services 4.0 is a comprehensive data quality & high-end ETL solution that allows customers to efficiently build a data

warehouse and custom data marts on variety of supported databases.

Rapid Marts XI 3.2, version for SAP Solutions, is pre-built content for SAP that jumpstart your data warehouse

implementation project and leverage best practices. Rapid Marts cover 11 functional areas in SAP ERP containing data

model, application mappings and BI content that can be immediately consumed by end-users and that fully integrate with

Data Services and SAP BusinessObjects BI.

Custom extensions or full data marts can be built easily due to the award-winning usability of Data Services 4.0.

For an entirely custom-built data warehouse or data mart, Sybase IQ 15.2 is the recommended database. It massively

accelerates the data warehouse on low-cost standard hardware, while scaling linearly for high user load.

Solution Highlights (Possible Exception)

Data Services 4.0 Rap

id M

art

s X

I 3

.2,

ve

rsio

n f

or

SA

P S

olu

tio

ns

Recommendation 1.2: Deploy a data warehouse based on

Data Services 4.0 and Rapid Marts XI 3.2 Baseline

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

Page 26: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 26

any database

(Sybase IQ 15.2

recommended)

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

The data warehouse is best leveraged by

adopting Information Steward 4.0 to to discover, assess, define, monitor and improve the quality of all

enterprise data assets.

Solution Highlights (Possible Exception)

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

Data Services 4.0

Ra

pid

Ma

rts X

I 3

.2,

ve

rsio

n f

or

SA

P S

olu

tio

ns

Recommendation 1.2: Deploy a data warehouse based on

Data Services 4.0 and Rapid Marts XI 3.2 Growth Options

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Info

rma

tion

Ste

wa

rd 4

.0

Page 27: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 27

Recommendation 2: Implement operational data marts

with SAP HANA 1.0 Baseline

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite

(SAP or non-SAP)

non-

SAP SAP SAP non-

SAP

With SAP HANA 1.0, customers can can instantly explore and analyze all of their transactional and analytical data from

virtually any data source in real time. Due to real-time replication, operational data from an SAP system can be captured in

memory as business happens. New business content provides immediate access to analytical models and can be flexibly

customized or efficiently developed from scratch.

To expand analysis across the entire organization, data from other systems can be added to analytical models with

Data Services 4.0.

SAP HANA 1.0 is non-invasive to the landscape and all other analytics activities can continue as before.

Note: The growth options for this landscape will build on the next version of HANA which is covered in the next version of

this guide.

Solution Highlights

SAP HANA

1.0

Data

Services 4.0

SBOP BI 4.0

& MS Excel

rea

l-tim

e ETL

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

Page 28: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 28

SAP NetWeaver MDM 7.1 is geared to consolidate, harmonize and centrally manage master data in SAP and

heterogeneous environments. After redistribution of consolidated master data into the source systems the quality

of the reports will be improved.

To accelerate implementation, pre-built content & predefined services of the SAP NetWeaver MDM Rapid

Deployment Solution (RDS) for customer data integration (CDI) can be used.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP SAP NetWeaver

Master Data Management 7.1

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

Recommendation 3.1: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Baseline

non-

SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 29: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 29

Recommendation 3.1: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Growth Options

SAP NetWeaver MDM 7.1 is best complemented by

establishing a data warehouse as the trusted reporting layer. This will help leverage the master data initiative beyond

the transactional realm also reporting and analytics is best realized by using SAP NetWeaver BW 7.3

(cp. recommendation 2). Optionally, Information Steward 4.0 can be used.

SAP NetWeaver BW 7.3 integrates tightly with MDM 7.1 to enable consolidated reporting, reduce cost and gain

competitive advantage through MDM-supported BW analysis scenarios (like vendor evaluation, global spend analysis,

top N customer analysis)

Data Services 4.0 fully integrates with SAP NetWeaver MDM 7.1 for improved matching, validating & loading.

SAP NW Business Process Management 7.2 complements MDM 7.1 for collaborative data creation processes.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

SAP NetWeaver

Business Warehouse 7.3

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP

non-

SAP

SAP NW

BPM 7.1

Info

rma

tion

Ste

wa

rd 4

.0

SAP NW

MDM 7.1

Data

Services

4.0

SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 30: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 30

Recommendation 3.2: Manage your master data with

SAP Master Data Governance in SAP ERP 6.05 Baseline

SAP Master Data Governance (MDG) is integral part of SAP ERP 6.0 EhP5 and features out-of-the-box, domain-

specific master data governance applications to centrally create, change and distribute master data with a focus

on SAP Business Suite. Supported domains are financial data, supplier data and material data. Replication to

SAP systems (even before ERP 6.0) is delivered out-of-the-box, the replication to non-SAP system is done via

enterprise services, ALE/iDocs, RFC or file. Leading MDG system is either an existing system or any newly set-

up ERP 6.05 system.

Note: Since SAP Master Data Governance does not support master data consolidation or harmonization, the key

value will be in streamlining business processes (operational MDM) while ensuring master data governance, with

only an implicit effect on enterprise reporting (analytical MDM).

Solution Highlights

SAP ERP

6.0 EhP5

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP non-

SAP

Page 31: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 31

Recommendation 3.2: Manage your master data with

SAP Master Data Governance in SAP ERP 6.0 Baseline

SAP Master Data Governance (MDG) is best complemented by these solutions:

SAP NW Process Integration 7.3 for 3rd party integration or complex system landscape management

SAP NetWeaver MDM 7.1 for enhancing MDG‟s consolidation capabilities

Enterprise Search (TREX) for search and duplicate check (mandatory for material)

SAP BusinessObjects Data Quality Management 4.0 for duplicate check & address validation

SAP BusinessObjects analytical dashboards for alternative UIs, replacing MDG‟s standard ALV lists

Solution Highlights

SAP ERP

6.0 EhP5

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP SAP

non-

SAP

BI Tool Suite (SAP or non-SAP)

En

terp

ris

e

Se

arc

h

SAP NetWeaver

PI 7.3

Dash-

boards

SAP NetWeaver

MDM 7.1

DQ

Mgmt

SAP non-

SAP

non-

SAP

SAP Master Data Governance (MDG) is best complemented by these solutions:

SAP NW Process Integration 7.3 for 3rd party integration or complex system landscape management

SAP NetWeaver MDM 7.1 for enhancing MDG‟s consolidation capabilities

Enterprise Search (TREX) for search and duplicate check (mandatory for material)

SAP BusinessObjects Data Quality Management 4.0 for duplicate check & address validation

SAP BusinessObjects analytical dashboards for alternative UIs, replacing MDG‟s standard ALV lists

Page 32: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 32

Where to learn more

Product/Solution Reference

SAP NetWeaver BW 7.3 BW 7.3 @ SAP Community Network

SAP NetWeaver BW

Accelerator 7.20

BWA 7.20 @ SAP Community Network

SAP HANA 1.0 In-Memory @ SAP Community Network

SAP NetWeaver Master

Data Management 7.1

MDM @ SAP Community Network

Rapid Deployment Solution for MDM 7.1

SAP Master Data

Governance

MDG @ SAP Community Network

SAP BusinessObjects

Data Services 4.0

Data Services 4.0 @ SCN

Data Services Wiki

SAP BusinessObjects

Information Steward 4.0

Information Steward @ SCN

SAP BusinessObjects

Rapid Marts XI 3.2, version

for SAP Solutions

Standard presentation @ SCN

Page 33: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 33

EIM Solution Architecture for BI

Categorization of Customer System Landscapes

non-SAP systems

only

SAP systems only SAP and non-SAP

systems

No

datawarehouse

strategy

System Landscape

Type 1

System Landscape

Type 2

Non-SAP

datawarehouse System Landscape Type 3

SAP BW not considered System Landscape Type 4

SAP BW for SAP

data,

non-SAP DWH for

non-SAP data

not considered System Landscape Type 5

Enterprise Application Systems

Da

taw

are

ho

usin

g S

tra

teg

y

Page 34: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 34

Assumptions on current customer landscape Assumptions

Bottom-Line:

All reporting is based on a non-SAP data

warehouse or data marts

Landscape Assumptions:

Customer has a non-SAP data warehouse

or data marts in place

One or several ETL tools in use, but no

assumption on ETL vendor

No assumption on BI tools used

Reporting might not cover all available

backend-data

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

Page 35: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 35

SAP BusinessObjects Data Services 4.0

SAP BusinessObjects Information Steward 4.0

SAP NetWeaver Business Warehouse 7.3

SAP NetWeaver BW Accelerator 7.20

SAP NetWeaver Master Data Management 7.1

SAP Master Data Governance (part of SAP ERP 6.0 EhP5)

SAP HANA 1.0

Relevant SAP EIM Solutions for this customer landscape

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 36: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 36

Overall Recommendation (1/2)

Business Driver Recommendation

Return to SAP standard, benefit from

deep integration with SAP Business

Suite and SBOP Business Intelligence

and report with excellent performance

Replace non-SAP data warehouse by a

SAP NW Business Warehouse 7.3,

accelerated by

SAP NetWeaver BW Accelerator 7.20

Achieve flexible high-performance

analytics on real-time operational data

and for strategic LoB decision making

Implement operational data marts for

SAP Business Suite or agile data marts

for your DWH with SAP HANA 1.0

Leverage pre-packaged SAP

integration, simplify your landscape and

boost data quality

Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data

Quality platform

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 37: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 37

Overall Recommendation (2/2)

Business Driver Recommendation

Improve reporting quality through

centrally governed master data

Manage your master data with SAP NW

Master Data Management 7.1 or with

SAP Master Data Governance in SAP

ERP 6.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 38: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 38

Recommendation 1: Replace non-SAP data warehouse by

an SAP BW 7.3, accelerated by BW Accelerator 7.20 Baseline

SAP NW Business Warehouse 7.3 differentiates from other data warehouses through its strong business focus:

this starts with rich business content for quick implementation and business-oriented modeling patterns

supporting a consistent layered scalable architecture paradigm. Data acquisition is out-of-the-box for SAP

sources and very flexible for non-SAP sources through Data Services 4.0. A highly flexible authorization concept

ensures compliance with any company‟s security guidelines.The enterprise-ready lifecylce management covers

3-tier deployment (Dev/QA/Prod), meta data lifecycle management (like versioning, remodelling, deployment to

prod. environment etc.) and information lifecycle management (like data data aging strategies, Nearline Storage

support and archiving).

SAP NetWeaver BW Accelerator 7.20 facilitates scalability for high-volume data and large end user populations at

minimum cost of operations.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or data marts

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP SAP SAP

SAP NetWeaver

BW 7.3

BWA

7.20

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 39: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 39

Recommendation 1: Replace non-SAP data warehouse by

an SAP BW 7.3, accelerated by BW Accelerator 7.20 Growth Options

The accelerated SAP NetWeaver BW 7.3 is best leveraged by

standardizing on Data Services 4.0 as the company-wide platform for ETL & Data Quality, thus

adding flexibility in extracting non-SAP data and boosting data quality in SAP NetWeaver BW, SAP

Business Suite and non-SAP systems

using Information Steward 4.0 to to discover, assess, define, monitor and improve the quality of all

enterprise data assets

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Info

rma

tion

Ste

wa

rd 4

.0

Data Services 4.0

SAP NetWeaver

BW 7.3

BWA

7.20

Page 40: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 40

Recommendation 2: Implement operational data marts for SAP

Business Suite or agile data marts for your DWH with SAP HANA 1.0 Baseline

BI Tool Suite

(SAP or non-SAP)

non-

SAP SAP SAP non-

SAP

With SAP HANA 1.0, customers can instantly explore and analyze all of their transactional and analytical data from virtually

any data source in real time. Due to real-time replication, operational data from an SAP system can be captured in memory

as business happens. New business content provides immediate access to analytical models and can be flexibly

customized or efficiently developed from scratch.

To expand analysis across the entire organization, data from other systems can be added to analytical models with

Data Services 4.0.

SAP HANA 1.0 is non-invasive to the landscape and all other analytics activities can continue as before.

Note: The growth options for this landscape will build on the next version of HANA which is covered in the next version of

this guide.

Solution Highlights

SAP HANA

1.0

Data

Services 4.0

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

SBOP BI 4.0

& MS Excel

non-SAP data

warehouse

or data marts

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

rea

l-tim

e ETL

Page 41: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 41

Recommendation 3: Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data Quality platform Baseline

By standardizing on Data Services 4.0 as company-wide platform for ETL & Data Quality, customers

benefit from out-of-the box native integration with SAP Business Suite & SAP BusinessObjects Business

Intelligence, simplify their enterprise architecture, intensify reuse, boost data quality and lay the foundation

for improved analytics, enhance operational effectiveness and information governance.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

Data Services 4.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 42: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 42

Recommendation 3: Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data Quality platform Growth Options

Data Services 4.0 is best complemented with

Information Steward 4.0 to to discover, assess, define, monitor and improve the quality of all

enterprise data assets.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

Data Services 4.0

Info

rma

tion

Ste

wa

rd 4

.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 43: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 43

Recommendation 4.1: Manage your master data with

SAP NetWeaver MDM 7.1 Baseline

SAP NetWeaver MDM 7.1 is geared to consolidate, harmonize and centrally manage master data in SAP and

heterogeneous environments. After redistribution of consolidated master data into the source systems the quality

of reports will be improved.

Some data warehouses also use the MDM connector to integrate with MDM 7.1 and can serve as the master

data source and as the distribution target.

To accelerate implementation, pre-built content & predefined services of the SAP NetWeaver MDM Rapid

Deployment Solution (RDS) for customer data integration can be used.

Solution Highlights

SAP

NetWeaver

MDM 7.1

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 44: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 44

Recommendation 4.1: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Growth Options

non-SAP data warehouse

or

data marts

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP

non-

SAP

SAP NW

BPM 7.1

Info

rma

tion

Ste

wa

rd 4

.0

SAP NW

MDM 7.1

Data

Services

4.0

SAP

SAP NetWeaver MDM 7.1 is best complemented with

Data Services 4.0 for market leading data quality & data integration within MDM.

Ideally, this same Data Services 4.0 installation is used as company-wide ETL & Data Quality

platform standard (cp. recommendation 1)

SAP NetWeaver Business Process Management 7.2 for collaborative data creation processes

Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all

enterprise data assets

Solution Highlights

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

Page 45: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 45

Recommendation 4.2: Manage your master data with SAP

Master Data Governance in SAP ERP 6.0 Baseline

SAP Master Data Governance (MDG) is integral part of SAP ERP 6.0 EhP5 and features out-of-the-box, domain-

specific master data governance applications to centrally create, change and distribute master data with a focus

on SAP Business Suite. Supported domains are financial data, supplier data and material data. Replication to

SAP systems (even before ERP 6.0) is delivered out-of-the-box, the replication to non-SAP system is done via

enterprise services, ALE/iDocs, RFC or file. Leading MDG system is either an existing system or any newly set-

up ERP 6.05 system.

Note: Since SAP Master Data Governance does not support master data consolidation or harmonization, the key

value will be in streamlining business processes (operational MDM) while ensuring master data governance, with

only an implicit effect on enterprise reporting (analytical MDM).

Solution Highlights

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP

SAP ERP

6.0 EhP5

Page 46: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 46

Recommendation 4.2: Manage your master data with

SAP Master Data Governance in SAP ERP 6.0 Growth Options

SAP Master Data Governance (MDG) is best complemented by these solutions:

SAP NW Process Integration 7.3 for 3rd-party integration or complex system landscape management

SAP NetWeaver MDM 7.1 for reaching out into application-agnostic contexts, supporting all domains and use-cases via

a multi-domain infrastructure. Huge impact on reporting quality by adding consolidation & harmonization capabilities.

Enterprise Search (TREX) for search and duplicate check (mandatory for material)

SAP BusinessObjects Data Quality Management 4.0 for duplicate check & address validation

SAP BusinessObjects analytical dashboards for alternative UIs, replacing MDG‟s standard ALV lists

Solution Highlights

SAP ERP

6.0 EhP5

BI Tool Suite (SAP or non-SAP)

non-

SAP

Enterprise

Search

SAP NetWeaver

PI 7.3

Dash-

boards

SAP NetWeaver

MDM 7.1

Data Quality

Mgmt

BI Tool Suite (SAP or non-SAP)

non-SAP data warehouse

or

data marts

non-

SAP

non-

SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

non-SAP data warehouse or data marts

non-

SAP SAP

Page 47: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 47

Where to learn more

Product/Solution Reference

SAP NetWeaver BW 7.3 BW 7.3 @ SAP Community Network

SAP NetWeaver BW

Accelerator 7.20

BWA 7.20 @ SAP Community Network

SAP HANA 1.0 In-Memory @ SAP Community Network

SAP NetWeaver Master

Data Management 7.1

MDM @ SAP Community Network

Rapid Deployment Solution for MDM 7.1

SAP Master Data

Governance

MDG @ SAP Community Network

SAP BusinessObjects

Data Services 4.0

Data Services 4.0 @ SCN

Data Services Wiki

SAP BusinessObjects

Information Steward 4.0

Information Steward @ SCN

Page 48: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 48

EIM Solution Architecture for BI

Categorization of Customer System Landscapes

non-SAP systems

only

SAP systems only SAP and non-SAP

systems

No

datawarehouse

strategy

System Landscape

Type 1

System Landscape

Type 2

Non-SAP

datawarehouse System Landscape Type 3

SAP BW not considered System Landscape Type 4

SAP BW for SAP

data,

non-SAP DWH for

non-SAP data

not considered System Landscape Type 5

Enterprise Application Systems

Da

taw

are

ho

usin

g S

tra

teg

y

Page 49: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 49

Assumptions on current customer landscape Assumptions

Bottom-Line:

SAP NetWeaver BW is the central data

warehouse in a heterogeneous application

landscape

Landscape Assumptions:

Customer uses SAP NetWeaver BW as

their enterprise data warehouse

All/most SAP reporting data is fed into

SAP NetWeaver BW. BW ETL is used for

extracting & loading all SAP data

Some, but not necessarily all non-SAP

reporting data is also fed into

SAP NetWeaver BW, but no assumption on

the ETL tool used

No assumptions on BI tools used

Reporting might not cover all available

backend-data

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

Page 50: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 50

Relevant SAP EIM Products for this customer landscape

SAP BusinessObjects Data Services 4.0

SAP BusinessObjects Information Steward 4.0

SAP NetWeaver Business Warehouse 7.3

SAP NetWeaver BW Accelerator 7.20

SAP NetWeaver Master Data Management 7.1

SAP Master Data Governance (part of SAP ERP 6.0 EhP5)

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 51: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 51

Overall Recommendation (1/2)

Business Driver Recommendation

Significantly improve BW query

performance while lowering TCO

Leverage in-memory technology for

SAP NetWeaver BW with

SAP NW BW Accelerator 7.20

Leverage the existing landscape with

limited additional investment Upgrade to SAP NetWeaver BW 7.3

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Achieve flexible high-performance

analytics on real-time operational data

and for strategic LoB decision making

Implement operational data marts for

SAP Business Suite or agile data marts

for SAP NetWeaver BW with

SAP HANA 1.0

Page 52: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 52

Overall Recommendation (2/2)

Business Driver Recommendation

Improve reporting quality through

centrally governed master data

Manage your master data with SAP NW

Master Data Management 7.1 or with

SAP Master Data Governance in SAP

ERP 6.05

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Leverage pre-packaged SAP

integration, simplify your landscape and

boost data quality

Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data

Quality platform

Page 53: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 53

Recommendation 1: Upgrade to SAP NetWeaver BW 7.3 Baseline

By upgrading to SAP NetWeaver BW 7.3, customers enhance scalability & performance for

faster decision making, reduce TCO and improve development efficiency while simplifying

configuration and operational management.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP SAP SAP

SAP NetWeaver BW 7.3

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 54: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 54

Recommendation 1: Upgrade to SAP NetWeaver BW 7.3 Growth Options

SAP NetWeaver BW 7.3 is best complemented by

adding SAP NetWeaver BW Accelerator 7.20 to reach the next level of performance

standardizing on Data Services 4.0 as company-wide platform for ETL & Data Quality, thus adding

flexibility in extracting non-SAP data and boosting data quality in SAP NetWeaver BW,

SAP Business Suite and non-SAP systems

using Information Steward 4.0 to to discover, assess, define, monitor and improve the quality of all

enterprise data assets

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP SAP

Info

rma

tion

Ste

wa

rd 4

.0

Data Services 4.0

SAP NetWeaver

BW 7.3

BWA

7.20

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

non-

SAP

non-

SAP

Page 55: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 55

Recommendation 2: Leverage in-memory technology for

SAP NetWeaver BW with SAP NW BW Accelerator 7.20 Baseline

SAP NetWeaver BW Accelerator 7.20 boosts BW 7.0 query performance & system scalability even for very

high data volumes. Delivered as an appliance, BWA 7.20 ensures low cost of operations, does not change the

BW user experience, saves time for BW development, maintenance and allows for lower data latency.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

non-

SAP

non-

SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

SAP NetWeaver BW BWA

7.20

Page 56: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 56

Recommendation 2: Leverage in-memory technology for

SAP NetWeaver BW with SAP NW BW Accelerator 7.20 Growth Options

SAP NetWeaver BW Accelerator 7.20 is best complemented with

an upgraded SAP NetWeaver BW 7.3 to leverage advanced BWA 7.20 features

Data Services 4.0 for loading BWA directly with non-SAP data (“any source scenario”). Once

implemented, the Data Services 4.0 instance can be leveraged to bring more flexibility in loading

non-SAP data to SAP NetWeaver BW and in boosting data quality in SAP NetWeaver BW,

SAP Business Suite and non-SAP systems

Information Steward 4.0 to to discover, assess, define, monitor and improve the quality of all enterprise

data assets

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW 7.3

non-

SAP

non-

SAP SAP SAP

BWA

7.20

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Info

rma

tion

Ste

wa

rd 4

.0

Data Services 4.0

Page 57: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 57

Recommendation 3: Implement operational data marts for SAP

Business Suite or agile data marts for SAP BW with SAP HANA 1.0 Baseline

BI Tool Suite

(SAP or non-SAP)

non-

SAP SAP SAP non-

SAP

With SAP HANA 1.0, customers can instantly explore and analyze all of their transactional and analytical data from virtually

any data source in real time. Due to real-time replication, operational data from an SAP system can be captured in memory

as business happens. New business content provides immediate access to analytical models and can be flexibly

customized or efficiently developed from scratch.

To expand analysis across the entire organization, data from other systems can be added to analytical models with

Data Services 4.0.

SAP HANA 1.0 is non-invasive to the landscape and all other analytics activities can continue as before.

Note: The growth options for this landscape will build on the next version of HANA which is covered in the next version of

this guide.

Solution Highlights

SAP HANA

1.0

Data

Services 4.0

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

SBOP BI 4.0

& MS Excel

SAP NetWeaver

BW

rea

l-tim

e ETL

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 58: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 58

Recommendation 3: Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data Quality platform Baseline

By standardizing on Data Services 4.0 as company-wide platform for ETL & Data Quality, customers bring

more flexibility in loading non-SAP data to SAP NetWeaver BW and in boosting data quality in

SAP NetWeaver BW, SAP Business Suite and non-SAP systems.

They also lay the foundation for improved analytics, enhanced operational effectiveness and information

governance.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

Data Services 4.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 59: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 59

Recommendation 3: Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data Quality platform Growth Options

Data Services 4.0 is best complemented with

Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all enterprise

data assets

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

Data Services 4.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Info

rma

tion

Ste

wa

rd 4

.0

Page 60: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 60

Recommendation 4.1: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Baseline

SAP NetWeaver MDM 7.1 is geared to consolidate, harmonize and centrally manage master data in SAP and

heterogeneous environments.

SAP NetWeaver BW tightly integrates with SAP NetWeaver MDM 7.1. This enables consolidated reporting in

cross-system environments where MDM 7.1 is the central hub for harmonized master data. It also reduces costs

and gains competitive advantage through MDM-supported BW analysis scenarios (like vendor evaluation, global

spend analysis, top N customer analysis).

To accelerate implementation, pre-built content & predefined services of the SAP NetWeaver MDM Rapid

Deployment Solution (RDS) for customer data integration (CDI) can be used.

Solution Highlights

SAP

NetWeaver

MDM 7.1

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 61: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 61

Recommendation 4.1: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Growth Options

SAP NetWeaver BW

BI Tool Suite (SAP or non-SAP)

non-

SAP SAP

non-

SAP

SAP NW

BPM 7.1

Info

rma

tion

Ste

wa

rd 4

.0

SAP NW

MDM 7.1

Data

Services

4.0

SAP

SAP NetWeaver Master Data Management 7.1 is best complemented with

Data Services 4.0 for market leading data quality & data integration within MDM.

Ideally, this same DS 4.0 instance is used as company-wide ETL & Data Quality platform standard

(see recommendation 3)

SAP NetWeaver Business Process Management 7.2 for collaborative data creation processes

Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all

enterprise data assets

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 62: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 62

Recommendation 4.2: Manage your master data with

SAP Master Data Governance in SAP ERP 6.05 Baseline

SAP Master Data Governance (MDG) is integral part of SAP ERP 6.0 EhP5 and features out-of-the-box, domain-

specific master data governance applications to centrally create, change and distribute master data with a focus

on SAP Business Suite. Supported domains are financial data, supplier data and material data. Replication to

SAP systems (even before ERP 6.0) is delivered out-of-the-box, the replication to non-SAP system is done via

enterprise services, ALE/iDocs, RFC or file. Leading MDG system is either an existing system or any newly set-

up ERP 6.05 system.

Note: Since SAP Master Data Governance does not support master data consolidation or harmonization, the key

value will be in streamlining business processes (operational MDM) while ensuring master data governance, with

only an implicit effect on enterprise reporting (analytical MDM).

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP

SAP ERP

6.0 EhP5

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 63: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 63

non-

SAP

Recommendation 4.2: Manage your master data with

SAP Master Data Governance in SAP ERP 6.05 Growth Options

SAP Master Data Governance (MDG) is best complemented by these solutions:

SAP NW Process Integration 7.3 for 3rd-party integration or complex system landscape management

SAP NetWeaver MDM 7.1 for reaching out into application-agnostic contexts, supporting all domains and use-

cases via a multi-domain infrastructure. Huge impact on reporting quality by adding consolidation & harmonization

capabilities

Enterprise Search (TREX) for search and duplicate check (mandatory for material)

SAP BusinessObjects Data Quality Management 4.0 for duplicate check & address validation

SAP BusinessObjects analytical dashboards for alternative UIs, replacing MDG‟s standard ALV lists

BI Tool Suite (SAP or non-SAP)

Enterprise

Search

SAP NetWeaver

PI 7.3

Dash-

boards

SAP NetWeaver

MDM 7.1

Data Quality

Mgmt

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver BW

non-

SAP

non-

SAP SAP SAP

SAP NetWeaver BW

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Solution Highlights

SAP ERP

6.0 EhP5 non-

SAP SAP

Page 64: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 64

Where to learn more

Product/Solution Reference

SAP NetWeaver BW 7.3 BW 7.3 @ SAP Community Network

SAP NetWeaver BW

Accelerator 7.20

BWA 7.20 @ SAP Community Network

SAP HANA 1.0 In-Memory @ SAP Community Network

SAP NetWeaver Master

Data Management 7.1

MDM @ SAP Community Network

Rapid Deployment Solution for MDM 7.1

SAP Master Data

Governance

MDG @ SAP Community Network

SAP BusinessObjects

Data Services 4.0

Data Services 4.0 @ SCN

Data Services Wiki

SAP BusinessObjects

Information Steward 4.0

Information Steward @ SCN

Page 65: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 65

EIM Solution Architecture for BI

Categorization of Customer System Landscapes

non-SAP systems

only

SAP systems only SAP and non-SAP

systems

No

datawarehouse

strategy

System Landscape

Type 1

System Landscape

Type 2

Non-SAP

datawarehouse System Landscape Type 3

SAP BW not considered System Landscape Type 4

SAP BW for SAP

data,

non-SAP DWH for

non-SAP data

not considered System Landscape Type 5

Enterprise Application Systems

Da

taw

are

ho

usin

g S

tra

teg

y

Page 66: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 66

Assumptions on current customer landscape Assumptions

Bottom-Line:

Mixed backend and data warehousing

systems

Often “historically grown” or tuned to the

needs of very large enterprises.

Landscape Assumptions:

Several BW and/or several non-SAP data

warehouse s(DWH) are in place, acting

either in parallel or with one leading DWH

All/most SAP reporting data is fed into

SAP NetWeaver BW. BW ETL for SAP data

Non-SAP DWH mostly/only for non-SAP

data.

No assumption on ETL tool used, but

oftentimes many ETL instances in place

No assumptions on BI tools used

Reporting might not cover all available

backend-data

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 1

SAP

NetWeaver

BW 2

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

Page 67: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 67

Relevant SAP EIM Solutions for this customer landscape

SAP BusinessObjects Data Services 4.0

SAP BusinessObjects Information Steward 4.0

SAP NetWeaver Business Warehouse 7.3

SAP NetWeaver BW Accelerator 7.2

SAP NetWeaver Master Data Management 7.1

SAP Master Data Governance (part of SAP ERP 6.0 EhP5)

SAP HANA 1.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 68: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 68

Overall Recommendation (1/2)

Business Driver Recommendation

Massively simplify your landscape to

drive down TCO and increase

manageability

Consolidate data warehouses

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Leverage the existing landscape with

limited additional investment Upgrade to SAP NetWeaver BW 7.3

Significantly improve BW query

performance while lowering TCO

Leverage in-memory technology for

SAP NetWeaver BW with

SAP NW BW Accelerator 7.20

Page 69: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 69

Overall Recommendation (2/2)

Business Driver Recommendation

Improve reporting quality through

centrally governed master data

Manage your master data with SAP NW

Master Data Management 7.1 or with

SAP Master Data Governance in SAP

ERP 6.05

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Achieve flexible high-performance

analytics on real-time operational data

and for strategic LoB decision making

Implement operational data marts for

SAP Business Suite or agile data marts

for SAP NetWeaver BW with

SAP HANA 1.0

Leverage pre-packaged SAP

integration, simplify your landscape and

boost data quality

Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data

Quality platform

Page 70: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 70

Recommendation 1: Upgrade to SAP NetWeaver BW 7.3 Baseline

By upgrading to SAP NetWeaver Business Warehouse 7.3, customers enhance scalability & performance

for faster decision making, reduce TCO and improve development efficiency while simplifying

configuration und operational management.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 1

SAP

NetWeaver

BW 2

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 7.3

SAP

NetWeaver

BW 7.3

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 71: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 71

Recommendation 1: Upgrade to SAP NetWeaver BW 7.3 Growth Options

SAP NetWeaver Business Warehouse 7.3 is best complemented by

implementing SAP NetWeaver BW Accelerator 7.20 to reach the next level of performance

Note: One BWA 7.20 instance per SAP NetWeaver BW system is required.

standardizing on Data Services 4.0 as the company-wide platform for ETL & Data Quality, thus adding

flexibility in extracting non-SAP data and boosting data quality in SAP NetWeaver BW, SAP Business Suite

and non-SAP systems

Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all enterprise data

assets

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 1

SAP

NetWeaver

BW 2

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BWA

7.20

Data Services 4.0

Info

rma

tion

Ste

wa

rd 4

.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BWA

7.20

Solution Highlights

SAP

NetWeaver

BW 7.3

SAP

NetWeaver

BW 7.3

Page 72: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 72

Recommendation 2.1: Consolidate Data Warehouses to a

single, accelerated SAP NetWeaver BW 7.3 Baseline

By consolidating all data warehouses into a single SAP NetWeaver BW that is accelerated by

SAP NetWeaver BW Accelerator 7.20, customers can significantly reduce TCO, establish a genuine

single source of truth and accelerate reporting performance by applying in-memory technology.

This consolidation is best realized on SAP NetWeaver BW 7.3 to benefit from the improvements in

scalability & performance, operating costs, development efficiency and simplified configuration &

management.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 1

SAP

NetWeaver

BW 2

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver

BW 7.3

non-

SAP

non-

SAP SAP SAP SAP

BWA 7.20

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 73: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 73

Recommendation 2.1: Consolidate Data Warehouses to a

single, accelerated SAP NetWeaver BW 7.3 Growth Options

The consolidated SAP NetWeaver BW 7.3 is best leveraged by

standardizing on Data Services 4.0 as company-wide platform for ETL & Data Quality, thus adding

flexibility in extracting non-SAP data and boosting data quality in SAP NetWeaver BW, SAP Business

Suite and non-SAP systems

using Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all

enterprise data assets

Solution Highlights

Info

rma

tion

Ste

wa

rd 4

.0

BI Tool Suite (SAP or non-SAP)

SAP NetWeaver

BW 7.3

non-

SAP

non-

SAP SAP SAP SAP

Data Services 4.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 1

SAP

NetWeaver

BW 2

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BWA 7.20

Page 74: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 74

Recommendation 2.2: Consolidate some Data

Warehouses to SAP NetWeaver BW 7.3 Baseline

As an interim step towards complete consolidation (see recommendation 2.1), only some data

warehouses are consolidated into a central data warehouse. This is realized easiest for the SAP BW

systems first and best on SAP NetWeaver BW 7.3 as platform.

As compared to recommendation 2.1, only a subset of benefits is realized with respect to TCO reduction,

single source of truth etc.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 1

SAP

NetWeaver

BW 2

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 7.3

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 75: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 75

Recommendation 2.2: Consolidate some Data

Warehouses to SAP NetWeaver BW Growth Options

The consolidated SAP NetWeaver BW 7.3 is best leveraged by

adding SAP NetWeaver BW Accelerator 7.20 to reach the next level of performance

standardizing on Data Services 4.0 as the company-wide platform for ETL & Data Quality, thus adding

flexibility in extracting non-SAP data and boosting data quality in SAP NetWeaver BW, SAP Business Suite

and non-SAP systems

adopting Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all

enterprise data assets

going the final mile and consolidating the remaining data warehouses into SAP NetWeaver BW 7.3

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 1

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP

NetWeaver

BW 7.3

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BWA

7.20

Data Services 4.0

Info

rma

tion

Ste

wa

rd 4

.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

SAP

SAP

NetWeaver

BW 2

Page 76: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 76

Recommendation 3: Leverage in-memory technology for

SAP NetWeaver BW with SAP NW BW Accelerator 7.20 Baseline

SAP NetWeaver BW Accelerator 7.20 boosts BW 7.0 query performance & system scalability even for

very high data volumes.

Delivered as an appliance, BWA 7.20 ensures low cost of operations, does not change the BW user

experience, saves time for BW development and maintenance and allows for lower data latency.

Note: In productive environments, each SAP NetWeaver BW system needs to have its own BWA 7.20

instance

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BWA

7.20

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BWA

7.20

Page 77: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 77

Recommendation 3: Leverage in-memory technology for

SAP NetWeaver BW with SAP NW BW Accelerator 7.20 Growth Options

SAP NetWeaver BW Accelerator 7.20 is best complemented with

an upgraded SAP NetWeaver BW 7.3 to leverage advanced BWA 7.20 features

Data Services 4.0 for loading BWA directly with non-SAP data (“any source scenario”).

Once implemented, the Data Services 4.0 instance can be leveraged to bring more flexibility in loading non-SAP

data to SAP NetWeaver BW and in boosting data quality in SAP BW, SAP Business Suite and non-SAP systems.

Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all enterprise data assets

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

Data Services 4.0

Info

rma

tion

Ste

wa

rd 4

.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

SAP BW 7.3 SAP BW 7.3

BWA

7.20

BWA

7.20

SAP

Page 78: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 78

Recommendation 4: Implement operational data marts for SAP

Business Suite or agile data marts for SAP BW with SAP HANA 1.0 Baseline

With SAP HANA 1.0, customers can can instantly explore and analyze all of their transactional and analytical data from

virtually any data source in real time. Due to real-time replication, operational data from an SAP system can be captured in

memory as business happens. New business content provides immediate access to analytical models and can be flexibly

customized or efficiently developed from scratch.

To expand analysis across the entire organization, data from other systems can be added to analytical models with

Data Services 4.0.

SAP HANA 1.0 is non-invasive to the landscape and all other analytics activities can continue as before.

Note: The growth options for this landscape will build on the next version of HANA which is covered in the next version of

this guide.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP

BW 1

non-

SAP

non-

SAP SAP SAP SAP

SAP

HANA 1.0

Data

Services 4.0

SBOP BI 4.0

& MS Excel

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

rea

l-tim

e

ETL

Non-SAP

DWH 3 SAP

BW 2

Non-SAP

DWH 3

Page 79: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 79

Recommendation 5: Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data Quality platform Baseline

By standardizing on Data Services 4.0 as company-wide platform for ETL & Data Quality, customers bring

more flexibility in loading non-SAP data to SAP BW and in boosting data quality in SAP NetWeaver BW,

SAP Business Suite and non-SAP systems.

They also lay the foundation for improved analytics, enhanced operational effectiveness and information

governance

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

Data Services 4.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

SAP

Page 80: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 80

Recommendation 5: Standardize on Data Services 4.0 as

your enterprise-wide ETL and Data Quality platform Growth Options

Data Services 4.0 is best complemented with

Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all enterprise

data assets

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP BW 1 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

Data Services 4.0

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

SAP

Info

rma

tion

Ste

wa

rd 4

.0

SAP BW 2

Page 81: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 81

Recommendation 6.1: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Baseline

SAP NetWeaver Master Data Management 7.1 is geared to consolidate, harmonize and centrally manage master data of

SAP and heterogeneous environments.

SAP NetWeaver BW tightly integrates with SAP NetWeaver MDM 7.1. This enables consolidated reporting in cross-system

environments where MDM is the central hub for harmonized master data as well as reduces costs and gains competitive

advantage through MDM-supported BW analysis scenarios (like vendor evaluation, global spend analysis, top N customer

analysis). Some data warehouses also integrate with SAP NetWeaver MDM 7.1 via the MDM connector and can serve as

master data source and as distribution target.

To accelerate implementation, pre-built content & predefined services of the SAP NetWeaver MDM Rapid Deployment

Solution (RDS) for customer data integration (CDI) can be used.

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

SAP

NetWeaver

MDM 7.1

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 82: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 82

Recommendation 6.1: Manage your master data with

SAP NetWeaver Master Data Management 7.1 Growth Options

non-

SAP SAP

non-

SAP

SAP NW

BPM 7.1

Info

rma

tion

Ste

wa

rd 4

.0

SAP NW

MDM 7.1

Data

Services

4.0

SAP

SAP NetWeaver Master Data Management 7.1 is best complemented with

Data Services 4.0 for market leading data quality & data integration within MDM.

Ideally, this same DS 4.0 instance is used as company-wide ETL & Data Quality platform standard (see

recommendation 3)

SAP NetWeaver Business Process Management 7.2 for collaborative data creation processes

Information Steward 4.0 to discover, assess, define, monitor and improve the quality of all enterprise data

assets

Solution Highlights

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2 Non-SAP

DWH 3

SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Page 83: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 83

Recommendation 6.2: Manage your master data with

SAP Master Data Governance in SAP ERP 6.05 Baseline

SAP Master Data Governance (MDG) is integral part of SAP ERP 6.0 EhP5 and features out-of-the-box, domain-

specific master data governance applications to centrally create, change and distribute master data with a focus

on SAP Business Suite. Supported domains are financial data, supplier data and material data.

Replication to SAP systems (even before ERP 6.0) is delivered out-of-the-box, the replication to non-SAP system

is done via enterprise services, ALE/iDocs, RFC or file. Leading MDG system is either an existing system or any

newly set-up ERP 6.05 system.

Note: Since SAP Master Data Governance does not support master data consolidation or harmonization, the key

value will be in streamlining business processes (operational MDM) while ensuring master data governance, with

only an implicit effect on enterprise reporting (analytical MDM).

Solution Highlights

non-

SAP

non-

SAP SAP

SAP ERP

6.0 EhP5

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

SAP

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2

non-

SAP

non-

SAP SAP SAP SAP

BI Tool Suite (SAP or non-SAP)

SAP BW 1 SAP BW 2

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

Non-SAP

DWH 3

Non-SAP

DWH 3

Page 84: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 84

Recommendation 6.2: Manage your master data with

SAP Master Data Governance in SAP ERP 6.05 Growth Options

SAP Master Data Governance (MDG) is best complemented by these solutions:

SAP NW Process Integration 7.3 for 3rd-party integration or complex system landscape management

SAP NetWeaver MDM 7.1 for reaching out into application-agnostic contexts, supporting all domains and use-cases via

a multi-domain infrastructure. Huge impact on reporting quality by adding consolidation & harmonization capabilities

Enterprise Search (TREX) for search and duplicate check (mandatory for material)

SAP BusinessObjects Data Quality Management 4.0 for duplicate check & address validation

SAP BusinessObjects analytical dashboards for alternative UIs, replacing MDG‟s standard ALV lists

Solution Highlights

Enterprise

Search

SAP NetWeaver

PI 7.3

Dash-

boards

SAP NetWeaver

MDM 7.1

Data Quality

Mgmt 4.0

BI Tool Suite (SAP or non-SAP)

SAP BW 1

non-

SAP

non-

SAP SAP SAP SAP

Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5 Landscape Type 1 Landscape Type 2 Landscape Type 3 Landscape Type 4 Landscape Type 5

BI Tool Suite (SAP or non-SAP)

SAP

BW 1

SAP

BW 2

SAP BW 2 Non-SAP

DWH 3

SAP ERP

6.0 EhP5

Non-SAP

DWH 3

SAP non-

SAP SAP non-

SAP

Page 85: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 85

Where to learn more

Product/Solution Reference

SAP NetWeaver BW 7.3 BW 7.3 @ SAP Community Network

SAP NetWeaver BW

Accelerator 7.20

BWA 7.20 @ SAP Community Network

HANA 1.0 In-Memory @ SAP Community Network

SAP NetWeaver Master

Data Management 7.1

MDM @ SAP Community Network

Rapid Deployment Solution for MDM 7.1

Master Data

Governance

MDG @ SAP Community Network

Data Services 4.0 Data Services 4.0 @ SCN

Data Services Wiki

Information Steward 4.0 Information Steward @ SCN

Page 86: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 86

Appendix

Page 87: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 87

We are planning future versions of this guide, incorporating

Feedback from readers and stakeholders

Sybase IQ 15.2 (extended scenarios)

– e.g. scenarios like Near-Line Storage for SAP NetWeaver BW with Sybase IQ or

data mining with Sybase IQ

Next version of HANA

SAP EIM Solutions for Content & Lifecycle Management

as well as creating a joint Solution Architecture for BI & EIM, based on the

already existing SAP BusinessObjects BI Solution Architecture and this guide

Outlook to future versions of this Guide

Page 88: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 88

Relationship to SAP BusinessObjects BI Solution

Architecture

The SAP BusinessObjects BI Solution Architecture

provides an end-to-end view on how to leverage and deploy the

SAP BusinessObjects BI portfolio as part of the customer overall ERP and data

warehousing landscape

discusses landscape patterns, scenarios, and best practices for how customers are using

SAP or non-SAP based packaged applications and data warehouse solutions

is currently based on the XI 3.1 release of the SAP BusinessObjects BI portfolio,

but will be updated to BI 4.0 shortly

is available for download in the SAP Community Network

This Guide

focuses on SAP„s EIM solution portfolio

makes no assumptions on BI Tool Suite used

uses the same landscape patterns as the BI Solution Architecture

gives no recommendations which SAP BI Tools should be used when

(unless a recommended EIM solution requires a certain SAP BI tool on top)

Page 89: EIM Solution Architecture for BI - SAP

Thank You!

Page 90: EIM Solution Architecture for BI - SAP

© 2011 SAP AG. All rights reserved. 90

No part of this publication may be reproduced or transmitted in any form or for any

purpose without the express permission of SAP AG. The information contained

herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain

proprietary software components of other software vendors.

Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of

Microsoft Corporation.

IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5,

System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries,

zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390

Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6,

POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes,

BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF,

Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere,

Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM

Corporation.

Linux is the registered trademark of Linus Torvalds in the U.S. and other

countries.

Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or

registered trademarks of Adobe Systems Incorporated in the United States and/or

other countries.

Oracle and Java are registered trademarks of Oracle and/or its affiliates.

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and

MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.

HTML, XML, XHTML and W3C are trademarks or registered trademarks of

W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

© 2011 SAP AG. All rights reserved.

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects

Explorer, StreamWork, and other SAP products and services mentioned herein as

well as their respective logos are trademarks or registered trademarks of SAP AG

in Germany and other countries.

Business Objects and the Business Objects logo, BusinessObjects, Crystal

Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business

Objects products and services mentioned herein as well as their respective logos

are trademarks or registered trademarks of Business Objects Software Ltd.

Business Objects is an

SAP company.

Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other

Sybase products and services mentioned herein as well as their respective logos

are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP

company.

All other product and service names mentioned are the trademarks of their

respective companies. Data contained in this document serves informational

purposes only. National product specifications may vary.

The information in this document is proprietary to SAP. No part of this document

may be reproduced, copied, or transmitted in any form or for any purpose without

the express prior written permission of SAP AG.