Roadmap from bw to bi
This presentation is the property of its rightful owner.
Sponsored Links
1 / 84

Roadmap from BW to BI PowerPoint PPT Presentation


  • 182 Views
  • Uploaded on
  • Presentation posted in: General

Roadmap from BW to BI. Richard Brown, SAP UKI Head of Business Intelligence SAP UK & I. Roadmap from BW to BI. BW Overview. BI Capabilities of NetWeaver 2004s. Business Advantage of NW2004s. Implementation Experience. Roadmap from BW to BI. BW Overview.

Download Presentation

Roadmap from BW to BI

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

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


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Roadmap from bw to bi

Roadmap from BW to BI

Richard Brown, SAP UKI

Head of Business Intelligence SAP UK & I


Roadmap from bw to bi

Roadmap from BW to BI

BW Overview

BI Capabilities of NetWeaver 2004s

Business Advantage of NW2004s

Implementation Experience


Roadmap from bw to bi

Roadmap from BW to BI

BW Overview

BI Capabilities of NetWeaver 2004s

Business Advantage of NW2004s

Implementation Experience


Sap bw a success story

SAP BW – A success story

Active BW Customers> 6,500

Approximate Data

Volume

Are you satisfiedwith SAP BW?

How do you planto leverage SAP BW?

Number of Users

> 10,000

> 5 TB

1%

1%

Mixed data: 64%

1,000 - 10,000

Yes

13%

< 50

1 - 5 TB

0 - 100 GB

95%

24%

23%

26%

250 - 1,000

23%

SAP data only: 36%

500 GB - 1 TB

50 - 250

100 - 500 GB

18%

39%

32%

No

5%


Key features of a data warehouse

Key Features of a Data Warehouse

  • Data from across all relevant sources internal & external to the business

  • Separated Transactional & Analytical environments

  • End user report creation

  • Cross functional & targeted reporting

  • Detailed & summary data

  • A single version of the the truth


Sap business warehouse bw

SAP Business Warehouse (BW)

Anintegratedend-to-endData Warehouse solution

  • Powerful Information Analysis

  • Innovative, intuitive user interface

  • Powerful OLAP analysis

  • Web & MS Excel based front-ends

  • Easy integration with Portal

Information Management

  • ‘Best of breed’ technologies

  • Rich Business Content -pre-configured Information models, reports, KPI’s and extractors

  • Industry Specific Business Content

  • Configurable to specific requirements

Data Extraction

  • Built on the SAP Entity Model

  • SAP and non-SAP data extraction

  • Powerful Data Maintenance and Administration


Sap business intelligence

Self-service

Reporting

Dashboards

Targeted reports

Business

Warehouse

(BW)

Business

Content

SAP Business Intelligence

Other

3rd Party

Finance &

Projects

Sales

Interfaces

Credit

Control

Sales


Sap bi reporting and analysis for all user types

SAP BI - Reporting and Analysis For All User Types

  • Authors and Analysts

    • Need to dig into the data – explore & find trends

  • Business Managers

    • Need personalized information specific to their function

    • Summary – but with the ability to drill down to the detail

  • Executives

    • High level analysis (dashboards) - alert to key business issues & actions


Roadmap from bw to bi

  • SAP AG 2004, Title of Presentation / Speaker Name / 9

Authors & Analysts


Business managers

Targeted

Emailed

Alert Driven

Business Managers


Executives

Executives


Bw release 3 5 overview

BW release 3.5 Overview

1

Information Broadcasting

2

Universal Data Connection

3

NetWeaver Integration

4

Business Planning & Simulation (BPS)

Advanced Analytic functionality

5


Information broadcasting via e mail

Information Broadcasting via E-Mail

In this example the Report was sent in an MHTML-Format and is now available in the personal Inbox of the Receiver.


What are the broadcasting channels

What Are The Broadcasting Channels?

  • SAP Enterprise Portal 6.0 SP3

    • Knowledge Management Folders (“BEx Portfolio”)

      • Available KM Services: e.g. Indexing & Search engines (TREX), Subscription, Downloads, Rating, etc.

    • Portal Content Catalog (part of the Portal Content Directory)

    • Collaboration rooms & discussion forums

  • Email

    • BW users, BW roles or email addresses

    • Online queries, workbooks & web applications are sent as URLs

    • Pre-calculated queries, workbooks & web applications are sent as attachments or as inline mail body (MHTML)


