BI 4 0 and EIM 4 0 The
BI 4. 0 and EIM 4. 0
The SAP Business. Objects™ Portfolio Enterprise Performance Management Governance, Risk, and Compliance Strategy Management Business Planning Risk Management Access Control Profitability and Cost Management Consolidation Process Control Global Trade Services Spend Analytics Environment, Health and Safety Information Discovery Delivery Reporting Query, Reporting, and Analysis Dashboards and Visualization Search and Navigation Advanced Analytics © 2012 SAP AG. All rights reserved. Enterprise Information Management Data Integration Data Quality Management Master Data Management Metadata Management 2
SAP Business. Objects Business Intelligence 4. 0 Business Intelligence
SAP’s strategic focus on business intelligence Core Creative Mobile Extreme Social Core for innovation Complete BI suite Continued leadership Use by IT and departments Fast time to value Connection to the enterprise First experience for BI Content to point of impact Expansion to untapped users Big data Real time Predictive Ability to capture the decision Information in context Ability to leverage the network © 2012 SAP AG. All rights reserved. 4
Introducing SAP Business. Objects Business Intelligence One unified and complete BI suite addressing the full spectrum of BI needs Dashboarding Operational Reporting Ad-hoc Reporting BI Platform Multidimensional Analysis Data Discovery Trusted Data © 2012 SAP AG. All rights reserved. 5
Common Semantic Layer Building on common foundation layers Crystal Reports Web Intelligence Dashboards Explorer Live Office Key value BI Clients Information Designer and SDK Query and Calculation Engine Servicing Data Web Services SAP BW § Enable consistent business user experience Business Layer Data Foundation Single or Multi-source Data Federator Engine OLAP © 2012 SAP AG. All rights reserved. Application Database Customer Database Text XML § Trusted access to information § Heterogeneous access over all sources § Multi-source access § Secured and controlled by IT Web Service 6
Semantic Layer New semantic layer for more data and true multi-dimensional support Access to More Insight § Common access experience across the different BI clients for all data sources § New abstraction layer for multi-dimensional data sources § Native multi-source support for universes leveraging SAP Business. Objects Data Federator © 2012 SAP AG. All rights reserved. 7
Member Selection Based on Depth (1/2) In OLAP query panel member selection, members can be selected based on names levels or based on depth. This can be done from the root or from any member © 2012 SAP AG. All rights reserved. 8
Member Selection Based on Depth (2/2) © 2012 SAP AG. All rights reserved. 9
Low TCO access The weight-watcher test Before: Silo’ed connectivities in SAP Business. Objects XI 3. 1 Crystal Reports BAPI Web Intelligence Universe Xcelsius BICS MDX BEx Query Info. Providers SAP Net. Weaver BW © 2012 SAP AG. All rights reserved. 10
Low TCO access The weight-watcher test Before: Silo’ed connectivities in SAP Business. Objects XI 3. 1 After: Unified direct BICS access in SAP Business. Objects BI 4. 0 Web Intelligence Xcelsius Crystal Reports, Web Intelligence, Dashboards, and Analysis BICS Crystal Reports BAPI Universe MDX BEx Query Info. Providers SAP Net. Weaver BW © 2012 SAP AG. All rights reserved. 11
Minimize user training, support, and customization costs Best-of-breed BI suite Consolidate BI for all users across all data sources on one BI platform Shield users from 3 rd-party data access complexity with unified experience Best access method for each specific data source Reporting, dashboarding, ad-hoc, data discovery Universe Multi-Source Universe MDX SQL BAPI Analysis Universe SQL BICS MDX BEx Query 3 rd-party OLAP Server 3 rd-party Data Warehouse © 2012 SAP AG. All rights reserved. Info. Providers SAP Net. Weaver BW 3 rd-party OLAP Server 12
Innovation without disruption to Web Intelligence users n Legacy universe access and BICS access co-exist in BI 4. 0 n Users gain new SAP BW hierarchy navigation in Web Intelligence 4. 0 XI 3. 1 Co-existence in BI 4. 0 Target Web Intelligence Universe MDX BICS BEx Query Info. Providers SAP Net. Weaver BW © 2012 SAP AG. All rights reserved. 13
Introducing SAP Business. Objects Business Intelligence One unified and complete BI suite addressing the full spectrum of BI needs Dashboarding Operational Reporting Ad-hoc Reporting BI Platform Multidimensional Analysis Data Discovery Trusted Data © 2012 SAP AG. All rights reserved. 14
Operational Reporting Crystal Reports Next-Generation Report Designer Experience § New styling with ribbon bar look and feel § Common query design experience across all data sources with new semantic layer § Improved direct access to SAP Net. Weaver BW queries © 2012 SAP AG. All rights reserved. 15
Operational Reporting Crystal Reports Global Reach with Multilingual Reporting § Crystal content - text objects, prompts, tooltips - translated to multiple languages § Scheduling and distribution of Crystal reports in multiple languages § Support of BI platform translation services Translation Manager © 2012 SAP AG. All rights reserved. 16
Operational Reporting Crystal Reports OLAP Client – Crystal Reports Interoperability § Rendering of OLAP data analysis in for production reporting and in print – optimized format § High volume publishing and scheduling of reports that include OLAP data © 2012 SAP AG. All rights reserved. 17
Transform the way SAP Business Suite users gain actionable insights Unique combinations Embedded analytics within the SAP Business Suite • Actionable insights like never before • Best-practice business analytics content • Deep and unique integration • Accelerate your BI deployment for fast ROI • Optimize efficiency of business processes • Enable pervasive BI from the board room to the shop floor © 2012 SAP AG. All rights reserved. 18
SAP Business. Objects BI SP 4 Actionable BI Invoke operational transactions in both SAP and non-SAP applications Key New Capabilities Supported by SAP Crystal Reports and SAP Business. Objects Dashboards Requires SAP BW to define an action Supported actions n Generic web addresses like Google maps n BEx and BW web applications n Crystal Reports and Dashboards n Transactions n ABAP reports n BW and Infoset queries Web Services SAP Applications BI Documents Can be parameterized © 2012 SAP AG. All rights reserved. 19
Introducing SAP Business. Objects Business Intelligence One unified and complete BI suite addressing the full spectrum of BI needs Dashboarding Operational Reporting Ad-hoc Reporting BI Platform Multidimensional Analysis Data Discovery Trusted Data © 2012 SAP AG. All rights reserved. 20
Dashboards and Visualizations BI Dashboards (formally Xcelsius) Simpler Authoring Experience § Common design experience across all data sources with support for new semantic layer § Improved authoring via query integration and direct access to semantic layer § Alert consumption via BI platform services © 2012 SAP AG. All rights reserved. 21
Dashboard Designer (SAP Sources Only) Planned innovation without disruption 3. Put the “Zen” project on your roadmap Premium alternative to SAP BEx Web Application Designer WYSIWYG design of powerful interactive dashboards Modern and compelling HTML 5 rendering for mobile deployments Optimized for SAP BW and SAP HANA with direct BICS access The future of dashboards – strategy and direction: http: //blogs. sap. com/analytics/2012/04/17/the-future-of-dashboards-strategy-and-direction/ © 2012 SAP AG. All rights reserved. 22
Introducing SAP Business. Objects Business Intelligence One unified and complete BI suite addressing the full spectrum of BI needs Dashboarding Operational Reporting Ad-hoc Reporting BI Platform Multidimensional Analysis Data Discovery Trusted Data © 2012 SAP AG. All rights reserved. 23
Ad hoc Reporting Web Intelligence New Multi-Dimensional Data Support § Multi-dimensional data and hierarchy support § Common design experience across all data sources with new semantic layer © 2012 SAP AG. All rights reserved. 24
Ad hoc Reporting Web Intelligence Refined User Experience and Interactivity § Refined user experience with new charting options and toolbar § Expanded interactivity for ad hoc and guided analysis workflows § On-the-fly data browsing and query result validation © 2012 SAP AG. All rights reserved. 25
UX Harmonization: Web Intelligence BEFORE © 2012 SAP AG. All rights reserved. 26
UX Harmonization: Web Intelligence AFTER New toolbar design to incorporate © 2012 SAP AG. All rights reserved. 27
Ad hoc Reporting Web Intelligence OLAP Client – Web Intelligence Interoperability § Refined formatting and layout of OLAP data for further analysis § Merge additional sources to OLAP data § OLAP data available offline © 2012 SAP AG. All rights reserved. 28
Introducing SAP Business. Objects Business Intelligence One unified and complete BI suite addressing the full spectrum of BI needs Dashboarding Operational Reporting Ad-hoc Reporting BI Platform Multidimensional Analysis Data Discovery Trusted Data © 2012 SAP AG. All rights reserved. 29
Multidimensional Analysis – Edition for MS Office, Edition for Excel Next-Generation OLAP Analysis Client § Richer OLAP analysis capabilities for analysts § Multi-dimensional analysis embedded into Microsoft Office Excel for business users § Seamless interoperability with Crystal Reports and Web Intelligence © 2012 SAP AG. All rights reserved. 30
Multidimensional Analysis – Edition for MS Office, Edition for Excel SAP Business. Objects SAP Net. Weaver BEx Advanced OLAP Voyager BEx Analyzer Leading Web Visualization Multiple Sources Native Excel Integration Analysis for MS Office © 2012 SAP AG. All rights reserved. SAP 2009 / Page 31 SAP Net. Weaver BWA Analysis Web 31
Bootstrap transition from SAP BEx with next-gen multidimensional analysis solutions from SAP Innovation without disruption Simpler and more intuitive Few simple clicks and drag-&-drop to fast and deep business insights Intuitive navigation across multiple dimensions and hierarchies Modern and familiar MS Office or Web 2. 0 experience More powerful Bring live analyses into Power. Point presentations Break data silos to enrich analyses and visualizations Integrated planning with write-back to BW-IP Easy to adopt No loss of functionality vs. BEx analyzer* No need to change existing BW cubes or BEx queries Automated migration of simple BEx workbooks* *: as of version 1. 3 of the edition for MS Office © 2012 SAP AG. All rights reserved. SAP Business. Objects Analysis 32
Adopt the SAP Business. Objects BI suite at your own pace Innovation without disruption 1. Start now with SAP Business. Objects Analysis, edition for MS Office, in C/S 2. Adopt the SAP Business. Objects BI suite and deploy the BI platform based on the business needs Business Needs SAP BEx SAP Business. Objects BI Excel-based analysis BEx Analyzer Analysis, edition for MS Office Web-based analysis BEx Web Analyzer/Templates Analysis, edition for OLAP Reporting BEx Report Designer Crystal Reports Dashboarding BEx Web Application Designer Dashboards/Dashboard Designer Ad-hoc Web Intelligence Data Discovery Explorer/Visual Intelligence © 2012 SAP AG. All rights reserved. 33
Introducing SAP Business. Objects Business Intelligence One unified and complete BI suite addressing the full spectrum of BI needs Dashboarding Operational Reporting Ad-hoc Reporting BI Platform Multidimensional Analysis Data Discovery Trusted Data © 2012 SAP AG. All rights reserved. 34
Step 1: Acquire Your Own Data Time and geography awareness Easy drag and drop for immediate adhoc views Consume, categorize, and filter measures and variables © 2012 SAP AG. All rights reserved. No need to build queries or use scripts 35
Step 2: Transform Data The Way You Want It Data Manipulation for measures and text Combine values or create new Groups Create measures with new formulas © 2012 SAP AG. All rights reserved. No need to build queries or use scripts 36
Step 3: Build Your Own Visualizations (BYOV) © 2012 SAP AG. All rights reserved. 37
Boost user adoption with mobile BI anytime, anywhere Best-of-breed BI suite Stunning native visualizations with interactive gesture and offline access Quick time-to-value with no application development Leverage SAP Business. Objects and Sybase platforms Dashboarding Operational Reporting Ad-hoc Reporting BI Platform Multidimensional Analysis Data Discovery Explore mountains of data at Leverage existing investments and Trusted Data the speed of thought on the go skills to mobilize targeted BI content © 2012 SAP AG. All rights reserved. 38
BI Launchpad (formally Info. View) Easier Content Navigation for All Users § New self-service BI access making it easier to find all available content § Enhanced filtering and search options reducing page scrolling § Enhanced navigation for working with multiple documents at the same time © 2012 SAP AG. All rights reserved. 39
BI Platform improvements Global readiness and scalability Multilingual BI delivery across geographic locations Enhanced scalability with virtualization and 64 -bit support Continued heterogeneous platform and database support Comprehensive system monitoring and diagnosis Automatic diagnosis for performance optimization Health dashboard, watches, and alerts for tailored system insight Complete auditing tracking for compliance and usage analysis Expanded deployment options Right-fit on-premise deployment with reduced maintenance Next generation On. Demand BI © 2012 SAP AG. All rights reserved. 40
Business Intelligence Platform Overview – Platform Functions What are the Platform Functions and what is new? As the name indicates Platform Functions are functionalities included in the Business Intelligence Platform deployment. Administrators, users and developers benefit from these, often innovative, functions. Focus of this overview are the functions that are being enhanced or newly included with BI 4. 0 SP 4: Integrated Lifecycle Management & Version Management Hot Backup Customer User Attributes BCC Address in Email SQL Anywhere Insight to Action Framework Monitoring Platform Search Publishing RESTful Web Services SAML Authentication Stream. Work Integration © 2012 SAP AG. All rights reserved. 41
Leverage your investments in the SAP Net. Weaver technology platform Unique combinations SAP Solution Manager Unified system monitoring End-to-end root cause analysis SAP Change & Transport System Unified change and transport management BI lifecycle triggered from SAP CTS+ Common infrastructure Unified Java application environment Support for SAP Net. Weaver WAS © 2012 SAP AG. All rights reserved. 42
Enable the real-time business with accelerated BI powered by SAP HANA Unique combinations Access to all your data like never before Increase business insight and self service usage Accelerate SAP Business. Objects BI and BW deployments without disruption Analysis Reporting, Dashboards, Ad-hoc, Discovery BICS/SQL Multi-Source Universes SQL Discovery BICS/SQL BEx Query PH SA AN A PH AN A P SA NA A H SA BW Powered by HANA © 2012 SAP AG. All rights reserved. 43
SAP Business. Objects Business Intelligence 4. 0 Information Management
Business. Objects EIM 4. 1 Data Services n n Native support for unstructured data (Text Analysis) Shared services with BOE (scheduling, security, admin) Master Data Management n Single data integration platform for SAP Net. Weaver BW Embedded Data Quality as preconfigured shipment n Enterprise Information Management Data Services Data Federator n n Single Designer environment for accessing multiple data sources for BI solutions Performance enhancements with engine update Shared services with BOE (scheduling, security, admin) © 2012 SAP AG. All rights reserved. Master Data Management Metadata Management Data Quality Management Data Federator n n Analytical MDM – hierarchy management Tighter MDM and Data Services integration Generic infrastructure integrated with NW BPM Data Quality Management n Expanded data and address cleansing n Strengthened non-party data support n Enhanced DQM embedded into SAP and non-SAP apps Metadata Management and Data Profiling n Single solution for data profiling and metadata management n Information governance solution with business user and IT collaboration 45
SAP Business. Objects 4. 0 Common server & services layer for both BI and EIM DQM SDK Data Services (C++/JAVA/. Net) Data Services Information Steward (C++/JAVA) (JAVA/Flex UI) (C++/JAVA) DQM SDK DQM TDP Monitoring Cleansing Package Builder Profiling Impact Lineage DI Transform SDK DS Platform Data Services Data Quality server & services layer for both BI and EIM BOE ORCommon New Security/Scheduling Module Text Data Processing Information Steward This common server & services layer offers many new features to SAP Business. Objects EIM customers: n Single location to store all users, passwords, and connections to repositories n Advanced user management with password policies and advanced security features n Use of external authentication mechanisms like Active Directory, LDAP or SAP Net. Weaver n Permission management to control access to repositories and administative tasks to a more granular level © 2012 SAP AG. All rights reserved. 46
Data Services: Aurora Roadmap Data Integration and Data Quality All Information n Native support for unstructured data with SAP Business. Objects Text Analysis natively integrated into the Data Services platform n Expanded data cleanse and address cleanse capabilities for different regions Trusted Information and cultural based matching n Enhanced facilities to build and manage data quality solutions for non-party data n Introducing Embedded DQ library with API minus the Data Services platform Complete and Integrated © 2012 SAP AG. All rights reserved. n Single data integration platform for SAP Net. Weaver BW for extracting data from SAP Business Suite and non-SAP data sources n Shared services with BOE for scheduling, security, and user administration 47
Hadoop/Hive Support in Data Services 4. 1 HANA, IQ, other Target Systems Files - y In or em M Databases Data Services Hadoop Data Services Web & Others Same familiar, easy-to-use UI design paradigm for Hadoop/Hive as other database systems but with specific behind-the-scenes extensions to leverage the power, scale and unique functionality of Hadoop High-performance reading from and loading into Hadoop – Hive support (table-like access to Hadoop data), using JDBC for metadata browsing – Direct HSFS file support through PIG scripts Extended Optimizer fully Hive. QL and PIG aware and generates optimized scripts for Hive and Hadoop © 2012 SAP AG. All rights reserved. 48
Text Data Processing for Unstructured Data http: //experience. sap. com/twitterta/sapsummit. jsp © 2012 SAP AG. All rights reserved. 49
EIM Suite Users Spotlight on the Business User ETL DQ © 2012 SAP AG. All rights reserved. Administrators Developers Designer Business User UI Platform Services Tools Data Stewards & Business Analysts Data Profile Text Analysis Core Platform Administration Meta data Typically IM products have not been focused on the non-IT users. The interfaces are much too technical for even those tasks that require considerable business knowledge and input. We plan to change that Enable Data Governance & Trust IM provides the key elements which enable Governance and improve trust in the data infrastructure. From data quality, to profiling to business metadata we plan to bring key IM capabilities in service of Governance initiatives IM Suite The cost of IM deployments has been exacerbated by piecemeal, disconnected tools. An integrated suite based on a common platform will reduce development and operating costs 50
Information Steward Single environment to discover, assess, define, monitor, and improve your enterprise data asset Discover and understand enterprise data Data Profiling, Metadata Discover Management Catalog data assets Information Steward Monitor & Remediate Monitor Data Quality © 2012 SAP AG. All rights reserved. Surface data quality scores in other applications Define business terms, validation rules, cleansing rules Define data ownership: Assign data ownership, accountability & roles Workflows to resolve data quality issues 51
Profiling and Scorecard Configured by Data Stewards in Information Steward Drill into scorecard details Scorecard to measure DQ from a Data Steward’s perspective Key Quality Dimensions (KPI for data) Latest quality score Data quality score metrics © 2012 SAP AG. All rights reserved. Quality trend 52
Thank You!
Appendixes Migration from SAP Business. Objects XI 3. 1 with SAP Net. Weaver BW
Web Intelligence and SAP Net. Weaver BW Customer perspective Low TCO © 2012 SAP AG. All rights reserved. High Performance Fully Dimensional 55
- Slides: 55