SAP BusinessObjects Analysis: What, Why, and How Thierry Audas, SAP

Remember the Product Integration Roadmap… Introducing Pioneer, a.k.a., SAP BusinessObjects Analysis

© 2011 SAP AG. All rights reserved.

1

Agenda

What is SAP BusinessObjects Analysis Why you should adopt SAP BusinessObjects Analysis How you can adopt SAP BusinessObjects Analysis Wrap-up

© 2011 SAP AG. All rights reserved.

2

What is SAP BusinessObjects Analysis

Naming Convention

Pioneer Pioneer Office Pioneer Web

Project Code Names

SAP BusinessObjects Advanced Analysis SAP BusinessObjects Analysis SAP BusinessObjects Analysis, edition for Microsoft Office SAP BusinessObjects Analysis, edition for OLAP SAP BusinessObjects Analysis, Web edition © 2011 SAP AG. All rights reserved.

4

1 Umbrella Name / 2 Sets of Functionality

SAP BusinessObjects Analysis, edition for Microsoft Office

SAP BusinessObjects Analysis, edition for OLAP



SAP NetWeaver BW



SAP NetWeaver BW



SAP HANA



MS SQL Server Analysis Services



Excel-based OLAP analysis



Web-based OLAP analysis



Excel-based BI applications



Live PowerPoint presentations

© 2011 SAP AG. All rights reserved.

5

SAP BusinessObjects Analysis, Edition for Microsoft Office Your investments in SAP BEx Analyzer are safe BEx Analyzer and the suite of SAP BEx tools stay in maintenance mode They will still be delivered with the next releases of SAP NetWeaver BW They follow the same life cycle and release strategy as BW  E.g., BEx Analyzer shipped with BW 7.3 will be supported for the next 7+2 years

You will leverage most of these investments moving forward BEx queries are consumed directly by SAP BusinessObjects BI 4.0 front-ends BEx Query Designer remains in place to create and maintain BEx queries

Your future looks bright New offering: SAP BusinessObjects Analysis, edition for MS Office Alternative to BEx Analyzer with enhanced premium functionality © 2011 SAP AG. All rights reserved.

6

Simpler and More Intuitive User Experience for Fast Business Insights

Modern and familiar Microsoft Office user experience Few simple clicks to analyze in new analysis panel

Simplified drag-&drop to filter, and slice-&-dice © 2011 SAP AG. All rights reserved.

7

More Powerful with Live Presentations

Live analyses embedded into PowerPoint presentations Export current analysis from Excel Insert BEx query results directly Analysis embedded as live object

© 2011 SAP AG. All rights reserved.

8

More Powerful with Pervasive BI Applications

Powerful application design Combine multiple data sources Free formatting of text elements

New APIs as Excel formulas Write-back to BW-IP

© 2011 SAP AG. All rights reserved.

9

SAP BusinessObjects Analysis, Edition for OLAP

Dashboards Crystal Reports

Web Intelligence

Analysis Explorer

With SAP BusinessObjects BI 4.0 SAP BusinessObjects Analysis, edition for OLAP is the successor of SAP BusinessObjects Voyager in the suite of SAP BusinessObjects BI solutions © 2011 SAP AG. All rights reserved.

10

Uncover Deep Business Insights with Web-based Self-Service Analysis

Few simple clicks to analyze with tabbed toolbars

Pervasive webbased analysis Modern look-and-feel with intuitive drag-and-drop to filter, and slice-&-dice © 2011 SAP AG. All rights reserved.

11

High-Level Functional Architecture 2 Modes to Deploy and Use the Edition for MS Office Edition for MS Office

OLAP Edition

IE

Client/Server

SAP BW © 2011 SAP AG. All rights reserved.

BI Platform

Safari

Firefox

BI Platform

SAP BW

MS Analysis Services 12

SAP BusinessObjects BI Platform Services