What are reporting documents

What Are Reporting Documents?

  • Pre-calculated, online and offline reporting documents…

    • BI Web Applications - Dashboards, cockpits

    • BEx Analyzer Workbooks

    • Queries

  • ... in different formats ...

    • HTML

      • Device specific (Web Browser, Mobile devices, etc.)

    • BEx Analyzer Workbooks

    • Excel files

    • Emails using Multipart Html (MHTML)

    • ZIP Files

  • ... containing different kinds of information.

    • OLAP data, Alerts, Embedded Documents and Filter Navigation


Information broadcasting bex portfolio

Information Broadcasting – BEx Portfolio

Queries, Workbooks, BI Applications as KM Documents

  • KM Document:

    Pre-calculated query, workbook or application

  • KM Link: Online BW report

  • Use KM Services for:

    • Subscription

    • Feedback

    • Discussion

    • Collaboration

    • Rating

    • TREX search

    • Notes

    • Download


Bw release 3 5 overview1

BW release 3.5 Overview

1

Information Broadcasting

2

Universal Data Connection

3

NetWeaver Integration

4

Business Planning & Simulation (BPS)

Advanced Analytic functionality

5


Universal data integration

Universal Data Integration

  • BI Java Connectors to provide access to various data sources (via interfaces JDBC, XMLA, OLE DB for OLAP, SAP Query)

  • Based on industry standards for interoperability (JDBC, XMLA, ODBO)

  • Universal Data Connect to integrate data into BW platform

  • BI Java SDK for custom built Java Applications

2. Universal Data ConnectSAP BW Integration

BW

SAP

Enterprise Portal

Universal

Data

Connect

SAP

SAP

Query

OLAP

Staging

BEx

XMLA

non

SAP

BI

JavaSDK

Custom-built

Applications

JDBC

ODBO

1. BI Java Connectors

JDBC, XMLA,ODBO, SAP Query

3. BI Java SDK

Java API, Examples, Documentation


Bi java connectors

BI Java Connectors

  • Connectors for various data sources

  •  Leverages SAP WebAS 6.40 J2EE connectivity for SAP BW

  •  Basis for Universal Data Connect and BI Java SDK

    • Relational Sources

      • BI JDBC Connector

        • Industry Standard API for relational DBMS

        • Connectivity to 200+ JDBC drivers providing data access to: Oracle, MS SQL Server, Teradata, MS Access, DB2, Sybase, Excel, text files (CSV), etc.

        • See http://java.sun.com for more information

      • BI SAP Query Connector

        • Connectivity to operational SAP applications

        • SAP R/3, SAP CRM, Ad-hoc, operational

    • OLAP Sources

      • BI OLE DB for OLAP Connector

        • Industry Standard OLAP API for MS Windows platforms

        • Connectivity to MS Analysis Services, SAS, MS PTS, SAP BW

      • BI XMLA Connector

        • Web Service-based, platform-independent access to OLAP sources

        • Connectivity to MS Analysis Services, Hyperion, MicroStrategy, MIS, SAP BW 3.x

    • The set of connectors will be extended in further SAP BW releases


Sap bw non sap dw integration scenario

SAP BW – Non SAP-DW Integration Scenario

Reporting

Listing

Personnel Deployment

v

Skills profile

DW

Local Skills

Database

Non SAP-DW

SAP HR Cubes

BW

SAP HR Data

Various Sources

ERP


Bw release 3 5 overview2

BW release 3.5 Overview

1

Information Broadcasting

2

Universal Data Connection

3

NetWeaver Integration

4

Business Planning & Simulation (BPS)

Advanced Analytic functionality

5


Bw and xi

PSA

PSA

PSA

Delta-Queue

Delta-Queue

BW and XI

SAP BW

Operational

Data Store

Standard Staging

Realtime Data Acquisition

DataSources

SAP XI

Near RealtimeInfoPackage

Open Service

http / SOAP

mySAP.com(via BW Service-API)

RFC

realtime update


Bw release 3 5 overview3

BW release 3.5 Overview

1

Information Broadcasting

2

Universal Data Connection

3

NetWeaver Integration

4

Business Planning & Simulation (BPS)

Advanced Analytic functionality

5


Planning in mysap bi evolution

Current Planning Environment

