RDP201 SAP BW 7.4 SP5 Powered By SAP HANA And Further

Transcription

RDP201SAP BW 7.4 SP5 powered by SAP HANAand further RoadmapNovember, 2013This 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.

DisclaimerThis presentation outlines our general product direction and should not be relied on in making apurchase decision. This presentation is not subject to your license agreement or any otheragreement with SAP. SAP has no obligation to pursue any course of business outlined in thispresentation or to develop or release any functionality mentioned in this presentation. Thispresentation and SAP's strategy and possible future developments are subject to change and maybe changed by SAP at any time for any reason without notice. This document is provided without awarranty of any kind, either express or implied, including but not limited to, the implied warranties ofmerchantability, fitness for a particular purpose, or non-infringement. SAP assumes no responsibilityfor errors or omissions in this document, except if such damages were caused by SAP intentionallyor grossly negligent.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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP2

AgendaIntroductionEDW with BW on HANABW Integrated PlanningEnhanced Mobile EnablementBW Content optimized for HANAOutlook

AgendaIntroductionEDW with BW on HANABW Integrated PlanningEnhanced Mobile EnablementBW Content optimized for HANAOutlook

SAP BW Today (September 2013)14500 Customers200New Installations/Month3500 BW 7.3 CustomersVast majority: Central EDW, harmonizing many source systemsEmbedded into mission critical business processes500 BW on HANA CustomersThis 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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP5

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 HANASAP NetWeaver BWSAP BW on HANAData ta ModelingPlanningOLAPPlanningOLAPPush DownRDBMSData Schema&DataTraditional Stack Accelerated In-Memory planning capabilitiesfor faster planning scenarios Flexible combine EDW with HANA-nativedata for real-time insights and decision making Data persistency layers are cut off andreduced administration efforts Simplified data modeling and remodelingDataManagementData Management Excellent query performancefor improved decision making Performance boost for Data Load processesfor decreased data latencyData intensive functions are pushed downfrom BW to HANAHANA as the Primary Database for BW andFoundation for new ApplicationsHANA StackThis 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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP6

SAP’s strategic EDW solutionSAP BW 7.4 on HANAOnly 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 WservicestomanageandanalyzethedataThis 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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP7

SAP BW 7.4, SP5 – OverviewPlanned with SAP BW 7.4, SP5 on HANAEnhanced Data Modeling Common Eclipse based Modeling Tools BW/HANA Smart Data Access providing the logicalEDWBW Queries, ODATA, MDX, SQL Easy integration of external data models withOpen ODS Layer Further reduce data layers in BW via OperationalData ProvisioningBW Virtualization LayerArchitected DatamartLayerPush down further processing logic to HANATransformations BW Analytic ManagerEDW Core LayerTransformationsOpen Operational DataStore LayerHANA tables, viewsDataStore ObjectsBW SchemaHANA SchemaAgileDatamartsBWWorkspaces HANA Analysis Processes BW Transformations PAK – Pushing down more planning semanticsEnhanced mobile enablementConverged planning solutionsBW Content optimized for HANAExternal SourcesThis 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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP8

AgendaIntroduction – evolving BW on HANA to HANABWEDW with BW on HANABW Integrated PlanningEnhanced Mobile EnablementBW Content optimized for HANAOutlook

Eclipse based Modeling Tools

Common modeling toolsPlanned with SAP BW 7.4, SP5 on HANACommon user experience via a central, unified modelingenvironment Attractive, flexible and simplified BW modeling toolsHarmonization BW and HANA modeling environmentsIntegration of BW and HANA models in one modeling approachIntegrated development & modeling environment across– SAP HANA Modeler,– BW Modelingo New developed native Eclipse based modeling tools forOpen ODS View and New CompositeProvider– ABAP Development Tools– 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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP11

Modeling Tools – Maintainance CompositeProviderPlanned with SAP BW 7.4, SP5 and on HANACommon user experience via acentral, unified modeling environment New metadata object CompositeProvideras abstraction object of the query to theunderlying technical persistence objects Left:– Scenario definition (Join, Union) Right:– Join condition– Mapping of Source Objects to TargetOutput structureThis 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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP12

