Transcription
SAP BusinessObjects Analysis, edition forMicrosoft OfficeOverviewProduct Management Analysis ClientsApril 2012
Legal Disclaimer 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement2
AgendaOverviewSAP BusinessObjects Analysis, edition for Microsoft OfficeAppendix 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement3
Overview
BI 4.0 for SAP aExplorationReportingSimpler and more IntuitiveRe-use existing infrastructureSAP landscape simplificationIncrease business user autonomy andself-service usageLeverage your investments – BW infoproviders and BEx queriesTighter integration with the SAPNetWeaver technology platformBoost BI adoption for more informeddecision making across the enterpriseTransition BEx analyzer users to thenext generation of SAP BIBI standardization from the boardroom to the shop floorMinimize user training, support andcustomization costsAdopt SAP BusinessObjects BIplatform at your own paceIncreased speed and agility withcost effective in-memory computing 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement5
SAP BusinessObjects BI Client PortfolioSAP BusinessObjects BI solutions provide business users with access to unifiedinformation through a broad suite of BI tools for confident decision making andalignment across people and teams on a single, scalable BI platformReportingHow do I accessand transformcorporate data intohighly formattedreports for greaterinsight? 2012 SAP AG. All rights reserved.Dashboards andVisualizationHow do I visualizedata for betterdecision making?InteractiveReportingHow do I answer adhoc questions andinteract withinformation?AnalysisData ExplorationHow do I determinetrends from complexhistorical data andpossibly make betterforecasts?How do I findimmediate answersto businessquestions?This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement6
SAP BusinessObjects AnalysisThe Premium Alternative to BExAdHoc OLAPWebAnalysis, edition for application design Premium Alternative to BEx Web AppDesigner Design studio for power users to createpurpose-built OLAP analysis & planningapps Customer- and SAP-delivered content Mobile support HANA supportMS OfficeAnalysis ClientsAnalytical Applications 2012 SAP AG. All rights reserved.Analysis, edition for OLAP Dedicated Ad-Hoc OLAP client forbusiness users to analyze OLAPdata and share it with others Enabled for 3rd party OLAP Seamless interoperability betweendesigner and ad-hoc client HANA supportAnalysis, edition for Microsoft Office IT / Developers, Data Analysts, Business Users Excel-based OLAP analysis Excel-based BI applications Live PowerPoint presentations HANA supportThis 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-infringement7
SAP BusinessObjects Analysis, edition for Microsoft OfficeMultidimensional Analysis of SAP BW and SAP HANACreate livePowerPointpresentationsTarget User Groups:BI ProfessionalBusiness UserModern and familiarMicrosoft Office userexperienceBuild powerful Excelworkbook BIapplications 2012 SAP AG. All rights reserved.Support BW-IntegratedPlanningThis 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-infringement8
SAP BusinessObjects Analysis, edition for OLAPThe best web client for SAP BW and SAP HANATarget User Groups:Data AnalystsFew simple clicks tofast business insightsPervasive webbased analysisInteroperate withWebI and CrystalReports 2012 SAP AG. All rights reserved.Modern look-and-feel withintuitive drag-and-dropSAP BW, HANA,EPM and MicrosoftAnalysis ServicesThis 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-infringement9
SAP BusinessObjects Analysis, edition for application designPowerful analytical & planning apps on SAP BW and HANA – PREVIEWDirect Access to BWand HANA via BICSTarget User Groups:ITKey UsersDesignersEclipse-basedapplication designenvironmentiPad AppsPremium alternativeto BEx WAD 2012 SAP AG. All rights reserved.State of the artrendering: HTML5This 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-infringement10
Interoperability Between Analysis and Other Clients in2010 based on BI 4.0Analysis,edition for MS OfficeCreate /consumeAnalysis,edition for OLAPCrystal ReportsWeb IntelligenceCreate /consumeShared Query(Analysis View)Create /consumeInteroperability(Consume throughtransient universe)Create /consumeSemantic Layer 4.0BICS ComponentInteroperability through Analysis ViewCaptures view on the data including filters and other features (similar to BEx query view)Stored in BI platformCan be created in SAP BusinessObjects Analysis (both editions)Can be consumed by SAP BusinessObjects Analysis (both editions), Web Intelligence and CrystalReports (each tool interprets the analysis view in a way that is consistent with its native environment) 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement11
Analysis, edition for MS Office
1 Umbrella Name / 2 Sets of FunctionalitySAP BusinessObjectsAnalysis, edition forMicrosoft OfficeSAP BusinessObjectsAnalysis, edition forOLAPSAP NetWeaver BW and SAPHANA Appliance onlySAP NetWeaver BWExcel-based OLAP analysisWeb-based OLAP analysisMS SQL Server Analysis ServicesExcel-based BI applicationsLive PowerPoint presentations 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement13
SAP BusinessObjects Analysis,edition for Microsoft OfficeYour investments in BEx analyzer are safeBEx analyzer and the suite of SAP BEx tools stay in maintenance modeThey will still be delivered with the next releases of SAP NetWeaver BWThey follow the same life cycle and release strategy as BWE.g., BEx analyzer shipped with BW 7.3 will be supported for the next 7 2 yearsYou will leverage most of these investments moving forwardBEx queries are consumed directly by SAP BusinessObjects BI 4.0 front-endsBEx Query Designer remains in place to create and maintain BEx queriesYour future looks brightNew offering: SAP BusinessObjects Analysis, edition for MS OfficeAlternative to BEx analyzer with enhanced premium functionality 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement14
SAP BusinessObjects Analysis,edition for Microsoft OfficeMain Development Themes of version 1UsabilityNice new look-and-feelDesign PanelSaving costs by minimum training effortFocus on Business UserBring more flexibility to business userMoves load from central ITTightly integrated into familiar Microsoft environmentBasis for new innovationMicrosoft PowerPoint Add-InNew API concept for custom Excel workbookdevelopmentNew extensible connectivity (planned support of otherOLAP sources in future releases) and much more to come .Version 1.0 Generally Available since Q3 2010 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement15
SAP BusinessObjects AnalysisThe Premium Alternative to BExAdHoc OLAPWebAnalysis, edition for application design Premium Alternative to BEx Web AppDesigner Design studio for power users to createpurpose-built OLAP analysis & planningapps Customer- and SAP-delivered content Mobile support HANA supportMS OfficeAnalysis ClientsAnalytical Applications 2012 SAP AG. All rights reserved.Analysis, edition for OLAP Dedicated Ad-Hoc OLAP client forbusiness users to analyze OLAPdata and share it with others Enabled for 3rd party OLAP Seamless interoperability betweendesigner and ad-hoc client HANA supportAnalysis, edition for Microsoft Office IT / Developers, Data Analysts, Business Users Excel-based OLAP analysis Excel-based BI applications Live PowerPoint presentations HANA supportThis 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-infringement16
Use Cases for Analysis, edition for MS OfficePower User / ITCentralized creation ofAnalysis content (workbooks& PowerPoints)Sophisticated workbookdesign (VBA APIs and so on) 2012 SAP AG. All rights reserved.Business AnalystAd Hoc data access and dataanalysis, slicing & dicing, andso on, in ExcelAd Hoc embedding of BI datainto PowerPoint presentationsBusiness User &Task WorkerConsuming pre-defined BIcontent in Microsoft Exceland Microsoft PowerPointThis 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-infringement17
Simpler and More Intuitive User Experiencefor Fast Business InsightsModern and familiarMicrosoft Officeuser experienceFew simple clicksto fast businessinsightsSimplified drag-&drop to filter, andslice-&-dice 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement18
More Powerful with Live PresentationsLive analyses embedded intoPowerPoint presentationsExport current analysis from ExcelInsert BEx query results directlyAnalysis embedded as live object 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement19
Design PanelNew Design Panel for easy navigationViewsAnalysisAllows navigation, filtering, slice & dice etc.InformationGeneral information on the embedded data source or theworkbook itself (i.e. last data refresh, created by, etc.)All relevant information (filters, variables, etc.) at a glanceComponents:Structural information view either from the data source orthe worksheet perspectiveAccess to planning featuresNavigationSimplified drag&drop within panel or into grid to filter,drill-down, slice&dice, replace, and so onHarmonized with other BusinessObjects clientsFinger-tip access to hierarchiesAccess to display attributes 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement20
Analysis Options for Business AnalystNew options for the end-userDefine conditional formatting (aka “exceptions”)Define filter by measure (aka “conditions”)Define easy calculations and dynamic calculationsExcel commentary on data cellsNew hierarchy featuresCollapse into hierarchical structures (“displayhierarchy”)Show/hide hierarchy levelsSort breaking hierarchiesPause refreshDesign of several steps with only one finalroundtrip to the server to fetch the data 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement21
Easy Application BuildingWorkbook DesignEasy insertion of multiple data source (frommultiple systems)Improved overview of BW elements in an ExcelworkbookFree formatting of text elementsAdd Excel-based chartsNew API as Excel formulasEasy development, directly in worksheetTightly integrated into Excel developmentframeworkAPI for filtering, drilldown, etc.Sharing Workbooks/PowerPoint filesSave workbook/ppt presentation in SAPBusinessObjects BI Platform 2012 SAP AG. All rights reserved.This presentation and SAP‘s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice. This document 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-infringement22
News in Release 1.1PlanningSupport of BW-integrated planning and PAKFocus on usabilitySupport of HANAEnhanced Support of BI 4.0Client interoperabilityEnhanced API designE.g. set drill state, execute planning functionsGA since July 2011 2012 SAP AG. All rights reserved.Continuous improvementEditable conditional formatting rulesSave workbook without dataDefault workbookThis 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-infringement23
News in Release 1.2Planning EnhancementsCell LockingEnhanced HANA supportLanguage-dependent textsOLAP connection in CMC (as of BI platform 4.0FP3)Application DevelopmentAPIs for controlling Analysis Office without ribbonUsabilityImproved promptingGA since Jan 2012 2012 SAP AG. All rights reserved.Continuous ImprovementVariable unmergeCopy & PasteThis 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-infringement24
Analysis, edition for MS Office : High Level ArchitectureBI Consumer ServicesDataAnalysis,edition for Microsoft OfficeDirect BW Connectivity via BI ConsumerServicesConnection management via BI platform(optional)BI platform repository services for workbooksand PowerPoint filesAnalysis View (*)Single Sign-On (*)(*) as of Analysis Office 1.1and BI Platform 4.0ConnectionsSAP NetWeaver BW 7.xSAP HANA(BEx Queries, views,InfoProviders)SAP Sources 2012 SAP AG. All rights reserved.Repository / BI LaunchpadBusinessObjects BIPlatformThis 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-infringement25
SAP BusinessObjects Analysis, edition for MicrosoftOffice 1.0/1.1 – PrerequisitesClient PrerequisitesMS Office 2003, MS Office 2007 or MS Office 2010 (on MS Windows XP and higher)– Powerpoint Add-in only available for MS Office 2007 and MS Office 2010SAP GUI installation not mandatory– But local SAPLOGON.INI file required if you don‘t use BI Platform for connection managementClient Sizing: See SAP note 1466118Server PrerequisitesSAP NetWeaver BW 7.0 or higher– Recommendation: use BW 7.0 EHP1 or even SAP NetWeaver BW 7.3 as there are significant TCOand integration improvements between BusinessObjects Enterprise and NetWeaver– Queries defined in SAP BEx Query Designer 3.5 (within SAP NetWeaver 7.0!) or 7.0 ; also: directaccess to SAP NetWeaver BW InfoProvider and query viewso No need to migrate queries, no change in BW data models necessaryo The SAP BEx Query Designer stays as it is an
SAP BusinessObjects Analysis, edition for application design Powerful analytical & planning apps on SAP BW and HANA – PREVIEW . Customer- and SAP-delivered content Mobile support HANA support Analysis, edition for Microsof