mySAP Financials

SEM-BPS Planning

  • Financial Planning Applications

  • Modelling

  • Planning Framework

  • Process Coordination

mySAP BI

SAP BW

  • Data Management

  • Analysis

Planning in mySAP BI – Evolution

Future Planning Environment

mySAP Financials

SEM-BPS Planning

  • Financial Planning Applications

mySAP BI

SAP BW

  • Data Management

  • Modelling

  • Planning Framework

  • Process Coordination

  • Analysis


Planning cycles

Reconciliation of operational plans with strategic targets

Headcountplanning

Production planning

Operational Planning

Sales planning

Marketing planning

Strategic Targets

(Operating Profit + 4%,

Market share+10%)

Strategic Planning

December

August

Planning cycles

Strategic Planning and

Target setting on group level

Operational Planning and Budgetingin the business units

Plan evaluation


Sap bi planning architecture

User Interaction

ODS

SAP BI Planning Architecture

Presentation

Planning Front Ends

HTML in GUI

Excel Inplace

Excel Client

ALV Grid

Portal based

Open Interface and Web Services

Business Logic

Planning Framework

Modeling

Manual Planning/Analysis

AutomaticPlanning

Process control

Common Read / Write Interface

DWH Layer

Access / Storage

Dimensional Data

Master Data

Granular Data

Master

Data

Data Acquisition


Bw release 3 5 overview4

BW release 3.5 Overview

1

Information Broadcasting

2

Universal Data Connection

3

NetWeaver Integration

4

Business Planning & Simulation (BPS)

Advanced Analytic functionality

5


Roadmap from bw to bi

  • SAP AG 2004, Title of Presentation / Speaker Name / 28

Advanced Ad-hoc Reporting

  • New web template for ad-hoc analysis

    • Extensibility: Easy support of customer adaptations in Web App Designer

    • Enhanced usability and new look-and-feel

    • New functionality within the template tool bar


Web application designer

Web Application Designer

Chart Designer Wizard

(Reduced

Overview)

Result


Roadmap from bw to bi

A

B

C

Data Mining Methods - Explorative

Clustering

ABC

Classification

  • 20% of customers generate 60% of sales

Association

Analysis

Weighted

Score Tables

Weight


Roadmap from bw to bi

No

No

No

Yes

Yes

Yes

Data Mining Methods - Predictive

Regression

Decision Trees

Complaints

>4

<=4

Complaints

?

Gender

Age

Gender

M

F

Buy

Sales

Income

Income

# of Products

>30 k

<=30 k


Analysis process designer

Analysis Process Designer

  • Graphical modeling (drag&drop) and execution of Analysis Processes that make use of Data Mining to gain new insights and take action – closed loop

  • Examples of “Analysis Processes” would be the definition of ABC classes, the calculation of frequency distributions or the determination of Scoring information.


Composite scenarios customer retention

A

B

C

Composite Scenarios: Customer Retention

Clustering

Decision Trees

ABC Classification

B

At Risk

A

Loyal

C

Goal: Reduce Customer Churn

Association

Analysis

Transfer

Knowledge

Cross-Selling

Rules

Marketing Campaign


Roadmap from bw to bi

Roadmap from BW to BI

BW Overview

BI Capabilities of NetWeaver 2004s

Business Advantage of NW2004s

Implementation Experience


Netweaver 2004s

NetWeaver 2004s

1

Analytical Applications

2

BI Accelerator

3

Enterprise Data Warehousing

4

Enhanced Web & Excel Reporting

Integrated Planning

5


Sap netweaver the total integration and application platform for lower tco

Unifies and aligns people, information and business processes

Integrates across technologies and organizational boundaries

A safe choice with full .NET and J2EE interoperability

The business foundation for SAP and partners

Powers business-ready solutions that reduce custom integration

It’s SAP Enterprise Services Architecture increases business process flexibility

SAP NetWeaver

PEOPLE INTEGRATION

Multichannel access

Portal

Collaboration

INFORMATION INTEGRATION

Bus. Intelligence

Knowledge Mgmt

Master Data Management

COMPOSITE APPLICATION FRAMEWORK

LIFE CYCLE MANAGEMENT

PROCESS INTEGRATION

Integration Broker

Bus. ProcessMgmt

APPLICATION PLATFORM

J2EE

ABAP

