SAP BW/BI ppt

1
Roadmap from BW to BI
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Implementation Experience
2
Roadmap from BW to BI
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Implementation Experience
3
SAP BW A success story
Active BW Customers gt 6,500
How do you planto leverage SAP BW?
Are you satisfiedwith SAP BW?
Approximate Data Volume
Number of Users
gt 10,000
gt 5 TB
1
1
Mixed data 64
1,000 - 10,000
Yes
13
lt 50
0 - 100 GB
1 - 5 TB
95
24
26
23
250 - 1,000
23
SAP data only 36
500 GB - 1 TB
50 - 250
100 - 500 GB
18
39
32
No
5
4
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

5
SAP Business Warehouse (BW)
An integrated end-to-end Data 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, KPIs 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

6
SAP Business Intelligence
Other
3rd Party
Finance Projects
Sales Interfaces
Credit Control
Sales
7
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

8
Authors Analysts
9
Business Managers
10
Executives
11
BW release 3.5 Overview
1
Information Broadcasting
2
Universal Data Connection
3
NetWeaver Integration
4
Business Planning Simulation (BPS)
Advanced Analytic functionality
5
12
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.
13
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)

14
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

15
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

16
BW release 3.5 Overview
1
Information Broadcasting
2
Universal Data Connection
3
NetWeaver Integration
4
Business Planning Simulation (BPS)
Advanced Analytic functionality
5
17
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
JDBC
Custom-built Applications
ODBO
1. BI Java Connectors JDBC, XMLA,ODBO, SAP Query
3. BI Java SDK Java API, Examples, Documentation
18
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

19
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
20
BW release 3.5 Overview
1
Information Broadcasting
2
Universal Data Connection
3
NetWeaver Integration
4
Business Planning Simulation (BPS)
Advanced Analytic functionality
5
21
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
22
BW release 3.5 Overview
1
Information Broadcasting
2
Universal Data Connection
3
NetWeaver Integration
4
Business Planning Simulation (BPS)
Advanced Analytic functionality
5
23
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

24
Planning cycles
Strategic Planning and Target setting on group
level
Operational Planning and Budgetingin the
business units
Plan evaluation
25
SAP BI Planning Architecture
Planning Front Ends
Presentation
Excel Inplace
Excel Client
HTML in GUI
ALV Grid
Portal based
Open Interface and Web Services
Planning Framework
Business Logic
AutomaticPlanning
Manual Planning/Analysis
Modeling
Process control
Common Read / Write Interface
Access / Storage
DWH Layer
Dimensional Data
Master Data
Granular Data
Master Data
Data Acquisition
26
BW release 3.5 Overview
1
Information Broadcasting
2
Universal Data Connection
3
NetWeaver Integration
4
Business Planning Simulation (BPS)
Advanced Analytic functionality
5
27
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

28
Web Application Designer
Chart Designer Wizard (Reduced Overview)
Result
29
Data Mining Methods - Explorative
Clustering
ABC Classification

• 20 of customers generate 60 of sales

Association Analysis
Weighted Score Tables
Weight
Score


Customer Age Gender Income


30
Data Mining Methods - Predictive
Regression
Decision Trees
Complaints
gt4
lt4
Complaints
?
Gender
Age
Gender
M
Buy
F
Sales
Income
Income
of Products
lt30 k
gt30 k
31
Analysis Process Designer

• Graphical modeling (dragdrop) 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.

32
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
33
Roadmap from BW to BI
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Implementation Experience
34
NetWeaver 2004s
1
Analytical Applications
2
BI Accelerator
3
Enterprise Data Warehousing
4
Enhanced Web Excel Reporting
Integrated Planning
5
35
SAP NetWeaverThe 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
• Its SAP Enterprise Services Architecture
  increases business process flexibility

