DMM200 SAP Business Warehouse 7.4, SP8 Powered By SAP PDF Free Download

2y ago

65 Views

1 Downloads

2.45 MB

41 Pages

Report/dmca

Download PDF

Transcription

DMM200 – SAP Business Warehouse 7.4, SP8powered by SAP HANA and RoadmapLothar HenkesProduct Management SAP EDW (BW/HANA)Public

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 noresponsibility for errors or omissions in this document, except if such damages were caused bySAP intentionally or grossly negligent. 2014 SAP SE or an SAP affiliate company. All rights reserved.Public2

SAP Business Warehouse Today14,500 2004,000 CustomersNew Installations/MonthBW 7.3/7.4 CustomersVast majority: Central EDW, harmonizing many source systemsEmbedded into mission critical business processes1200 BW on HANA Customers 2014 SAP SE or an SAP affiliate company. All rights reserved.Public3

Simplification with SAP BW 7.4What is different with SAP BW powered by SAP HANA?SAP NetWeaver BWSAP BW on HANAData ManagementPlanningOLAPData ManagementPushDownRDBMSSAP HANA Platform 2014 SAP SE or an SAP affiliate company. All rights reserved.Platform relatedFeaturesProcessOrchestrationOLAPData ModelingProcessOrchestrationData ModelingPlanningData intensive functions are pusheddown from SAP BW to SAP HANA Performance boost for data load,query and planning processesSimplified SAP BW Flexibly combine EDW withSAP HANA models Data persistency layers reduction Simplified data modeling andremodelingSAP HANA as platform Offers functionality which can beleveraged in SAP BW E. g. predictive libraries integrationPublic4

Highlights of SAP BW 7.4 SP8 powered by SAP HANAVirtual Data Warehouse Next level Open ODS ViewsAdditional CompositeProvider scenariosPerformance Next level of performance in data staging forBW on HANAFurther push down of OLAP capabilitiesSimplification Advanced DataStore Object consolidatingDataStore Objects and InfoCubesHANA model generation for BW QueriesBig Data SAP HANA dynamic tiering for SAP BWEnhanced operations and Query optimizationfor NLS 2014 SAP SE or an SAP affiliate company. All rights reserved.Planning Planning application Kit (PAK) featurecomplete with BW-IPEnhanced FOX productivity and usabilityPublic5

The Virtual BW – Open ODS ViewsRecap – Open ODS Views with SAP BW 7.4 SP5Virtual AccessBW QuerySAP BWOpen ODS LayerOpen ODS ViewVirtualFlexible and easy integration of external datamodels Consume external data of DB tables or views Agile modeling combining InfoObject and field basedmodelling Easy assignment of semantics (facts, master data) Integrated and modern modeling environmentbetween HANA and BWHANAVirtual TableSAP HANASmart DataAccessEnhanced Business Flexibility bysupporting “the logical EDW” SAP HANA Smart Data Access leveraged by SAPBW Supports virtualized query accessTable/ViewAny Source 2014 SAP SE or an SAP affiliate company. All rights reserved.Reduced data modeling effortsPublic7

The Virtual BW – Open ODS ViewsNew with SAP BW 7.4 SP8Virtual AccessBW-ManagedPersistenceBW QueryBW QuerySAP BWSAP BWOpen ODS LayerOpen ODS LayerOpen ODS ViewVirtualOpen ODS ViewVirtualAdvancedDSOswitchHANANew source objects for Open ODS Views Advanced DataStore Object (details in next chapter) BW Transformations (for type conversions,mappings, etc.)Automated Data Flow generation to create apersistency in SAP BW Built-in support to switch from virtual access tomanaged persistence by single click for:HANAVirtual TableVirtual TableSAP HANASAP HANASmart DataAccessTable/ViewTable/ViewAny SourceAny Source 2014 SAP SE or an SAP affiliate company. All rights reserved. higher service level, delta enablement, . . . Automated creation of an Advanced Data StoreObject corresponding to the view definitionincluding data flowPublic8

The Virtual BW – CompositeProviderRecap – CompositeProvider with SAP BW 7.4 SP5SAP and non SAP ApplicationsSQLBICSODATACompositeProviderCombine the data of various applicationsModelViewBWWorkspaceThe new CompositeProvider withSAP BW 7.4 SP5 – virtualization and consolidation Combine BW InfoProviders and HANA tables/viewsvia UNION or JOIN Consolidation of existing InfoProvider types by newCompositeProvider Successor to BW MultiProvider, BW InfoSet, existingCompositeProvider, TransientProvider on HANAModels, VirtualProvider on HANA ModelsTableOperational or Real-timeDatamartClassical DatawarehouseSchemaPrototyping involvingBusiness UserFaster Implementations of data modelSAP BW SchemaSAP HANA SchemaMore flexibility – additional business insightsExternal DatabaseHadoop 2014 SAP SE or an SAP affiliate company. All rights reserved.ERPBWCompletely processed on SAP HANAPublic9