DB and OS Abstraction

...

SAP NetWeaver™The total integration and application platform for lower TCO


The business intelligence platform

The Business Intelligence Platform

Web Presentation/Portal/Mgmt Reporting

Presentation

Consolidation

Ad Hoc Query and Reporting

Modeling and

Optimization

Statutory

Reporting

Balanced Scorecard

CPM

Applications

Budget

Plan/Forecast

Business Proc. Management

Content Management

Knowledge Management

DataMart

DataMart

DataMart

DataMart

BI

Infrastructure

Data Warehouse

Integration Broker

Data

Sources

ERP/CRM/SCM/External Sources

Architecture Source: Gartner (CPM, 2004)


The sap netweaver bi platform

Powered bySAP NetWeaver

Strategic Enterp.

Management

Information Integration

People Integration

Process Integration

SAP delivers the complete, end-to-end, reliable and open BI Solution.

The SAP NetWeaver BI Platform

Web Presentation/Portal/Mgmt Reporting

Consolidation

Ad Hoc Query and Reporting

Modeling and

Optimization

Statutory

Reporting

Balanced Scorecard

Budget

Plan/Forecast

SAP NetWeaver

Business Proc. Management

Content Management

Knowledge Management

DataMart

DataMart

DataMart

DataMart

Data Warehouse

Integration Broker

ERP/CRM/SCM/External Sources


Netweaver 2004s1

NetWeaver 2004s

1

Analytical Applications

2

BI Accelerator

3

Enterprise Data Warehousing

4

Enhanced Web & Excel Reporting

Integrated Planning

5


What is new analytics

Customer

Sales

(CRM)

Fulfillment(FC)

Production

(SCP)

Logistics

(SCE)

Fin.-Dptm.

(FIN)

Controlling

(BW)

1

3

2

Creation

Sales Order

Fulfillment

Request

Request

Global ATP

Global ATP

Check

4

Creation &

Release

Delivery

Request

5

Delivery

Execution

6

8

7

Release

ASN

Update

Inventory

Accounting

Update

Inventory

9

Receives

ASN

WHAT IS “NEW” ANALYTICS?

Example: Sales Order Fulfillment process

Creation

Purchase

Order


What is new analytics1

WHAT IS “NEW” ANALYTICS?

Questions & Insights lead to process improvement!

“Is customer

credit-worthy?”

“sufficient stock

of inventory?”

“extra effort

costs $$$?”

“360° View of

the Customer”

“smooth

shipping

Process?”


Visual composer model

Visual Composer Model


Netweaver 2004s2

NetWeaver 2004s

1

Analytical Applications

2

BI Accelerator

3

Enterprise Data Warehousing

4

Enhanced Web & Excel Reporting

Integrated Planning

5


Bi accelerator

BI Accelerator

Performance Optimization

SAP NetWeaver 2004s provides various tools to increase the data load and query performance significantly – among them the innovative high performance analytics approach. Thus, the implementation of large enterprise data warehouses is facilitated.

  • BI Accelerator

    A new paradigm for high performance data access.

    • Query performance is boosted by orders of magnitude

    • Simultaneously the realignment processes roll-up and change run are improved significantly

    • HPA is used in connection with KM search engine TREX

    • Provides linear scalability and can fully leverage grid and adaptive computing capabilities


Target

Target

Performance ImprovementBy Factor 10 in average,Up to Factor 1000 !

Stable Good Query

Response Time – IndependentFrom Database Features,

Caches, Aggregates, …

Very fast

Query Response Time

Stable

Query Response Time

BI Accelerator

Support of New HardwareParadigms like

Grid Computing, AdaptiveComputing

No Aggregate Maintenance,

Unnoticeable ‘Roll-up’,

No Change Run

Low Maintenance

High Scalability


Innovation

Innovation

In-Memory

Processing

Column-Based

Data Storage and

Access / Vertical

Table Decomposition

What makes SAP BI

with the BI accelerator

so fast?

Highly Parallel

Data Access /

Horizontal Partitioning

Dictionary-based,

Smart Compression

Using Integers


Introducing bi accelerator appliance 1

Introducing BI Accelerator Appliance - 1

System performance declining when increasing utilization

actionable information

SAP

NetWeaver

BI Server

Business User

System Performance

data

data

IT Department

data

data


Introducing bi accelerator appliance