Modeling Tools – Open ODS ViewPlanned with SAP BW 7.4, SP5 and on HANACommon user experience via acentral, unified modelingenvironmentNew metadata object OpenODSView to integrate externaldata models into BWLeft technical Information about SourceFieldsRight General information Associations to OpenODSViews orInfoObjects Characteristic-specific Properties suchas Authorization relevance andReferential Integrity Reporting Properties such as Displayand Query Filter behaviorThis 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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP13

HANA Smart Data Access for SAP BW

Smart Data AccessPlanned with SAP BW 7.4, SP5 on HANAEnhanced Business Flexibility byproviding “the logical EDW”QueryData Federation in diverse EDW landscapes Smart data access – read access to relational andnon-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 datasources BW based Analytic Services on external dataBW Virtualization LayerComposite Provider, Open ODS ViewHANA TablesVirtual TablesScenarioHANA Smart Data Access LayerIQTeradataHadoopASESAP HANA Make other DWHs transparent to HANA Non-disruptive evolution from virtual table topersistent structure by establishing ETL withoutmajor effort Consolidating / rationalizing the DWH landscape Consumption of HANA datamart scenarios fromsecond HANA databaseThis 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 strategyand 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 thisdocument, except if such damages were caused by SAP intentionally or grossly negligent. 2013 SAP AG or an SAP affiliate company. All rights reserved.15

Field based modeling

Flexible consumption of external data modelsPlanned with SAP BW 7.4, SP5 on HANAFlexible and easy consumption of external datamodels building a BW Open ODS Layer usingfield-based modelingBW Queries, ODATA, MDX, SQLConsume & combine external data models forBW Virtualization Layer Direct query access (w/o replication) Staging scenarios Switch between both optionsArchitected Data MartLayerAgile modeling Field based modeling via Open ODS View and DSO (withfields *) Complementing InfoObject modelingTransformationsEDW Core LayerTransformationsOpen Operational DataStore LayerHANA tables, viewsDataStore ObjectsAgileData MartsBWWorkspaces Integrate with existing BW models Gradually build up models and architectures based onrelational schemas Possibility to start modeling from facts developing towardsthe dimensions Enables rapid prototyping – quick ROIDirect query accessBW SchemaHANA Schema Integrated with BW authorization concept Combine with existing InfoObjects / DSOsExternal Sources* Pilot only(Note 1922533)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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP17

Field based modeling in BW on virtual HANA TablesPlanned with SAP BW 7.4, SP5 on HANAVirtual AccessBW ManagedPersistence *Virtual AccessBW QueryBW QueryOpen ODS LayerOpen ODS LayerOpen ODS ViewVirtualOpen ODS ViewVirtualDSO w/ fields*PersistentBW onHANAVirtual TableVirtual TableSmart DataAccessTable/View* Pilot only(Note 1922533)Table/ViewExternal SourcesOpen ODS View offers Metadata object as an abstraction layer for underlying sourceobject HANA virtual tables as supported source objects via SDA Querying on field level Supported for Teradata, Sybase ASE/IQ, Hadoop Optimized Query execution by pushing down to HANA Supported scenarios:- Virtual Access- Persistent Access *o Switch from Virtual to Persistent *o Based on Field based DSO including DTP andTransformationo Direct staging into DSO bypassing PSAo No need to adjust existing queriesEasy assignment of semantics Underlying object (Table, DB View, DataSource) can be taggedas Text, Master data or Facts Single fields of the object can be linked to already existingOpen ODS Views or InfoObjectsThis 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 strategyand 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 thisdocument,exceptif such damageswereancausedby SAPaffiliateintentionally orcompany.grossly negligent. All rights reserved. 2013SAPAG orSAP18

Modeling Tools – Open ODS ViewPlanned with SAP BW 7.4, SP5 and on HANACommon user experience via acentral, unified modelingenvironmentNew metadata object OpenODSView to integrate externaldata models into BWLeft technical Information about SourceFieldsRight General information Associations to OpenODSViews orInfoObjects Characteristic-specific Properties suchas Authorization relevance andReferential Integrity Reporting Properties such as Displayand Query Filter behaviorThis presentation outlines our general product direction and should not be relied on

SAP BW 7.4 SP5 powered by SAP HANA and further Roadmap 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