Unified self-service access to all BI content  Analysis workspaces, dashboards, reports, alerts, and BEx Web apps  Across multiple data sources  Integrated with SAP Portal

Metadata management  SAP BusinessObjects universes  Connections to BW/BEx queries

BEx Web Apps Analysis Dashboards

Security management  Integrated with SAP Identity Manager

Crystal Reports

Life cycle management  Integrated with SAP CTS+

Web Intelligence

Publishing & broadcasting

© 2011 SAP AG. All rights reserved.

13

The BI Platform Brings Interoperability with the Suite of SAP BusinessObjects BI Solutions Leverage Analysis Views to build (interactive) reports upon and share analysis with more business users SAP BusinessObjects Analysis*

SAP BusinessObjects Web Intelligence

SAP Crystal Reports

Analysis Views SAP BusinessObjects BI 4.0 Platform

1. A business analyst produces an analysis 2. The BI platform enables to share the OLAP query definition (Analysis View)

3. Other business users build and/or consume (interactive) reports off the OLAP query

SAP BW

*: Edition for OLAP or for MS Office © 2011 SAP AG. All rights reserved.

14

Edition for MS Office – Product Directions Agile Life Cycle Separate from the BI Suite Life Cycle 2012 and beyond Platform Integration

v1.2 in Q4 2011* In-Memory Analysis v1.1 Budgeting/Planning

■ ■

Write-back to BW-IP

■

Deploy with SAP BusinessObjects BI 4.0

Capabilities

Benefits

Usabiity improvements for promptiing

■

Enhanced integration to SAP HANA

■

Batch publishing of XL workbooks and PPT presentations

■

Save and share variable variants

■

Report linking via Report-toReport Interface

■

Access 3rd-party data sources

■

Run with SAP HANA

■

Budgeting/planning apps

■

Increased user satisfaction

■

Mutualize platform services

■

Analytical apps with simulation

■

High performance analysis in MS Office

■

BI standardization

*: Time frame for entering ramp-up © 2011 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 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.

15

OLAP Edition – Product Directions Life Cycle Aligned with the BI Suite 2012 and beyond Expansion

v4.1 in Q4 2011* Optimization v4.0 Innovation

■

■

Capabilities

Benefits

■

Web-based self-service analysis

Increased analytical power for SAP BW

■

Multidimensional analytical power

Performance optimizations for MS Analysis Services

■

Run with SAP HANA and SAP BusinessObjects EPM solutions

■

Run with SAP BW and MS Analysis Services

■

Business user autonomy

■

User satisfaction

■

Broad adoption

■

BI standardization

■

Enhanced integration to SAP BusinessObjects EPM solutions

■

Additional 3rd-party data sources

■

Fit into broader Web-based analytic app. dev. environment

■

High performance Web-based analysis in real time

■

Web-based app building

*: Time frame for entering ramp-up © 2011 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 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.

16

Why you should adopt SAP BusinessObjects Analysis

Leverage Investments in SAP NetWeaver BW and SAP BEx Queries Innovate without disruption to your current environment and operations Direct connection to BEx queries (BICS) No need to edit or migrate BEx queries No need to change BW InfoProviders Support BW 7.x and BEx queries 3.5/7.x BEx Query Designer remains in place

© 2011 SAP AG. All rights reserved.

18

Increase Self-Service BI and User Autonomy…

Improved user experience vs. BEx Simpler to use More intuitive

No loss of analytical power Increased user satisfaction Increased self-service usage Increased user autonomy

© 2011 SAP AG. All rights reserved.

19

…While Optimizing TCO

Do more with less Minimize user training and support costs Minimize IT customization costs Adopt new BI platform at your own pace

Leverage all your investments Extend the reach of BW deployment Bring all analytics to one BI platform Support MS Analysis Services

© 2011 SAP AG. All rights reserved.

20

Enable a Smooth Transition from SAP BEx to SAP BusinessObjects BI Transition BEx Analyzer users now Support for familiar BEx queries and BEx Analyzer features Improved user experience and satisfaction Start now with light footprint and extend with the SAP BusinessObjects BI platform when needed