The Virtual BW – CompositeProviderNew with SAP BW 7.4 SP8SAP and non SAP ApplicationsSQLBICSODATACompositeProviderCombine the data of various applicationsNew use cases Supports planning functionalitiesfor UNION Cases UNION between CompositeProvidersOptimized integration with Open ODS ViewModelViewBWWorkspaceTableOperational or Real-timeDatamartClassical DatawarehouseSchemaSAP BW SchemaSAP HANA SchemaExternal DatabasePrototyping involvingBusiness UserHadoop 2014 SAP SE or an SAP affiliate company. All rights reserved.ERP allow JOINs of Open ODS Views Support of navigational attributesEnhanced HANA View integration Support of input parametersBWPublic10

Simplification – Advanced DataStore ObjectNew with SAP BW 7.4 SP8 – OverviewActive Data(Reporting)Change Log(Delta Store)Activation Queue(Inbound Layer)Advanced DSOSAP BWSAP HANA 2014 SAP SE or an SAP affiliate company. All rights reserved.Next generation of Data Store Object simplifiesdata modeling in SAP BW Consolidate DataStore Objects and InfoCubes Single type of BW object Settings to manage properties .e.g. DSO like,InfoCube like Combine InfoObject and field based modelling New intuitive & modern modelling UIOptimized DataStore services High frequent data loads - based on optimizedrequest management Change of usage scenario without deletion of data Up to 120 key fields Optional SID entries for query performanceoptimizationPublic12

Simplification – Advanced DataStore ObjectNew with SAP BW 7.4 SP8 – eclipse based modelling experienceIntuitive User Interface Aligned with CompositeProvider andOpen ODS Views modellingBenefits Supports agile data modelling Reduces implementation timesmassively 2014 SAP SE or an SAP affiliate company. All rights reserved.Public13

Simplification – Advanced DataStore ObjectPlanned future directionActive Data(Reporting)Future directionChange Log(Delta Store)Activation Queue(Inbound Layer)Advanced DSOSAP BWSAP HANA 2014 SAP SE or an SAP affiliate company. All rights reserved.Future enhancements Non-cumulative key figures Template based modelling Nearline Storage (NLS) Extended Table property for SAP HANAdynamic tiering Support of planning scenarios Support for direct update scenarios (writeAPIs) Conversion tool for classic DataStore Objectsand InfoCubes Real-Time enablement Additional Partitioning optionsPublic14

Simplification – Consolidation of BW Modeling ObjectsNew with SAP BW 7.4 SP8SAP BW on RDBMSSAP BW 7.40 on HANASAP BW 7.4 on HANA consolidates existingInfoProvider CompositeProvider as new object to definejoins between InfoProvider Open ODS View for virtual access toexternal sources InfoObject to model semantically rich masterdata Advanced DataStore Object as the newobject for persistence managementTraditional InfoProvider still exist but futureinnovations are focusing on theconsolidated objects on SAP HANA 2014 SAP SE or an SAP affiliate company. All rights reserved.Public15

Simplification – Automated generation of HANA ModelsNew with SAP BW 7.4 SP8Automated HANA model generation for direct SQLconsumption of BW Data Lifecycle: when the infoprovider changes the HANAmodel is automatically re-generatedEnhancedHANA modelHANA ViewCompositeProviderHANA ViewgeneratesInfoProviderMasterDataSAP BW 2014 SAP SE or an SAP affiliate company. All rights reserved.HANA ViewSAP HANAHANA model generation for BW Queries Generate a SAP HANA model for a simple BWQuery including security Supported features: currency/unit conversion,variables, restricted key figures, global restrictions,inventory key figure (closing balance) Generated SAP HANA model able to read the datafrom the Nearline Storage Supports InfoCubes and DSO (with SID generation) SAP HANA Smart Data Access with SAP IQ onlyPublic16

Performance – SAP HANA Optimized TransformationsOverview & Update with SP8Application ServerBW 7.3x on anyDBDSOBW 7.3x on HANADSODSO / formationDataNext level of performance in datastaging for BW on HANA Standard Transformations areoptimized to be processed directly inSAP HANA where possibleTransformationActivationDatabaseBW 7.4 on HANAData 2014 SAP SE or an SAP affiliate company. All rights reserved.DataNew with SAP BW 7.4 SP8 Additional formulas pushed down toHANA ABAP managed database procedure(AMDP) integration for easy editing ofHANA procedures Additional performance optimizationsPublic18