Introducing BI Accelerator Appliance

Increase scalability and flexibility, w/o impacting architecture

actionable information

SAP

NetWeaver

BI Server

BIaccelerator

appliance

2004s

blade

Business User

blade

blade

System Performance

2004s

data

data

IT Department

data

data


Bi accelerator of sap netweaver architecture

BusinessExplorer

Any Tool

Preferred Technology Partner

SAP NetWeaver

2004s

SAP NetWeaver

2004s

Preferred Hardware Partners

BI Accelerator of SAP NetWeaver – Architecture

SAP NetWeaver BI

HPA Engine

Using

Adaptive Computing

AnalyticEngine

InfoCubes

DataAcquisition

Any

Source


Netweaver 2004s3

NetWeaver 2004s

1

Analytical Applications

2

BI Accelerator

3

Enterprise Data Warehousing

4

Enhanced Web & Excel Reporting

Integrated Planning

5


Modeling the edw flexibility

Modeling the EDW - Flexibility

Data Modeling

SAP NetWeaver 2004s provides additional flexibility for implementing new data models and changing existing ones.

  • Re-Modeling Toolbox Changing InfoCubes without rebuilding them from scratch – improved flexibility

  • Enhanced DataStore objects(formerly: ODS objects)Improved performance and flexibility

  • Enhanced InfoSets Improved flexibility

    • Integrate InfoCubes into join condition


Modeling the edw datasource concept

Modeling the EDW - DataSource Concept

Data Acquisition

SAP NetWeaver 2004s improves and streamlines the DataSource definition. In addition, it enhances remote access capabilities.

  • New DataSource conceptUnified and improved maintenance

    • E.g. Web Service (XML), UD Connect

    • Additional DataSources enabled for remote access (including flat files and DB Connect)

  • Enhanced remote capabilitesRemote master data access –no data replication, low TCO

    • Remote access of masterdata from source systems


Modeling the edw transformation concept

Modeling the EDW - Transformation concept

Transformation

SAP NetWeaver 2004s significantly improves transformation capabilities. The improved graphical UI contributes to decrease TCO.

  • TransformationImproved performance, flexibility and usability

    • Graphical UI

    • Unification and simplificationof transfer and update rules

    • New rule type: end routine

    • New rule type: expertroutine (pure coding oftransformation)

  • Unit Conversion Capabilities for unitconversion during dataload (and reporting)


Running the edw real time data acquisition

Running the EDW - Real-Time Data Acquisition

Data Flow Control

SAP NetWeaver 2004s improves and streamlines the data flow definition and the process chain set-up. In addition, it provides new real-time data acquisition capabilities that facilitate operational reporting:

  • Enhanced real-time data acquisition capabilitiesXML Web service

    • Direct push into PSA (instead of Service API/Delta Queue)

      Near-real-time InfoPackage & DTP

    • Daemon-based update fromdelta queue (BW Service API)

    • Daemon-based update ofDataStore objects(ODS layer) – including leanstaging (with minimizedlogging)


Edw further enhancements

EDW –Further enhancements

  • Modeling the EDW

    • Data Warehousing Workbench

      • Improved usability and lucidity

    • Content Analyzer and Content Browser

      • New overview-, search- and analysis capabilities for Business Content

  • Running the EDW

    • Process Chains

      • Additional functionality and process types

    • Data Quality

      • Improved error handling

    • Re-partitioning

      • Supports attaching, combining partitions or complete re-partitioning

    • New Analysis Authorization concept

      • Higher flexibility and simplified modeling


Netweaver 2004s4

NetWeaver 2004s

1

Analytical Applications

2

BI Accelerator

3

Enterprise Data Warehousing

4

Enhanced Web & Excel Reporting

Integrated Planning

5


Query reporting analysis designing a report

Query, Reporting & Analysis –Designing a Report

Designing a Report

  • Standard formatting: Font styles (e.g. bold, italic) and colors, etc.

  • Group level changes with individual formattings

  • Layout options, for example

    • Height of rows, width of columns

    • Multiline column headers

    • Flexible positioning of fields

    • Merger of cells

  • Support of hierarchies

  • Rules for the presentation of special characteristic values

  • Integration of texts, pictures, and charts

  • Header and footer for reports and pages

Report design takes place in the Business Explorer (BEx) Report Designer - a new, VB .Net-based tool that allows to create formatted, print-optimized reports.