© 2011 SAP AG. All rights reserved.

21

What’s New for SAP BEx Analyzer Users

New user experience    

Analysis panel Drag-and-drop analysis Undo button MS Office-like ribbons

New PowerPoint integration  Export current analysis  Insert new analysis  Live integration

© 2011 SAP AG. All rights reserved.

New analytical capabilities    

Conditional formatting Combine multiple BW cubes Free formatting of text elements New APIs as Excel formulas

New information sharing  Interoperability with SAP BusinessObjects BI solutions

22

What’s New for SAP BusinessObjects Voyager or SAP BEx Web Analyzer Users New user experience      

Quick Access toolbar Tabbed toolbar Task panel Layout panel Multiple sheets Deferred query (auto update)

New data presentation    

Positioning of members Asymmetric drilling Member reordering Swap axes

© 2011 SAP AG. All rights reserved.

New analytical capabilities      

Sorting Search Conditional formatting Calculations Null and zero suppression Multiple data sources

New information sharing  Interoperability with SAP BusinessObjects BI solutions  Export to Excel and PDF 23

How you can adopt SAP BusinessObjects Analysis

Edition for MS Office – High-Level Architecture Scenario 1: Client/Server Deployment 1 1.

Connection management

2 2.

XL workbook / PPT management

3 3.

Data access

1 Local file folder and/or rd 3 -party file server

2

saplogon.ini

BI Consumer Services (BICS)

3

SAP BW

© 2011 SAP AG. All rights reserved.

25

Edition for MS Office – High-Level Architecture Scenario 2: BI Platform Deployment 1 1. Connection management 2 2. XL workbook / PPT management

1

3 3. Data access

2 HTTP

4 4. Batch publishing (future)

3 SAP BusinessObjects BI Platform

BICS

SAP BW

© 2011 SAP AG. All rights reserved.

4

26

Run the Edition for MS Office and SAP BEx Analyzer Side-by-Side No need for a ‘big bang’ swap Install the edition for MS Office without deinstalling BEx Analyzer One add-in only can be active at a time BEx workbooks trigger the BEx Analyzer add-in

© 2011 SAP AG. All rights reserved.

27

Edition for MS Office – Technical Prerequisites

Client Windows XP or higher

MS Office 2003 or higher / MS Office 2007 or higher for PowerPoint No requirement for SAP GUI

SAP NetWeaver BW Version 7.0 or higher No requirement for BI Java usage type

SAP BusinessObjects BI platform (optional) SAP BusinessObjects XI 3.1 or SAP BusinessObjects BI 4.0 Windows or Unix OS supported by the BI platform SAP NetWeaver J2EE 7.1 or any web server supported by the BI platform

© 2011 SAP AG. All rights reserved.

28

OLAP Edition – High-Level Architecture Web Browser

Zero-client Web-based architecture 1 2

Analysis workspace management with the SAP BusinessObjects BI platform

AJAX & HTTP

1

Data access with MDX queries to MS Analysis Services

SAP BusinessObjects BI Platform BICS

SAP BW © 2011 SAP AG. All rights reserved.

2

MS Analysis Services 29

Deploy SAP BEx Web Templates with SAP BusinessObjects BI 4.0 Web Browser

SAP BusinessObjects BI 4.0 can host BEx Web templates 1

BEx Web runtime is embedded within the SAP BusinessObjects BI platform

2

BEx WAD remains in place to create and maintain BEx Web templates and publish to the SAP BusinessObjects BI platform

1

2

SAP BEx WAD

© 2011 SAP AG. All rights reserved.

SAP BusinessObjects BI Platform

SAP BW 30

SAP BI Back-end Stack – Before and After SAP-Centric Scenario: All BI Run on SAP NetWeaver J2EE After: BW + Analysis for OLAP Before: BW + BEx Ent. Portal