Performance – Push-down of OLAP functionalityOverview & Update with SP8BW / BEX Query DesignerAnalytic ManagerBW QueryBW Application ServerOLAP Features pushed down to HANA since BW 7.4 SP5 Processing of Unions and Joins in CompositeProvider Avoid intermediate result set materialization (e.g. ExceptionAggregation)New push down with SAP BW 7.4 SP8 Handling of inventory key figures Unit conversion with Reference InfoObjectsCalculation and Planning EngineCalc.-views /Calc. scenariosDetails about availability of pushed down OLAP functionality SAP Note 2063449 - Push down of BW OLAPfunctionalities to SAP HANARow & Column StorageSAP HANA 2014 SAP SE or an SAP affiliate company. All rights reserved.Public19

Big Data – Multi Temperature Data Management in SAP BWOverviewhot Data is read and/or written frequently SAP HANA In-memory No restrictions, all features availablewarm Infrequent access SAP HANA on disk, only loaded tomemory when accessed No restrictions, all features availablecold Sporadic access Not stored in HANA;stored in Nearline Storage Restricted to NLS capabilitiesData Volume PerformanceSAP HANAdynamic tieringNon-Active DataConceptNearlineStorageProviding lower TCO by optimized SAP HANA RAM management 2014 SAP SE or an SAP affiliate company. All rights reserved.Public21

Big Data – Multi Temperature Data Management in SAP BWAP BWArchitectural Heat Map – temperature data distributionArchitected Datamart LayerTransformationsEDW LayerTransformationsCorporateMemoryStaging LayerArchive NLSSAP BWHot Areas heavy reporting and/or HANA-native operations (Delta, Transf., )Warm Areas limited reporting, limited HANA-native functionsCold Areas Archive, read-only data, different SLAs22 2014 SAP SE or an SAP affiliate company. All rights reserved.Public22

Big Data – SAP HANA dynamic tiering for SAP BWNew with SAP BW 7.4 SP8 and SAP HANA SPS9Warm store as dynamic extension to hot storeand integral part of the HANA platformSAP BWData SourceStandard(A)DSOw-o DSO Reduced in-memory footprint Highly efficient compression and performance Unified Installation & Update ManagementHotStore(in-memory)WarmStore(on-disk) One Backup & Recovery processActiveActiveTablePSATableSAP HANA SPS9 2014 SAP SE or an SAP affiliate company. All rights reserved.Can be set for Write Optimized DSOs andDataSources as extended table propertyInboundQueue Data load processes and queries are processedwithin the warm store Transparent for all operations, no change for BWprocesses required Conversion to move existing data to warm storePublic23

Big Data – Multi Temperature Data Management in SAP BWSAP HANA dynamic tiering and Nearline Storage for SAP BWSAP HANA dynamic tieringSAP BW Nearline Storage with SAP IQ Optimize RAM utilization within HANA Optimize data persistence in systemlandscape Integral part of the platform Independent server Complete data manipulation cap. (Create, Read,Update, Delete) Write once, read many Meets mission critical system SLAs Usually lower SLAs Complete tables (and partitions) Arbitrary (semantic) data slicesDifferent types of data with different types of storage 2014 SAP SE or an SAP affiliate company. All rights reserved.Public24

Big Data – Nearline Storage (NLS) with SAP IQNew with SAP BW 7.4 SP8Enhanced NLS operations Data Archiving proposals Automated data archiving process generationInfoCubesDataStoreObjectNLS InterfaceSAP BW NLS integration in DBA cockpitSAP IQInfoCubes with non cumulative key figuresInterfaceQuery optimizations for NLS Query pruning based on time dimensions andarchived time slices Push down of OLAP functions(Restricted KeyFigures, Hierarchies, ) to HANASAP HANAHANA model generation includes NLS data 2014 SAP SE or an SAP affiliate company. All rights reserved.Public25

Planning – Push-down of planning semanticsBW 7.3x on HANABW 7.4 on DataSlicesPlanningfunctionsExitsDataSlicesExitsBW 7.3x on anyDBExitsApplication ServerOverview & Update with cteristicrelationsPlanningfunctionsNew with SAP BW 7.4 SP8 Planning application kit (PAK)feature completeness with BW-IP Enhanced FOX productivity cteristicrelationsDataData 2014 SAP SE or an SAP affiliate company. All rights reserved.Next level of performance bypushing down further planningcapabilities to HANADetails about availability of pushed downPlanning functionality see SAP Note 1637199Public27