Query reporting analysis designing a web application

Query, Reporting & Analysis – Designing a Web Application

  • Model-driven BI application building

    • Wizards for charts, maps, command editing

    • Wizard for layout elements (e.g. buttons)

    • „Intellisense“ support for Web API developers

    • Easy integration of native HTML commands

  • New layout elements (Tab strips etc.)

  • New Web items

  • New chart types, e.g. GANTT chart, MTA chart

  • Design of planning aware business applications

Designing a Web Application

Web application design takes place in the Business Explorer (BEx) Web Application Designer, a Visual Basic .NET-based, Unicode-compliant tool.


Intuitive ad hoc analysis bex web analyzer

Intuitive Ad-Hoc Analysis – BEx Web Analyzer

  • Web-based Ad-hoc Design Leveraging Drag & Drop

    • Easy navigation, when dropping characteristics on top of rows or columns

    • Easy filtering, when dropping a characteristics to filter area

    • Personalized Filters

    • Saving and distribution of analysis results through strong portal integration

    • Close integration to Information Broadcasting and Knowledge Management

    • Wizard-based definition of exceptions and conditions

    • Query creation on top of SAP BW and 3rd party data(via XMLA Connectors)

Drag andDrop


Bex web printing

BEx Web Printing

  • Comfortable PDF based BEx Web printing

    • Any type of BEx Web query, Report or Web Application can be converted to PDF and printed

    • Leveraging the SAP NetWeaver AS integration with Adobe Document Service

    • Adobe Acrobat Reader required, no plug-ins necessary

    • Printing options can be maintained globally or individually by an end-user

pdf-conversion of a web item


Excel integration workbook design with bex analyzer

Excel integration - Workbook Design with BEx Analyzer