Enterprise Portal Usage Type

BEx Web

BI Launchpad Analysis

BEx Web

BusinessObjects BI Platform

BI Java Usage Type

NetWeaver J2EE

NetWeaver J2EE Windows / Unix Servers BI ABAP Usage Type

BusinessObjects BI Platform

NetWeaver ABAP App Server BI ABAP Usage Type Windows / Unix OS

NetWeaver ABAP App Server Windows / Unix OS

© 2011 SAP AG. All rights reserved.

31

SAP BI Back-end Stack – Before and After Heterogeneous Scenario: 3rd-party Web App Server and Portal After: BW + Analysis for OLAP Before: BW + BEx

3rd-party Portal BI Launchpad Enterprise Portal Usage Type

BEx Web

Analysis

BEx Web

BusinessObjects BI Platform

BI Java Usage Type

3rd-party Web App Server

NetWeaver J2EE Windows / Unix Servers BI ABAP Usage Type

BusinessObjects BI Platform

NetWeaver ABAP App Server BI ABAP Usage Type Windows / Unix OS

NetWeaver ABAP App Server Windows / Unix OS

© 2011 SAP AG. All rights reserved.

32

OLAP Edition – Technical Prerequisites

Client Internet Explorer 7 or 8

Safari 4 Firefox 3.5

OLAP server SAP NetWeaver BW 7.0 SP 23 or higher No requirement for BI Java usage type MS Analysis Services 2005 SP1, 2008, or higher

SAP BusinessObjects BI platform SAP BusinessObjects BI 4.0 Windows or Unix OS supported by the BI platform SAP NetWeaver J2EE 7.1 or any web server supported by the BI platform © 2011 SAP AG. All rights reserved.

33

Wrap-up

The Suite of SAP BusinessObjects BI Solutions Expands Upon SAP BusinessObjects Analysis

Dashboards

Web Intelligence

Analysis

Crystal Reports

How do I turn data into pixel-perfect formatted reports for greater insight?

How do I visualize key performance indicators for better decision making?

Explorer

How do I answer ad hoc questions and interact with shared information?

How do I uncover trends from historical data and make possible better forecasts?

How do I find immediate answers to business questions?

DIFFERENT NEEDS © 2011 SAP AG. All rights reserved.

35

Integration with SAP In-Memory Computing

SAP NetWeaver BW Accelerator Leverage investments in BWA to accelerate SAP BusinessObjects Analysis on BW Seemless move from BEx Analyzer

SAP HANA The edition for MS Office runs with HANA for real-time analysis of large volume of non-aggregated SAP and non-SAP data at unprecedented speeds The edition for MS Office v1.2 will provide an enhanced integration with support for specific metadata

© 2011 SAP AG. All rights reserved.

36

Transitioning to the SAP BusinessObjects BI Suite in a Phased Approach

1. Start with

LoB Benefits

BEx Queries

• Analysis Office • Dashboards

Solid and safe foundation

Innovation with no disruption Best-of-breed BI  Simpler, more expansion intuitive, powerful  Better monitoring of the business

IT Benefits

2. Add the BI Platform with • Analysis OLAP • Crystal Reports • Explorer

 Google-like  Pixel-perfect  Self-service

3. Complete the deployment of the full BI suite with Web Intelligence

Trusted insights for all users, all data, on one platform

Increasing user satisfaction and adoption, and more user self-service

© 2011 SAP AG. All rights reserved.

37

Thank You!

[email protected]

© 2011 SAP AG. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation. IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation. Linux is the registered trademark of Linus Torvalds in the U.S. and other countries. Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries.

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer, StreamWork, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company. Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary. The information in this document is proprietary to SAP. No part of this document may be reproduced, copied, or transmitted in any form or for any purpose without the express prior written permission of SAP AG.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group. Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc. HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C ®, World Wide Web Consortium, Massachusetts Institute of Technology.

© 2011 SAP AG. All rights reserved.

39