36
The Business Intelligence Platform
Web Presentation/Portal/Mgmt Reporting
Presentation
Consolidation
Modeling and Optimization
Ad Hoc Query and Reporting
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)
37
The SAP NetWeaver BI Platform
Web Presentation/Portal/Mgmt Reporting
Consolidation
Modeling and Optimization
Ad Hoc Query and Reporting
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
38
NetWeaver 2004s
1
Analytical Applications
2
BI Accelerator
3
Enterprise Data Warehousing
4
Enhanced Web Excel Reporting
Integrated Planning
5
39
WHAT IS NEW ANALYTICS?
Example Sales Order Fulfillment process
Creation Purchase Order
40
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?
41
Visual Composer Model
42
(No Transcript)
43
NetWeaver 2004s
1
Analytical Applications
2
BI Accelerator
3
Enterprise Data Warehousing
4
Enhanced Web Excel Reporting
Integrated Planning
5
44
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

45
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
46
Innovation
Column-Based Data Storage and Access /
Vertical Table Decomposition
In-Memory Processing
What makes SAP BI with the BI accelerator so
fast?
Highly Parallel Data Access / Horizontal
Partitioning
Dictionary-based, Smart Compression Using Integers
47
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
48
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
49
BI Accelerator of SAP NetWeaver Architecture
SAP NetWeaver BI
HPA Engine Using Adaptive Computing
AnalyticEngine
InfoCubes
DataAcquisition
Any Source
50
NetWeaver 2004s
1
Analytical Applications
2
BI Accelerator
3
Enterprise Data Warehousing
4
Enhanced Web Excel Reporting
Integrated Planning
5
51
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

52
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

53
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)

54
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)

55
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

56
NetWeaver 2004s
1
Analytical Applications
2
BI Accelerator
3
Enterprise Data Warehousing
4
Enhanced Web Excel Reporting
Integrated Planning
5
57
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.
58
Query, Reporting Analysis Designing a Web
Application
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

Web application design takes place in the
Business Explorer (BEx) Web Application Designer,
a Visual Basic .NET-based, Unicode-compliant
tool.
59
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
60
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
61
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

62
NetWeaver 2004s
1
Analytical Applications
2
BI Accelerator
3
Enterprise Data Warehousing
4
Enhanced Web Excel Reporting
Integrated Planning
5
63
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

64
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

65
Business Planning and Analytical Services
Run-time 2
Web Application Design Example
66
Roadmap from BW to BI
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Implementation Experience
67
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
68
Business Advantage of NW2004s
Ineffective Decision Making Processes Decisions
delayed, or made on gut feel only Key
stakeholders not involved Solid information only
available to small elite

• NW 2004s - Analytical Applications
• Business actions based on informed decisions.

69
Business Advantage of NW2004s
Increasingly Complex Operational Environment Lack
of insight into customer behaviour and
trends Opportunities frequently missed

• NW 2004s - Enterprise Data Warehousing
• Truly scaleable solution
• Supporting all BI needs of the organisation

70
Business Advantage of NW2004s
Budget ConstraintsNeed to do more with less, and
need to justify expenditures

• NW 2004s - BI Accelerator
• Truly scaleable solution
• Lower administration cost
• Consistent and quick user response

71
Business Advantage of NW2004s
Execution not aligned with Strategy Strategy not
communicated clearly Individual objectives not
aligned with strategy Poor measurement, and no
corrective actions

• NW2004s - Integrated Planning
• Integration platform for analysis and planning.
• Planning systematically delivered to all levels
  of the organisation

72
Roadmap from BW to BI
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Implementation Experience
73
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
74
Phased Roll Out

Size
Think big but start small
Time
75
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
76
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

77
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

78
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

79
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

80
Project Team Structure
IT
Business
Business Key Users
DW Architect
BW Solution Architects
Project Maturity
Business Key Users
BW Administrator
Business Key Users
81
Implementation Team - Mix of Resource
SAP/ Partner
Consulting Effort
Internal
Time
82
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

83
Roadmap from BW to BI
BW Overview
BI Capabilities of NetWeaver 2004s
Business Advantage of NW2004s
Implementation Experience