Workbook Design

  • Application-building in Excel (similar to Web Application Designer)

  • New Options for Queries with 2 Structures

    • Excel Formulas allow access to any cell of the result set

    • Excel Formatting options can be fully leveraged for BEx Workbooks (e.g blank lines, fonts etc.

    • Combining Excel Formulas and Excel Formatting allows the design of High-End Formatted solution workbooks

  • Integration of Business Planning


Netweaver 2004s5

NetWeaver 2004s

1

Analytical Applications

2

BI Accelerator

3

Enterprise Data Warehousing

4

Enhanced Web & Excel Reporting

Integrated Planning

5


Business planning and analytical services wizard mode

Business Planning and Analytical Services – Wizard Mode

Planning Model Design – Wizard Mode –

  • Create a simple model of BI integrated planning by means of the Planning Wizard

    • Web based modeling environment for planning related tasks

    • Using the “Road map Pattern”


Business planning and analytical services planning layout design time

Business Planning and Analytical Services – Planning Layout Design-time

Query Design (BEx Query Designer)

Queries that are based on aggregation level are able to write back to the InfoProvider

  • Drilldown

  • Hierarchical data in rows

    and columns

  • Calculated key figures

  • Structures

  • Unit conversion

  • Alerts

  • Conditions

  • Graphics

  • Ad-hoc currency

  • Currency translation

  • BEx Web Application Designer

  • Create a layout

  • Configure a layout

  • Choose data binding

  • Configure interaction


Business planning and analytical services run time 2

Business Planning and Analytical Services – Run-time 2

Web Application Design – Example


Roadmap from bw to bi

Roadmap from BW to BI

BW Overview

BI Capabilities of NetWeaver 2004s

Business Advantage of NW2004s

Implementation Experience


Key business challenges

Key Business Challenges

  • Execution not aligned with Strategy

    • Strategy not communicated clearly

    • Individual objectives not aligned with strategy

    • Poor measurement, and no corrective actions

  • Ineffective Decision Making Processes

    • Decisions delayed, or made on ‘gut feel’ only

    • Key stakeholders not involved

    • Solid information only available to small ‘elite’

  • Increasingly Complex Operational Environment

    • Lack of insight into customer behaviour and trends

    • Opportunities frequently missed

  • Compliance Requirements

    • Calls for transparency

    • Increasing criticality of trustworthy data

Budget ConstraintsNeed to do more with less, and need to justify expenditures


Business advantage of nw2004s

Business Advantage of NW2004s

  • NW 2004s - Analytical Applications

  • Business actions based on informed decisions.

  • Ineffective Decision Making Processes

    • Decisions delayed, or made on ‘gut feel’ only

    • Key stakeholders not involved

    • Solid information only available to small ‘elite’


Business advantage of nw2004s1

Business Advantage of NW2004s

  • NW 2004s - Enterprise Data Warehousing

  • Truly scaleable solution

  • Supporting all BI needs of the organisation

  • Increasingly Complex Operational Environment

    • Lack of insight into customer behaviour and trends

    • Opportunities frequently missed


Business advantage of nw2004s2

Business Advantage of NW2004s

  • NW 2004s - BI Accelerator

  • Truly scaleable solution

  • Lower administration cost

  • Consistent and quick user response

Budget ConstraintsNeed to do more with less, and need to justify expenditures


Business advantage of nw2004s3

Business Advantage of NW2004s

  • NW2004s - Integrated Planning

  • Integration platform for analysis and planning.

  • Planning systematically delivered to all levels of the organisation

  • Execution not aligned with Strategy

    • Strategy not communicated clearly

    • Individual objectives not aligned with strategy

    • Poor measurement, and no corrective actions


Roadmap from bw to bi

Roadmap from BW to BI

BW Overview

BI Capabilities of NetWeaver 2004s

Business Advantage of NW2004s

Implementation Experience


Deployment of bw

Deployment of BW

R/3 Reporting

Information delivery in mySAP solution

Data Warehouse where SAP is one of the ERP solution

SAP Penetration

Analytical Application

Standalone Data Warehouse

BI Complexity


Phased roll out

Multi-Business

Data Warehouse

Business Unit

Data Warehouse

Subject Specific

Data Mart

Phased Roll Out

Size

Think big

but start small

Time


Start small and fast

Start small and fast

Scope of project

Additional Subjectareas

ExtendingContent

External Data

BW Content

Co

n

c

e

p

t

s

BW skill customer

Delivery Cycles


Rapid implementation step by step

Rapid Implementation step by step

  • Selected subject area

  • Defined scope

  • Business Content as a basis for implementation

  • Minor but User-significant enhancements

  • Achieve the 80% solution and demonstrate results

  • Receive feedback

    • Incorporate into subsequent delivery cycles

  • Rollout to other subject area (maybe in parallel)

  • Parallel work in frontend, extraction and datamodel team

  • Use the „power“ of BW

    • Extend with external data sources

    • Combine information from different applications


Benefit of the rapid implementation

Benefit of the Rapid Implementation

  • Rapid ROI / deliverable benefit to the business

  • Establish positive view of the product within user base

  • Establish stable technology infrastructure early in project

  • Transfer overall product knowledge to ensure subsequent implementations are appropriately resourced

  • Train members of the implementation team


Suolution manager accelerated bw method tools

Suolution Manager & Accelerated BW Method & Tools

  • Highest Level: Maps to ASAP

  • Lowest Level: Incorporates BW-Specific Activities / Accelerators

  • Key Enablers: Included to Assist the Customer and Consultant

  • Evolving: Continually Being Refined and Enhanced by BW experts in development and consulting


Skills

Skills

  • The skills required will be driven by the scope of the implementation

  • Scope of Implementation

    • Business Contents with minor enhancements?

    • Significant non-SAP data sources?

    • Enterprise Data Warehouse?

  • Skills

    • BW Implementation experience

    • Operational users

    • SAP source knowledge

    • Data Warehousing architecture

    • BASIS / WAS knowledge


Project team structure

Project Team Structure

IT Business

Business

Key Users

DW Architect

BW Solution

Architects

Project Maturity

Business

Key Users

BW

Administrator

Business

Key Users


Implementation team mix of resource

Implementation Team - Mix of Resource

SAP/ Partner

Consulting Effort

Internal

Time


Key success factors

Key Success Factors

  • Management buy-in

  • Involve user community early in the project life cycle

  • Strong implementation team

    • Business understanding & empowerment

    • SAP skills

    • BW knowledge

    • DW skills

  • Rapid, step-by-step, reiterative implementation

    • delivery cycle concept

    • early success

    • feedback


Roadmap from bw to bi

Roadmap from BW to BI

BW Overview

BI Capabilities of NetWeaver 2004s

Business Advantage of NW2004s

Implementation Experience


  • Login