SAP NetWeaver BW - in 2010 SAP NetWeaver BW Solution Management

SAP NetWeaver BW What’s new with SAP NetWeaver BW 7.2 and
in 2010
SAP NetWeaver BW Solution Management
September 2009
Planned RampUp Start: Q1/2010
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, except if
such damages were caused by SAP intentionally or grossly negligent.
© SAP AG 2009. All rights reserved. / Page 2
Goal of this presentation
Scope:
This presentation provides an overview on the new capabilities coming with SAP
NetWeaver BW 7.20.
In addition the major enhancements delivered with the Enhancement Packages 1
and 2 for SAP NetWeaver BW 7.0 are highlighted as well.
Target audience:
Internal and external - familiarity with SAP NetWeaver BW 7.0 as a prerequisite
Restrictions:
Please note that several platform restrictions apply (e.g. it is not possible to upgrade
a BW system that is used in an embedded scenario or as SEM Add-on...) Details are
described in the limitations note 1380307.
© SAP AG 2009. All rights reserved. / Page 3
Executive Summary
Major use cases shipped with SAP NetWeaver BW 7.20 are:
Further integration of SAP BusinessObjects BI and EIM tools
Enable Teradata and HP Neoview as additional databases for SAP NetWeaver BW
Load performance optimizations via accelerated DataStore activation
Extending the value of SAP NetWeaver BWA and SAP Business Objects Explorer
for additional scenarios
Enhanced flexibility in data modeling, e.g. automated partitioning within InfoProviders
© SAP AG 2009. All rights reserved. / Page 4
SAP NetWeaver BW 7.20
Key delta capabilities
Scalable data models with built-in Semantic Partitioned Object
Performance &
Scalability
Performance DataStore objects
Enhanced built-in analytical capabilities for SAP NetWeaver BW Accelerator
Enable Teradata / HP Neoview as databases for SAP NetWeaver BW
Performance Improvements Integrated Planning
Total cost of
Development
Total Cost of
Operations
Integration with
BusinessObjects
Modeling and
administration
© SAP AG 2009. All rights reserved. / Page 5
Combining real-time transactional data with historical data via HybridProvider
Simplified data flow modeling with data flow copy- and data flow migration tool
Faster system set-up with a wizard-based system configuration
Enhanced monitoring capabilities with new content for SAP NetWeaver BW
Administration Cockpit
Tighter Integration SAP NetWeaver BW with SAP BusinessObjects Data Services and
SAP BusinessObjects Metadata Management
Optimized integration of SAP Business Objects BI Tools Xcelsius, WebI, Crystal
Reports)
Generic delta capabilties for UD-Connect- , DB Connect- , Flat File DataSources
Hierarchies integrated into SAP NetWeaver BW 7.x data flow, Direct Access for
Hierarchies
Agenda
Preliminary and Latest Enhancements
1.
2.
3.
4.
Business Objects Integration
Enterprise Data Warehousing
SAP NetWeaver BW Accelerator
SAP NetWeaver BW Integrated Planning
© SAP AG 2009. All rights reserved. / Page 6
Business Objects Integration
Tighter Integration with SAP NetWeaver BW 7.2 and SAP BusinessObjects Tools
SAP BusinessObjects Data Services XI 3.2
Tighter integration of BusinessObjects Data Integrator into extended SAP NetWeaver BW
data flow concept (DataSource)
Use SAP BusinessObjects Data Integrator to schedule loading processes of SAP
NetWeaver BW
Execute and control process chains from SAP BusinessObjects Data Services to extract
data via Open Hub Service
SAP BusinessObjects Metadata Management XI 3.2
End-user access to data lineage information for trusted SAP NetWeaver BW deployment
Change impact analysis between SAP NetWeaver BW objects such as DataStore objects,
InfoSets, BEx Queries, and InfoCubes
End-to-end capabilities for all data sources through SAP BusinessObjects Data Services
© SAP AG 2009. All rights reserved. / Page 7
Business Objects Integration
Tighter Integration with SAP NetWeaver BW 7.2 and SAP BusinessObjects Tools
Already available since Release 7.01 SP3:
SAP BusinessObjects WebIntelligence
Performance improvements for MDX Statements
SQL access via SAP BusinessObjects DataFederator
Already available since Release 7.01 SP 5:
SAP BusinessObjects Xcelsius
Xcelsius to leverage SAP NetWeaver BW BICS (BI Consumer Service Interface) for a
direct and lean access to data of SAP NetWeaver BW
© SAP AG 2009. All rights reserved. / Page 8
Agenda
Preliminary and Latest Enhancements
1.
2.
3.
4.
Business Objects Integration
Enterprise Data Warehousing
SAP NetWeaver BW Accelerator
SAP NetWeaver BW Integrated Planning
© SAP AG 2009. All rights reserved. / Page 9
Enhanced modeling capabilities to increase
scalability , flexibility and reduce total cost of
development
Semantic Partitioning
Semantic partitioned object (SPO) as a
single point of entry for creation and easy
administration of the semantic partitioned
data model
Semantic Partitioned Object (SPO)
Enterprise Data Warehousing
Performance & Scalability
Wizard based partitioning of InfoCubes
and DataStore objects along criteria such as
calendar year or region to manage high volume
data across different time zones.
Reduces TCO to define and manage scalable
data models also when it comes to re-model
the partitions (because only the Reference
structure needs to be changed)
Source1
Source2
Source3
Automated generation of corresponding modeling objects like data transfer processes
(including respective filter criteria depending on the data target) and transformations as well
as a process chain.
Good Query performance by leveraging SAP NetWeaver BW Accelerator as well as
partition pruning when accessing partitioned InfoCubes
Semantic Partitioned Object can be embedded into a MultiProvider
© SAP AG 2009. All rights reserved. / Page 10
Enterprise Data Warehousing
Performance & Scalability
Accelerated data loads by optimized data activation for DataStore Object
DataStore objects
Partitioning: Support database partitioning by time characteristics
Remodeling for DataStore objects
Performance improvements:
Activation is changed from single lookups to package fetch of active table
Runtime option “new, unique data records only” prevents lookups during
activation, e.g. in case of initial loads
Performance gain for package fetch (lab results)
Avg. 20 – 40% improvement
Max. improvement measured – 2.5x faster
Varies by data profile (#inserts/updates/deletes) and database platform
Already available since Release 7.01:
Disable delta consistency check for write-optimized DataStore objects
Protects delta requests that have been already propagated per delta
mode from deletion.
Can be switched on/off – e.g. for write-optimized DataStore objects as initial staging layer
© SAP AG 2009. All rights reserved. / Page 11
Enterprise Data Warehousing
Performance & Scalability
Transparent access to Near-Line Storage archives for MultiProviders
Near-Line Storage (NLS)
Integration into Data Mart Layer (Support of MultiProviders)
Enable NLS in Query properties from BEx Query Designer
(not necessary to do this in RSRT anymore)
Selections on navigational attributes will be passed to NLS
Already available since Release 7.01:
NLS Interface supported for write-optimized DataStore objects
ADK Archiving supported
Based on request Id
Load date of request or creation date of request
Semantic grouping
NLS Interface extension for lookups
A look up API supports access to NLS partitions of InfoProviders during
transformations. The API has to be called using ABAP routines.
Archiving of uncompressed InfoCube data
© SAP AG 2009. All rights reserved. / Page 12
Enterprise Data Warehousing
Performance & Scalability
Expanding the data warehouse landscape with support for Teradata and
HP Neoview
SAP NetWeaver BW running on the
Teradata and HP Neoview databases
Consolidates data on one database platform, while
lowering cost of ownership
Seamlessly integrate SAP content-rich applications,
leveraging SAP NetWeaver BW and the performance
of SAP NetWeaver BW Accelerator with the power and
scalability of Teradata and HP Neoview
Integrate Teradata and HP Neoview into SAP support
infrastructure
Simplify data integration strategy
for SAP and non-SAP data
Reduce complexity and time needed to
integrate data for BW and Teradata and HP
Neoview
Increase visibility to detailed data for richer
business insight and faster decision making
Currently planned availability in 2010
© SAP AG 2009. All rights reserved. / Page 13
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.
Enterprise Data Warehousing
Cost of Development
Reduced development efforts via automated tool support
Data Flow copy tool
Copy an existing SAP NetWeaver BW 7.x data flow, i.e. data sources, data targets,
and transformations leveraging a wizard-like user interface.
Complete copy an existing process chain (incl. related process variants and data flow objects)
Possibility to copy a data flow to a source system which is only available in the productive system
landscape by assigning a dummy source system in the development environment.
Data Flow migration tool (3.x
7.x)
Migration of data flows with 3.x objects (3.x InfoSource, 3.x DataSource, transfer rules, update
rules) including adaption of InfoPackage, process variants, process chains, VirtualProviders
(‘Remote Cubes‘)
Workbench-like UI for selecting data flows and objects to be migrated
Restore of 3.x data flow (from snapshots of the objects made during migration) supported
© SAP AG 2009. All rights reserved. / Page 14
Enterprise Data Warehousing
Cost of Operations
Enhanced monitoring with new content for the SAP NetWeaver BW Administrator Cockpit
Monitoring
New Monitors in BW Administration Cockpit
Database usage in SAP NetWeaver BW
Display the usage of database space
(e.g. in MB by InfoProviders).
Further Enhancements of the technical content
OLAP cache and SAP NetWeaver BW
Accelerator usage
Queries which display the OLAP usage,
Cache memory and SAP NetWeaver BW
Accelerator status.
RDA Monitoring
Display the status of usage and free
capacity of RDA daemons in the system
© SAP AG 2009. All rights reserved. / Page 15
Enterprise Data Warehousing
Cost of Operations
Simplified system installation and setup via wizard based system configuration
Wizard-based system Configuration
Ensuring a proper and smooth installation,
and technical configuration for the set-up
of a BW system to a major extent.
Both ABAP and Java stack configuration
is possible for the new installation of 7.2
Already available since Release 7.01:
Further wizard based templates for TCO Reduction
BI Initial Setup for ABAP
Wizards for Business Suite 7 for faster Integration
© SAP AG 2009. All rights reserved. / Page 16
Enterprise Data Warehousing
Real-Time Business Intelligence
Implement operational reporting scenarios
leveraging new modeling objects
Real-Time Query
HybridProvider
Combines real-time information
with historic data
Enables SAP NetWeaver BW Accelerator
for DataStore objects
HybridProvider
Scenario 1 (direct Access)
InfoCube
w/ BWA
Automatic generation of data flow
within HybridProvider considering
which underlying objects have
been chosen
Virtual
HybridProvider
Scenario 2 (RDA)
Transactional
Delta
InfoCube
Direct access
Transfer
InfoCube
w/ BWA
(Real-Time) Data Acquisition
OLTP
Scenario 1 (with InfoCube and VirtualProvider):
Direct access to source system leveraging a Virtual InfoProvider with a function module
Scenario 2 (with InfoCube and DataStore Object):
DataStore object can be fed by a Real-Time Data Acquisition (RDA) data flow (not a must!)
Create Queries with BEx Query Designer upon Classical InfoSets in SAP ERP 6
Enable Classic InfoSets in SAP ERP 6 (EhP 5 onwards) to be basis for reports created with SAP
NetWeaver BW BEx Suite
Operational Reporting via BEx on SAP ERP w/o replication of data to SAP NetWeaver BW
Enhancements Real –Time Data Acquisition
Possibility to load master data with RDA
Enhanced error handling and scalability (daemon can handle more DataSources more efficiently)
© SAP AG 2009. All rights reserved. / Page 17
Enterprise Data Warehousing
Data Extraction
Enriching administration and enhanced delta functionalities
Generic Delta functionalities for further types of DataSources
The possibility to derive a generic delta is now available for further types of DataSources
like: DB Connect, UD Connect, flat file and web service
Automatic switch of InfoPackages from Init- to Delta Load
There is no need to define Init- and Delta InfoPackages anymore.
If a delta enabled InfoPackage is started the first time, it is executed
as an initial load.
New DataSource Adapter Type ‘Web Service Pull’
A new type of web-service-based DataSource can be created which pulls data from a 3rd
party source system into PSA.
Available for transactional data and master data (except hierarchies)
Initially available for pilot customers and partners only (i.e. the function is there and can
be activated quickly)
© SAP AG 2009. All rights reserved. / Page 18
Enterprise Data Warehousing
Data Staging
Additional flexibility within the data transfer process
Hierarchies
Integration of hierarchies into process flow (DTP, transformation)
Remote hierarchies for direct access to hierarchies in the source system
Loading hierarchies from flat file using the new DataSource and transformation technology
Data Transfer Process (DTP)
Option to fetch only the last request from a given source (available for full load DTPs)
Data Transfer Process (DTP) supports referential integritiy checks tor navigational attributes of the
target InfoObject during the load of master data (Feature available since Release 7.01)
Open Hub Service
SAP NetWeaver BW data can be exported in XML format
Possibility to change the format and length of BW data for export even into a non-SAP specific format
Transformation
Semantic grouping possible in transformations (in addition to semantic grouping in DTPs)
Possibility to select the InfoObjects (fields) the user wants to use in a Start- / Endroutine
Currency and unit conversion also available for DataStore object and InfoSource as target of a
transformation.
Navigation attributes of InfoCubes/DataStore objects can be used as source fields in the
transformation and as filter/select options in the DTP
When a new transformation object is created the system generates a proposal by mapping fields of
the DataSource to InfoObjects
© SAP AG 2009. All rights reserved. / Page 19
Enterprise Data Warehousing
Data Staging
Enriched functionalities for a more efficient use of process chains and
PSA/Change Log tables
General enhancements in process chain error handling
ABAP program for controlled suspension and re-starting of all process chains and RDA daemons
during restart of the application server. (Name of program: RS_SYSTEM_SHUTDOWN)
Enhanced transaction RSPCM for better process chain monitoring:
Option to refresh the status of all chains or only the status of the process chains currently
running
Saving the configuration user dependently
Deviation of start- and runtimes as new keyfigures with self-adopting thresholds.
Overview of errors for failed process chain executions
Already available since Release 7.01:
Flexible deletion of PSA/Change Log
By using selection patterns
Patterns support DataStore Object and InfoArea or DataSource and Source System
Changed process types for flexible deletion of requests from PSA and Change Log by using selection
patterns. Placeholders can be used for the fields DataStore Object and InfoArea or DataSource and
source system. This has the advantage that all requests for objects that are named after a specific
naming convention are always selected.
© SAP AG 2009. All rights reserved. / Page 20
Enterprise Data Warehousing
Administration
Enriched functionalities for the Administrator
Multi Source System InfoPackage transport
Transporting a data staging scenario with automatic handling of InfoPackage
assignment to more than one source system.
Before Export Check
Enhanced consistency check at the end of releasing the transport
including checks on dependent objects which are not directly included in the transport request to
prevent data loading errors in the target system (due to inactive metadata objects)
Data request archiving for DTP requests
The table which holds all monitor entries for DTPs tends to grow very big
over time. A new feature is available to archive this kind of data to speed up DTP monitor
General search in Data Warehousing Workbench extended
General search is extended to process chains, OpenHub destinations. Moreover TREX Search
is leveraged for DataSources, Transformations, InfoSources and DTP‘s
Bulk Change function for authorizations
Selecting and editing of multiple authorization objects at the same time.
Delete content of table holding warehouse management related statistics data
The ABAP program RSDDSTAT_DATA_DELETE was enhanced to also be able to delete the content
of table RSDDSTATWHM which is constantly growing over time (all entries up to a certain date)
© SAP AG 2009. All rights reserved. / Page 21
Agenda
Preliminary and Latest Enhancements
1.
2.
3.
4.
Business Objects Integration
Enterprise Data Warehousing
SAP NetWeaver BW Accelerator
SAP NetWeaver BW Integrated Planning
© SAP AG 2009. All rights reserved. / Page 22
SAP NetWeaver BW Accelerator
New business scenarios
Taking the BW Accelerator to the next level of performance
Enable additional InfoProviders
DataStore objects and
Virtual InfoProvider
(via HybridProvider )
Web
Intelligence
Pioneer
Explorer
…
SAP BusinessObjects BI Platform
Analytic/Calculation Capabilities
Top N/Bottom N
Improved MultiProvider handling
Calculation
Capabilities
Master Data Support
Index master data texts
and hierarchies
Business
Warehouse
Index
Aggregation
Accelerate master data reporting
Accelerate value help
© SAP AG 2009. All rights reserved. / Page 23
SAP NetWeaver BW
SAP NetWeaver BW Accelerator
SAP NetWeaver BW Accelerator
New business scenarios
Infocube persistence in SAP NetWeaver BWA only
InfoCube
(Definition)
Optional persistency for InfoCube data in SAP NetWeaver
BW Accelerator only
Persists data of InfoCubes only in SAP NetWeaver BWA to:
Reduce data redundancy
Save disk space
Increase data base performance
by reducing system load
E- and F- fact tables as well as dimension tables are indexed
Master data will be persisted in both SAP NetWeaver BW and
SAP NetWeaver BW Accelerator
A normal Data Transfer Process can be used to load
data directly into SAP NetWeaver BW Accelerator
Data of a downstream DataStore-objects can be replicated
into BWA w/o InfoCube DB persistency
© SAP AG 2009. All rights reserved. / Page 24
Source System
BWA
Agenda
Preliminary and Latest Enhancements
1.
2.
3.
4.
Business Objects Integration
Enterprise Data Warehousing
SAP NetWeaver BW Accelerator
SAP NetWeaver BW Integrated Planning
© SAP AG 2009. All rights reserved. / Page 25
SAP NetWeaver BW Integrated Planning
Continued investments in SAP NetWeaver BW integrated planning
Already available since Release 7.01:
Statistic data is gathered for SAP NetWeaver BW Integrated Planning
events are integrated to SAP NetWeaver BW AdminCockpit
Individual locking of cells in a planning layout
Already available since Release 7.01 SP 05:
Calculation Engine
Inverse Formulas
Inverse formulas allow the user to enter values for each component of the
equation, even the calculated keyfigure (price in this case).
System automatically calculates values for the missing operands by taking the
respective formula (customized in the planning layout definition) into
consideration.
Contribution of percentage values
The percentage contribution of a particular product to the overall sales.
(Entering a percentage value, defined as the percentage contribution of some
other key figure with respect to the overall sum )
© SAP AG 2009. All rights reserved. / Page 26
SAP NetWeaver BW Integrated Planning
Continued investments to improve performance of SAP NetWeaver BW
integrated planning
Already available since Release 7.01 SP6:
New capabilities in the area of performance improvements:
Cell checks will be grouped by higher granular selections and the checks applied
on this granularity
Today cell checks are done on cell level. Thus checks semantically bound to rows,
columns or other selections are executed redundantly.
Reduce redundant execution of planning functions
Today planning functions are executed completely whenever they are called,
regardless whether the execution will impact the data or not.
A design time option is introduced to deliver only those cells to a planning function, that
are changed since the last planning function execution.
© SAP AG 2009. All rights reserved. / Page 27
© Copyright 2009 SAP AG
All Rights Reserved
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 is a registered trademark of Oracle Corporation.
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.
Java is a registered trademark of Sun Microsystems, Inc.
JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, 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 S.A. in the United States and in other countries.
Business Objects 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.
These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only,
without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group
products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed
as constituting an additional warrant.
© SAP AG 2009. All rights reserved. / Page 28