Planning – BW-IP/PAK EnhancementsNew with SAP BW 7.4 SP8Improved FOX Formula handling FOX able to replace custom developed ABAP planningfunctions Internal Table: Define a table via FOX coding, supportsall table operations (e.g. read, insert, update . . ) Access to ‘external’ data: Read data of any aggregationlevel out of the planning buffer New Syntax Highlighting in FOX editor FOX debugging via debugging scriptUse CompositeProvider for planning scenarios Support of planning scenarios based on UnionsEntering comments Available for SAP Analysis for Office, SAP DesignStudio, BEx Analyzer, BEx Web 2014 SAP SE or an SAP affiliate company. All rights reserved.Public28

Planning - SAP Business Planning and Consolidation 10.1, versionfor SAP NetWeaver powered by SAP HANAEnhanced analysis and planning capabilities Leverages BW Integrated Planning models and benefitsfrom SAP HANA acceleration Adds new capabilities to existing BW-IP features e. g.business process flows, work status . . . Optimized planning functions leveragingSAP HANA for better, more timely decisionsIncreased usability New HTML5 UI for easier navigation and cross-platformreadinessSelected features available with SAP BW 7.40 SP8 Master data planning, e.g. entering new values 2014 SAP SE or an SAP affiliate company. All rights reserved.Public29

Miscellaneous – XXL Attribute7Overview & Update with SP8Overcome the 60 characters limitation for additional flexibility Extend length for Characteristics values(Attribute length 250) Extra long texts for Characteristics(Long text type ‘Char 1333’)New with SAP BW 7.4 SP8: XXL - AttributesPossibility to load and store different Files types (MIME Types)as XXL-attribute into BW E.g. PDF’s, XML, Office Files, Images, Video-Files, Audio-FilesStore very long strings as attribute in SAP BW E.g. Twitter information (Tweets), File-paths, URL 2014 SAP SE or an SAP affiliate company. All rights reserved.Public31

Miscellaneous – BW Search, Remodelling Tool BoxUpdate with SP8BW Search New Eclipse based UI Search based on object level No replication or copy of data Using SAP HANA search capabilities (or rather Attribute Views)Re-modelling Tool Box Supports semantically partitioned objectsOperational Data Provisioning (ODP) Supports hierarchy loads 2014 SAP SE or an SAP affiliate company. All rights reserved.Public32

Miscellaneous – New Process Chain MonitorNew with SAP BW 7.4 SP8Easy monitoring – anytime anywhere Detect errors Analyze process and job logs Repair failed stepsAttractive, intuitive design based on SAPUI5 technology optimized for devicescreen sizeSimple configuration Reuses settings of backend ProcessChain Monitor Works directly on Process Chain logs –no data replication 2014 SAP SE or an SAP affiliate company. All rights reserved.Public33

SAP BW powered by SAP HANAProduct Roadmap Overview – Key Themes and CapabilitiesSAP BW 7.4 SP8 on SAP HANAUpcoming planned releaseFuture innovationsPush down of data intensive functions to HANA Analytic Manager, Warehouse managementprocesses and Planning SemanticsSimplified data modeling Open ODS View flexible integrating external data CompositeProvider consolidating existing InfoProviders Common Eclipse based modeling tools Advanced DSO to consolidate DSOs and InfoCubeBIG Data scenarios HANA dynamic tiering for Petabyte-scale storage NLS Storage enhancementsSAP HANA Enterprise Cloud Best practice for large scale BW migrations into the cloudExposing BW data models for SQL consumption Generation of HANA models from BW InfoProviders andsimple BEx queriesPush down of data intensive functions to HANA Hierarchy processing pushed down leveragingHANA technologySimplified data modeling Additional CompositeProvider capabilities Eclipse based query designer Advanced DSO e.g. inventory key figuresBIG Data scenarios HANA dynamic tiering for Advanced DSO. NLS: Exceptional inserts, updates and deletes“BPC Embedded Model” Integrating capabilities of BW IP, BPC and HANAMobile devices Easy mobile consumption using ODATA standard SAPUI5 based Process Chain Monitor“BPC Embedded Model” Combining flexible planning functionality for Lineof Business with governance of central ITIntegration with the HANA Platform Leverage HANA Information Managementcapabilities for BW Further pushdown of data intensive functionsto HANASimplified and Streamlined User Experience Eclipse based Modeling for Data Fl

Public Lothar Henkes Product Management SAP EDW (BW/HANA) DMM200 – SAP Bu