Transcription
SAP Business IntelligenceSAP NetWeaver BWand BI Solution Platform Overviewincluding Sybase SolutionsRoland KramerProduct/Solution Management BW/BI/In-Memory SAP AGJune 2013Customer
Agenda1. SAP Businesswarehouse (BW) 7.30 Overview and Roadmap Synergies with existing BW Accelerator 7.202. SAP BusinessObjects BI 4.0 Overview and Roadmap Synergies with existing BW 7.01 and BW 7.303. Next Generation In-Memory (High Performance Analytical Appliance) Overview and Roadmap HANA Synergies with Business Suite and SAP BusinessObjects Synergies with Sybase Portfolio4. On Demand and Mobile Solutions Current Information on bi.ondemand and streamworkMobile Solutions on Apple Devices SAP AG 2009. All rights reserved. / Page 2Customer
Quick Recap on Naming/one VoiceConclusion Business Warehouse BI BW (Business/Enterprise Warehouse) Business Warehouse Accelerator BIA BWA BusinessObjects BO (BOBJ) SAP Business Objects BI BusinessObjects Polestar SAP BusinessObjects Explorer Project Pioneer (Successor of BEx) SAP BusinessObjects AnalysisOffice Version and OLAP Version (former Voyager) SAP BusinessObjects WebI Interactive Analysis (with BI 4.0) Xcelsius 2008 Dashboard Builder (with BI 4.0) Business Intelligence at SAP is not only BI (former BO) for collecting Data (DataServices) and distributing Data (XI Platform), it is the combination TOGETHER withBusiness Warehouse (BW) and the In-Memory Technology (BWA) which makes theSolution a real Valuable scenario, including the NEW Products like SBO Explorer orthe upcoming Advanced Analysis Frontend Product. In-Memory (HANA and BWA) is the MAYOR Driver for the usage of the complete SAPBW/BI Solution. HANA is not replacing BW, it is the database foundation for it Sybase Portfolio complements the existing SAP Business Intelligence Architecture. SAP AG 2009. All rights reserved. / Page 3Customer
New Approved Naming forSAP BusinessObjects BI 4.0 suiteCurrent NameOFFICIAL APPROVED NAMESNo Equivalent NameSAP BusinessObjects Business Intelligence suiteSAP BusinessObjectsEnterprise PremiumSAP BusinessObjects Business IntelligenceplatformCrystal ReportsSAP Crystal ReportsSAP BusinessObjects XcelsiusEnterpriseSAP BusinessObjects DashboardsSAP BusinessObjects WebIntelligenceSAP BusinessObjects Web IntelligenceSAP BusinessObjects Voyager(aka Advanced Analysis Web;Pioneer)SAP BusinessObjects Analysis, edition for OLAPSAP BusinessObjects AdvancedAnalysis (aka AdvancedAnalysis Office; Pioneer)SAP BusinessObjects Analysis, edition forMicrosoft OfficeSAP BusinessObjects ExplorerSAP BusinessObjects ExplorerSAP Business Intelligence BI, BIA SAP AG 2009. All rights reserved. / Page 4(Note that the term Interactive Analysis was not communicated)SAP Business Warehouse, BW, BW-AcceleratorCustomer
New SAP In-Memory Computing & SAP HANANaming Summary - Final 6/19/2011CategorySAP in-memory computingApplianceSAP HANA applianceDatabaseCloudSAP HANA databaseSAP HANA applicationcloudApplicationsApplication Name, powered by SAP HANAStudioSAP HANA studioExample: SAP Smart Meter Analytics, powered by SAP HANANote: Name should always be “SAP HANA”, never without “SAP” SAP AG 2009. All rights reserved. / Page 5Customer
The New Business Intelligence PlatformSAP NetWeaver PortalAny Portal, Any SAP BusinessObjects EnterpriseSAPBExWADSAP NetWeaver BWAcceleratorData FoundationCrystalReportsData FederatorSAP NetWeaverBWData IntegratorData QualityManagementData Services3rd-Party Databases and Applications SAP AG 2009. All rights reserved. / Page 6Master ancialsOperationsHuman ResourcesCorporate ServicesCRMSCMSRMPLMTextAnalysisSAP Business SuiteMetadata ManagementInformation AccessBest BI and EIM in an SAP landscape (Version 3.1)Customer
The New Business Intelligence PlatformSAP NetWeaver PortalAny Portal, Any rerMaster DataManagementSAP NetWeaverBW / BW-IPData IntegratorData QualityManagementData Services3rd-Party Databases and Applications SAP AG 2009. All rights reserved. / Page 7WebIntelligenceSAP Business Intelligence - BI 4.0SAP NetWeaver BW on HANAData sOperationsHuman ResourcesCorporate ServicesCRMSCMSRMPLMSAP Business SuiteMetadata ManagementInformation AccessBest BI and EIM in an SAP landscape (Version 4.0)Customer
The New Business Intelligence PlatformSAP NetWeaver PortalSAPBExQueryDesignerAny Portal, Any a FoundationData IntegratorMaster DataManagementNLSInformationStewardData Services 4.23rd-Party Databases and Applications SAP AG 2009. All rights reserved. / Page 8WebIntelligenceSAP Business Intelligence - BI 4.1SAP NetWeaver BW on HANASEM / BW-IP / OperationsHuman ResourcesCorporate ServicesCRMSCMSRMPLMSAP Business SuiteMetadata ManagementInformation AccessBest BI and EIM in an SAP landscape (Version 4.1)Customer
Next generation SAP Real-time Data Platformcommunicated 10th of April 2011SAPBusinessSuite3rd PartyBI ClientSAPBusinessWarehouseSAP Big DataApplicationsSAPAnalyticsSAPMobileCustomAppsSAP NetWeaver (On Premise / Cloud)SAP Sybase SQLASAP Sybase ASESAP HANA PlatformSAP Sybase IQSAP Sybase ESPSAP SybaseReplication ServerSAP DataServicesSAP MDG, MDMHADOOP3rd Party DBMPPScale-OutCommon ModelingSybase PowerDesignerOpen Developer APIs and ProtocolsCommon Landscape ManagementSAP Real-time Data PlatformSAP Smart Data Services PlatformSAP innovation without customer disruption SAP AG 2009. All rights reserved. / Page 9Customer
Positioning Database TechnologiesSAP Sybase ASE, SAP Sybase IQ, and SAP AP SybaseASE SAP AG 2009. All rights reserved. / Page 10DWReal-TimeAnalyticsSAP SybaseIQOLTPTransactional (OLTP)BWTraditionalReporting / Analyticsvs.Analyze (OLAP)Customer
BW Enhancements Delivered in 2009/2010:Updating your software stack is keySAP NetWeaver BW 7.0 EhP1 (7.01)as THE foundation for all new BI Solutions10 Improvements onBW 7.01 XI 3.1 SP2 Removal of 1 millionscells limitation Up to 15% performancegains with querystreaming Up to 25% performancegains in the MDX driver Better OLAP universechange management withLCMFurther optimizations delivered in SPSs and SPs based on BW 7.01 and XI 3.1* DF Facade new communication Interface with EhP1 between Data Federator and the BW DatasourcesEhP1 and SBO Details: 8e3 SAP AG 2009. All rights reserved. / Page 11Customer
Reporting on HANA 1.0 SPS02 with BI 4.1 Client and connectivity optionsAre part of SBO BI 4MajorEnhancementsin redJDBCODBCJDBCExplorerCR 2011ExcelCR 2008Outside of SBO BI 4ODBOODBCAnalysis OLAPCrystal ReportsAnalysis Officev1.1Outside or as part of SBO BI 4WebIntelligencefor EnterpriseDashboardsSemantic Layer (universe SQLSAP HANA Database SAP AG 2009. All rights reserved. / Page 12Customer
SAP NetWeaver BW 7.3Overview - http://www.sdn.sap.com/irj/sdn/bw-73 Scalable data models with built-in Semantic Partitioned Object (SPO)Performance &Scalability Optimized load performance for DataStore Objects and Master Data Enhanced built-in analytical capabilities for SAP NetWeaver BW Accelerator Query as an InfoProvider enabled for mass data handling Tighter Integration with SAP NetWeaver BW 7.3 and SAP BusinessObjects Tools:Integration withBusinessObjectsData Services and Metadata Manager Optimized integration of SAP BusinessObjects BI Tools Xcelsius, WebI Combining real-time transactional data with historical data via HybridProviderDevelopmentEfficiency Smarter data flow modeling with remarkably reduced manual effort Hierarchies integrated into SAP NetWeaver BW 7.x data flow Flexible modeling environment for analytical indices ABAP based Planning ModelerSimplifiedconfiguration &operations SAP AG 2009. All rights reserved. / Page 13 Faster system set-up with a wizard-based system configuration Enhanced monitoring capabilities with new content for SAP NetWeaver BWAdministration Cockpit and integration in SAP Solution ManagerThis 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 isprovided 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.Customer
SAP NetWeaver BW 7.30 Integrated PlanningContinued investments for enhanced TCO of SAP NetWeaver BW–integrated planningABAP Planning Modeller –ABAP based Planning Modelerfor a non-disruptive customizingof planning objects and theirrelated BW objects The ABAP-based PlanningModeler does not requirefunctionalities from the JavaStack for BEx Analyzer basedplanning applications SAP AG 2009. All rights reserved. / Page 14This 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 isprovided 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.Customer
Enterprise Data WarehousingReal-Time Business IntelligenceImplement operational reporting scenarios leveraging newmodeling objectsHybridProvider HybridProviderConsists of a DataStore object and a InfoCubewith automatically generated data flow in betweenCombines mass data with latest delta informationat query runtimeDSO object can be connected to a realtime dataacquisition DataSource/DTPIf the DataSource can provide appropriate deltainformation in direct access mode aVirtualProvider can be used instead of the DSO.Facilitates replication of DSO-/VirtualProviderdata to SAP NetWeaver BW Accelerator byswitching off database persistency of the InfoCubelatest dataDSOmass dataReplicateInfoCubeBWAoptionally(RDA) DTPOLTPEnhancements Real -Time Data Acquisition Possibility to load master data with RDAEnhanced error handling and scalability (daemon can handle more DataSources more efficiently) SAP AG 2009. All rights reserved. / Page 15This 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 isprovided 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.Customer
Design Aspects –Near-line Storage vs. BW Accelerator/HANANLSBWInfoProvider (InfoCube) Alternative storage types with direct accesscapabilities for reporting and loading Extracted partitions are deleted in RDBMS(NLS storage and Online Storage togetherconsistently reflect the BW data persistencyof an InfoProvider) NLS data is read-only NLS part of an InfoProvider are writeprotected NLS is primarily partitioned by time/ageOffline ArchiveBWAArchivingAccelerationAcquisitionBWA Replication of the BW Star Schema includingmaster data DB volume not affected Roll-Up and Change Run possible afterdata loads Optimized for fast BW Query access (loadbalancing by hash partitioning)Access - very frequently SAP AG 2009. All rights reserved. / Page 16Nearline StoragefrequentlyRDBMSnot frequentlyrarelyCustomer
SAP NetWeaver BW 7.30 NLS with Sybase IQfully integrated with PBS CBW NLS IQ SAP AG 2009. All rights reserved. / Page 17This 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 isprovided 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.Customer
SAP-owned Implementation for Sybase IQBWBW PortingInfoProviderNearline Adapter (ABAP based )General PortingDBSL forSybase ASE (/w IQ ext.)(Kernel based; Open SQL Native IQSQL via ADBC)NLS InterfaceODBC Driver from IQDB ClientHANA DB SAP AG 2009. All rights reserved. / Page 18Customer
SAP BusinessObjects Explorer acceleratedAccelerated version for any Data with BW Accelerator 7.20Analyze BW and any data – using the Search and Explore paradigmLoad data from any source Extended support for SAP NetWeaver BW datamodels including hierarchies Load any kind of data into SAP NetWeaverAccelerator using SAP Business Objects DataServices New calculation engine providing support forcalculated key figures and restricted key figuresUpdated user interfaceSAP NetWeaver BW AcceleratorCalculation EngineAggregation EngineIndexSAP NetWeaverBW SAP AG 2009. All rights reserved. / Page 19Any DataCustomer
SAP NetWeaver BW AcceleratorNew business scenariosBW Accelerator based InfoCube persistencyOptional 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 loadE- and F- fact tables as well as dimension tables are indexedMaster data will be persisted in both SAP NetWeaver BW and SAPNetWeaver BW AcceleratorA normal Data Transfer Process can be used to load data directly into SAPNetWeaver BW AcceleratorData of a downstream DataStore object can be replicated into BWAw/o InfoCube database persistencyInfoCube(Definition)BWASource System SAP AG 2009. All rights reserved. / Page 20This 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 isprovided 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.Customer
SAP NetWeaver BW AcceleratorFlexible modeling with APD & BWA in SAP NetWeaver BW 7.30Introduction of Analytical Index and QueryProvider with SAP BW–Analytic Index (AI) Is a data container maintained in Analysis Process Designer whose data is stored in theBW Accelerator Analytic Index is exposed as InfoProvider to define Queries on itBex QueryAnalytic IndexAnalysis OfficeQueryProvider Queries can be enabled as InfoProvider Supports mass data access from Queries in Analysis Process Designer scenarios SAP AG 2009. All rights reserved. / Page 21This 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 isprovided 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.Customer
SAP NetWeaver BW AcceleratorFlexible modeling with APD & BWA in SAP NetWeaver BW 7.30Ad-hoc joins/unions of analytical indexes in SAP NetWeaver BWA– Composite Provider describes a union/join of analytical indices Lean Modeler tool is the Design-time environment to buildComposite Providers Join/Union operation is processed on the fly by BWA Composite Providers are exposed to SAP BusinessObjects Explorer For all other BI Clients CompositeProviders are exposed asstandard SAP NetWeaver BW InfoProviderBEx QuerySAP BusinessObjectsAnalysis(former ‚Pioneer‘)(flexible) In-Memory Joinwith Composite Providerdata flow definition SAP AG 2009. All rights reserved. / Page 22This 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 isprovided 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.Customer
Introducing BW WorkspacesA BW Workspace is a dedicated area in a BW system where new models can becreated based on central BW and local data (e.g. flat files). Workspaces can bemaintained and controlled by IT and used by local departments to react quickly tonew and changing requirements. Workspaces can bridge the gap between centralgovernance requirements and local flexibility needs.IT-Governed SpaceWorkspace for ControllingWorkspace for HR SAP AG 2009. All rights reserved. / Page 23Customer
SAP NetWeaver BW AcceleratorBW Workspaces with BW 7.30 GA VersionBWA Workspaces for individual BWA usage within Departments– All new BW/BWA features available in one workspace with is governed by IT, e.g. assignedMemory, etc. and used by local departments.Excel/CSV upload byBusiness UserAny BW InfoProvider with aBWA Index InfoCube / VirtualProvider Masterdata Provider QueryProviderAnalytic Indexes APD SAP BO DataServices / IndexDesignerQuery results QueryProvider APD AnalyticIndex Query result Excel Upload Query copy / Query definition re-use on Workspace Provider SAP AG 2009. All rights reserved. / Page 24This 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 isprovided 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.Customer
Introducing BW WorkspacesDedicated views for both IT and businessWorkspace Designer for key usersin business departments Browser-based tool running inSAP NetWeaver Business Clientor SAP NetWeaver Portal Easy upload of local flat files, Query resultsand BW DataSources into Local Provider Merge data of Local Providers with datafrom SAP NetWeaver BW to createnew data models (CompositeProvider) Monitor Workspace with regards tosize and number of objects createdBW Workspace Designer in SAP NetWeaver Business Client SAP AG 2009. All rights reserved. / Page 25Customer
SAP NetWeaver BW 7.0 / SAP NetWeaver BWA 7.0Starting point of BW and in-memoryHighly scalable in-memory solution to improve query performance whilelowering the cost of operationSAP NetWeaver BW 7.0DWManagementCalculationEngineAnalyticEngineSAP NetWeaver BWA 7.0InfoCube IndexAggregation EngineMetadataDBMSAggregatesAggregates Speed up query performance factor 10 to 100 Save time to build and maintain aggregates at the same time saving disk space Extremely shortened roll-up and change run times SAP AG 2009. All rights reserved. / Page 26Customer
Accelerate and Improve Any of Your DataMap, transform, cleanse, and index In-Memory(1) Define In-Memory Index model using SAP BusinessObjects Data Services Use Index Designer add-in to define model Index model is a flattened view of information(2) Map In-Memory Index to 1 or more data sources Transform, cleanse and merge data from any data source Broad connectivity to databases, apps, legacy, file formats, and unstructured data(3) Schedule & run SAP BusinessObjects Data Services jobs New data and changed data is automatically indexedData plicationsBWAIn-Memory EngineLegacyMainframesTransform, Cleanse & MergeExplorerAvailable today SAP AG 2009. All rights reserved. / Page 27Customer
SAP NetWeaver BW 7.3 / SAP NetWeaver BWA 7.2Enhanced in-memory scenariosSignificant performance enhancements and new object supportSAP NetWeaver etadataSAP NetWeaver BW AcceleratorCalculation Engine Aggregation EngineAnalytic indexes Data Store Objec
BusinessObjects BO (BOBJ) SAP Business Objects BI BusinessObjects Polestar SAP BusinessObjects Explorer Project Pioneer (Successor of BEx) SAP BusinessObjects Analysis . SAP Analytics SAP Mobile Open Developer APIs and Protocols e t SAP Smart Data Services Platform SAP HANA Platform S
