sap bw 7.4 powered by sap hanafm.sap.com/data/upload/files/2_bw 74 chicago workshop.pdf · october...
TRANSCRIPT
October , 2014
SAP BW 7.4 Powered by SAP HANA
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 businessoutlined 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 withoutnotice. 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 oromissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.
AgendaIntroductionEDW with BW on HANAOLAP with BW on HANABW Content optimized for HANAPlanningOutlookBusiness Benefits
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 4This 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 andpossible 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’s strategic EDW solutionSAP BW 7.4 on HANA
Only the combination of BW and HANA enables us to
… simplify the data modeling processes
… increase the agility of the Enterprise Data Warehouse
… reduce the complexity of the EDW landscape
… combine the strengths of an SQL oriented approach with an Integrated EDW application
Seamlessconsumption
of data
Reuse BWservices to
manage andanalyze the data
One commonmodeling
environment
Process largeamounts of data
faster
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 5This 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 andpossible 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 BW on HANA – Smarter, simpler, more efficientHow Does BW running on RDBMS differ from BW running on HANA ?
Customer value of SAP BW powered bySAP HANA
Excellent query performancefor improved decision makingPerformance boost for Data Load processesfor decreased data latencyAccelerated In-Memory planning capabilitiesfor faster planning scenariosFlexible combine EDW with HANA-nativedata for real-time insights and decision makingData persistency layers are cut off andreduced administration effortsSimplified data modeling and remodeling
Data intensive functions are pushed downfrom BW to HANA
HANA Stack
RDBMS
Traditional Stack
SAP NetWeaver BW
Data Modeling
Planning
Data Management
OLAPProc
ess
Orc
hest
ratio
n
Data Schema&
Data
SAP BW on HANA
Data Modeling
Planning
DataManagement
OLAPProc
ess
Orc
hest
ratio
n
Push Down
HANA as the Primary Database for BW andFoundation for new Applications
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 6This 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 andpossible 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.
Evolving In-Memory Footprint in SAP BWOverview
Planning Engine
Data Manager
InfoCubes
DataStore Objects
Analytic Engine
Data Persistency andRuntime
DataModeling
Ent
erpr
ise
Dat
aW
areh
ouse
and
Dat
aM
artM
odel
ing
with
SA
PN
etW
eave
rBW
Ent
erpr
ise
Dat
aW
areh
ouse
and
Dat
aM
artM
odel
ing
with
SA
PN
etW
eave
rBW
BWA instead ofaggregates
filter +aggregation
BWA-onlyInfoCubes
BWA reportingfor DSOs
reporting +activation for
DSOs in-memory
in-memoryplanning engine
first calculationscenarios in BWA
additionalcalculationsin-memory
MultiProviderhandling and flexible
joins
BW 7.0DB + BWA 7.0
BW 7.3DB + BWA 7.2 BW 7.4 on HANA
Data Provisioning
In-Memory optimizedInfoCubes
Consumption ofHANA models in BW
HANA data forBW Staging
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 7This 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 andpossible 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 BW 7.4 Powered by SAP HANASUPERCHARGED
• Lower TCO• Reduce IT Workloads• Simple to implement (no disruption)• Simpler data modeling
• Field based Modelling via Open ODS• Direct HANA access• Smart Data Access
• Up to 100xs Faster Reporting and Analytics• Decrease Data Latency by 5x–10x• Push down further processing logic to HANA
• Improved Access to ALL data• Empower Self Service (Workspaces)• Operational Data Provisioning (OPD) via SLT
Machine Intensive Processing Logic Pushed Data To SAP HANADramatically improved performance with machine intensive processes andoperations pushed to SAP HANABW Analytic Manager (OLAP Complier ) operations now run in SAP HANABW Transformations – optimized to run in SAP HANA
Faster Data Loading and ProvisioningInformation loaded more frequently enabling faster reporting and access toinformationHANA Optimized InfoCubes and DataStore Objects (DSO) speeds up datastaging of DSOs for decreased data latency
Faster PlanningNext level of performance by pushing down further planning capabilities toHANADeliver precise business planning & prediction on any data at ANY level
AgendaIntroduction – evolving BW on HANA to HANABWEDW with BW on HANAOLAP with BW on HANABW Content optimized for HANABW Integrated PlanningOutlookBusiness Benefits
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 9This 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 andpossible 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.
HANA Optimized DataStore Objects
HANA optimized DSOsDelta calculation completely integrated in HANAUsing in-memory optimized data structures forfaster accessNo roundtrips to application server neededSpeeding up data staging to DSOs by factor 10Avoids storage of redundant dataAfter the upgrade to BW on HANA all DSOsremain unchangedTool support for converting standard DSOs intoHANA optimized DSOsNo changes of data flows required
DatabaseLayer
DatabaseLayer
User interfaceLayer
User interfaceLayer
ApplicationLayer
ApplicationLayer
Presentation
DSO Objects
Activation
Data
Presentation
DSO Objects
Activation
Data
SAP NW BW
SAP NW BW SAP NW BW
SAP NW BW
SAP HANAxDB
HANA Optimized DSOs provide faster activation times!
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 10This 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 andpossible 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.
Classic Infocube HANA Optimized Infocube
Classic BWStar Schema
HANA OptimizedStar Schema
SAP HANA optimized InfoCubes represent “flat” structuresUp to 5 times faster data loadsFaster remodeling of structural changesAfter the upgrade to BW on HANA all InfoCubes remain unchangedTool support for converting standard InfoCubes (sample result: 250 Million records in 4 minutes)No changes of processes, MultiProviders, Queries required
No dimension tablesNo second fact tables
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 11This 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 andpossible 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.
Adoption of HANA-Optimized DataStore ObjectReduction of persistent layers by adopting BW on HANA
InfoCube can be removed when onlyused for aggregation
CompositeProvider
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 13This 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 andpossible 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.
CompositeProviderSAP BW 7.4, SP5 on HANA
Easier data modeling and reduction of InfoProvidertypes by enhancing the CompositeProvider
SupportsConsolidation of existing CompositeProvider, MultiProvider,TransientProvider on HANA Models, VirtualProvider on HANAModels* and InfoSet* into CompositeProviderUse CompositeProvider as single BW metadata object tocombine data from other HANA based applications on the sameinstance of HANA (consumption of native HANA models ortables) with data in BW
– Faster Implementations– More flexibility – Unions and Joins– Easier consumption of data– HANA optimized query runtimes
Modern Eclipse based UIOption to include Inventory key figuresPossibility to include in planning scenarios
Prototypinginvolving Business
UserClassical Datawarehouse
SchemaOther SAP HANA Schema
BWWorkspace
CompositeProvider
Combine the data of various applications
Operational or Real-timeDatamart
Table
Model View
SQL MDX BICS ODATA
SAP and non SAP ApplicationsSAP and non SAP Applications
External Database Hadoop ERP BW
SAP BW Schema
HANA model generation
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 15This 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 andpossible 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.
Automatic generation of HANA modelsSAP BW 7.4, SP5 on HANA
BW Schema
generates
HANA Schema
HANAView
InfoCube
DSO
Masterdata
HANAView HANA
View
EnhancedHANA View
Enhanced Metadata interoperability between BW and HANA
HANA Model generationTriggered from BW InfoProvider – push
– Complements BW model import from HANA Modeler– Analysis Authorization: Automatic sync between HANA and BW– Object changes include HANA model impact analysis
Direct consumption of BW data via generated HANA views– SAP Lumira, BO Explorer, SQL
ScenarioMajor footprint of scenario in BWUsage of generated view in HANA Studio to build own datamodels using BW data and HANA native algorithms
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 16This 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 andpossible 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.
Integration Scenarios HANA Live – SAP BW
Classical Datawarehouse SchemaOther SAP HANA Schema
CompositeProvider
Combine the data ofvarious applications
Operational or Real-time Datamart
SQL MDX BICS ODATA
SAP and non SAP ApplicationsSAP and non SAP Applications
External Database Hadoop ERP BW
SAP BW Schema
SAP HANA Live
VirtualAccessSD FI …
Tables
VDMHANAViews
HANA Data Models
HANA Views, PredictiveFunctions etc.
Easy consumption of HANA Data Models in BWand vice versa
Integration of HANA Models in BW InfoProviderstructuresTransfer data from HANA Schema to SAP BWAutomatic generation of HANA Views (and optionalauthorization objects) for BW InfoProviders
Unlimited Flexibility for new BusinessScenarios
Combination of HANA Live operational realtime datawith SAP BW dataLeverage HANA platform capabilities like PredictiveAnalytics Library directly on SAP BW dataIntegration of further Big Data sources to deliveradditional business value
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 17This 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 andpossible 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.
• BW on HANA and HANA Agile DataMart scenarios perfectly address theneeds of Central EDWs and Data Marts
• IQ is SAP‘s native NLS for BW onHANA and is capable of storingterabytes to petabytes of structured &unstructured data
• Mature customer architectures willleverage the capabilities of all threecomponents where appropriate
Agile Data Warehousing
The HANA EDWSAP HANA, BW on
HANA + IQ NLS
Sybase IQ
BW on HANA
SAP HANA
SAP Sybase IQ and NLS
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 19This 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 andpossible 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.
Near Line Storage in SAP NetWeaver Business Warehouse
In-Line Storage
• Hot current data
• Limited size
• Rapid real-time access
Nearline Storage
• Cold Historical data
• Massive volumes
• Slightly slower access
SAP HANA
In-memory Database
High Value, CurrentData
(traditional databasesare also supported)
Sybase IQ
Disk Based Database
Historical Data TrendAnalysis
SAP NetWeaverBusiness
Warehouse
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 20This 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 andpossible 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 Sybase ODBC Driver
HANA DB
InfoProvider
NLS Interface
Near Line Adapter (ABAP based )
BW
DBSL forSybase ASE (/w IQ ext.)
(Kernel based; Open SQL + Native IQ SQLvia ADBC)
BW Porting
General Porting
DB Client
BW NLS Solution for SAP Sybase IQ (DBSL based solution)
HANA Analysis Processes
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 22This 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 andpossible 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.
HANA Analysis ProcessSAP BW 7.4, SP5 on HANA
Enhanced analysis capabilitiesExecute HANA-native functionsdirectly on BW InfoProvider data e.g.:
– Clustering, association algorithms,regression analysis, anomalydetection, weighted score, exponentialsmoothing, etc.
Execute complex and data intensiveprocesses on HANA without loosingthe integrity and integration with theBW environmentMaterialize the result of a HANAAnalysis Process in HANA for furtherprocessing – automatedSupporting also a scheduled batchprocessing use case
Source Function TargetBW InfoProvider AFL(PAL, …), Procedure,
L-Script, R-ScriptBW InfoProvider
BW Process Management
AgendaIntroduction – evolving BW on HANA to HANABWEDW with BW on HANAOLAP with BW on HANABW Content optimized for HANAPlanningOutlookBusiness Benefits
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 24This 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 andpossible 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.
Push Down ListSAP BW 7.40, SP5 and future SPs on HANA
In Memory Database
Calculation and Planning Engine
Row & Column Storage
BW / BEX Query Designer
BW Application Server
Analytic Manager
BW Query
Calc.-views /Calc. scenarios
OLAP Features pushed down to HANA in BW 7.3x and higher• Hierarchy Handling Part I• Restricted key figures• Exception Aggregation CNT for quantity key figures without unit
conversion• Exception Aggregation of currency key figures with optional currency
conversion
OLAP Features pushed down to HANA in BW 7.40 SP5• Processing of further query scenarios in HANA (Joins, Union, etc.)• Avoid intermediate result set materialization (e.g. Exception Aggregation)
OLAP Features pushed down to HANA in BW 7.40 SP6 and beyond• Handling of inventory keyfigures• Stock coverage keyfigure• Hierarchy Handling Part II• Formula exception aggregation
Agenda
Introduction – evolving BW on HANA to HANA BWOLAP with BW on HANAEDW with BW on HANABW Content optimized for HANAPlanningOutlook
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 26This 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 andpossible 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.
New Business Content optimized for BW on HANA
• New analytics combining capabilities of SAPHANA and SAP NetWeaver BW
• Provides additional analytic solutions forexisting BW on HANA customers
• Follows the LSA++ architecture• Provides higher level of details (line items, …)• Implements mixed scenarios HANA Content +
BW Content• Provides optimized transformation for HANA• Offers more flexibility in data acquisition and
reporting• Makes use of the consolidated InfoObjects• Find further information in the SAP Help – BI
Content documentation and see the extendedpresentations on the HANA optimizedBusiness Content in SCN
AgendaIntroduction – evolving BW on HANA to HANA BWEDW with BW on HANAOLAP with BW on HANABW Content optimized for HANAPlanningOutlookBusiness Benefits
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 28This 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 andpossible 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.
PlanningLOB enablement
Combine the best of three worlds toa unique planning solution(HANA, BPC, BW-IP)
Combines the• …successful EPM Excel add-in• …flexible BPC admin-UI• …powerful BW-IP / PAK planning manager• …super-fast HANA planning engine
Selected features• Full PAK-model compatibility• Business process flows (BPF)• Work-status• Data auditing• Easy upload scenario• LOB authorizations
BPC NW‘unified’
(10.1)
BPC NW• user experience• collaboration• data flexibility
BW-IP• EDW-integration• Built-in functions
HANA• Unprecedented
speed
AgendaIntroduction – evolving BW on HANA to HANA BWEDW with BW on HANAOLAP with BW on HANABW Content optimized for HANAPlanningOutlookBusiness Benefits
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 30This 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 andpossible 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.
Planned Innovations Future DirectionToday
HANA Smart Data Access for SAP BW
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 32This 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 andpossible 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.
Diverse Technologies
BusinessIntelligence
EnterpriseApplications
Systems withUnstructured Data
Databases/ LegacySystems
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 33This 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 andpossible 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.
Smart Data AccessSAP BW 7.4, SP5 on HANA
Enhanced Business Flexibility byproviding “the logical EDW”
Data Federation in diverse EDW landscapes• Smart data access – read access to relational and
non-relational sources via ODBC• Enables access to remote data access just like
“local” table• Supports data location agnostic development• No special syntax to access heterogeneous data
sources• BW based Analytic Services on external data
Scenario• Make other DWHs transparent to HANA• Non-disruptive evolution from virtual table to
persistent structure by establishing ETL withoutmajor effort
• Consolidating / rationalizing the DWH landscape• Consumption of HANA datamart scenarios from
second HANA database
HANA Smart Data Access LayerHANA Smart Data Access Layer
QueryQuery
BW Virtualization Layer
Composite Provider, Open ODS View
BW Virtualization Layer
Composite Provider, Open ODS View
Teradata
HadoopSAP HANA
ASE
IQ
Virtual TablesHANA Tables
AgendaIntroduction – evolving BW on HANA to HANA BWOLAP with BW on HANAEDW with BW on HANABW Content optimized for HANABW Integrated PlanningOutlookBusiness Benefits
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 35This 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 andpossible 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 BW powered by HANA Business Benefits
Finance1
BW Operations5
Supply ChainForecasting
4
Sales2
Inventory3
• Accelerate period-end close• Accelerate planning processes• Simplify audit reporting / Reduce compliance risk
• Improve IT efficiency (lowered administration & maintenance costs)• Improve BI efficiency by delivering projects faster•Reduce overall HW costs
• Increase SLAs and ability to manage supply chain costs with access to timely info•Plan more accurately by providing access to actual results faster•Reduce total planning cycle time / Improve forecast accuracy
• Maximize revenue with cross-sell & up-sell & churn analysis• Increase revenue/margin via improved opp, cust, prod, pipeline, sales & margin visibility• Improve customer satisfaction through value-added sales relationships
•Optimize inventory positions and asset utilizations through faster planning•Reduce stock-outs through improved inventory visibility• Improve customer satisfaction by improving stock/shipment reporting
© 2013 SAP AG or an SAP affiliate company. All rights reserved. 36This 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 andpossible 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.
SummaryEnterprise Data Warehousing with SAP BW 7.4 on HANA
SAP BW 7.4 is THE go-to-release for running BW on HANA
Tight integration between SAP BW 7.40 and HANA supports
… simplified and unified modeling
… reduced complexity of your EDW landscape
… pushing down additional processing logic to HANA
SAP BW on HANA is and will continue to be the cornerstone of SAP’s EDW strategy