(1)SAP BusinessObjects Analysis, edition for
OLAP
Overview
Product Management Analysis Clients
April 2012
(2)2
© 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-infringement
(3)Agenda
Overview
SAP BusinessObjects Analysis, edition for OLAP
Appendix
(4)(5)BI 4.0 for SAP customers
Leverage your investments – BW info
providers and BEx queries
Transition BEx analyzer users to the
next generation of SAP BI
Adopt SAP BusinessObjects BI
platform at your own pace
Re-use existing infrastructure
Increase business user autonomy and
self-service usage
Boost BI adoption for more informed
decision making across the enterprise
Minimize user training, support and
customization costs
Simpler and more Intuitive
Tighter integration with the SAP
NetWeaver technology platform
BI standardization from the board
room to the shop floor
Increased speed and agility with
cost effective in-memory computing
SAP landscape simplification
Dashboards
Reporting
Interactive
Reporting
Analysis
Data
Exploration
(6)6
© 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-infringement
SAP BusinessObjects BI solutions provide business users with access to unified
information through a broad suite of BI tools for confident decision making and
alignment across people and teams on a single, scalable BI platform
Dashboards and
Visualization
How do I visualize
data for better
decision making?
How do I answer ad
hoc questions and
interact with
information?
Interactive
Reporting
Data Exploration
How do I find
immediate answers
to business
questions?
How do I determine
trends from complex
historical data and
possibly make better
forecasts?
Analysis
How do I access
and transform
corporate data into
highly formatted
reports for greater
insight?
Reporting
(7)SAP BusinessObjects Analysis
The Premium Alternative to BEx
W
e
b
M
S
O
ff
ic
e
A
n
a
ly
s
is
C
li
e
n
ts
Analytical Applications
AdHoc OLAP
Analysis, edition for application design
•
Premium Alternative to BEx Web App
Designer
•
Design studio for power users to create
purpose-built OLAP analysis & planning
apps
•
Customer- and SAP-delivered content
•
Mobile support
•
HANA support
Analysis, edition for Microsoft Office
•
IT / Developers, Data Analysts, Business Users
•
Excel-based OLAP analysis
•
Excel-based BI applications
•
Live PowerPoint presentations
•
HANA support
Analysis, edition for OLAP
•
Dedicated Ad-Hoc OLAP client for
business users to analyze OLAP
data and share it with others
•
Enabled for 3rd party OLAP
•
Seamless interoperability between
designer and ad-hoc client
(8)8
© 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-infringement
SAP® BusinessObjects™ Analysis, edition for Microsoft Office
Multidimensional Analysis of SAP BW and SAP HANA
Modern and familiar
Microsoft Office user
experience
Build powerful Excel
workbook BI
applications
Support BW-Integrated
Planning
Target User Groups:
BI Professional
Business User
Create live
PowerPoint
presentations
(9)SAP® BusinessObjects™ Analysis, edition for OLAP
The best web client for SAP BW and SAP HANA
Pervasive
web-based analysis
Modern look-and-feel with
intuitive drag-and-drop
Few simple clicks to
fast business insights
SAP BW, HANA,
EPM and Microsoft
Analysis Services
Interoperate with
WebI and Crystal
Reports
Target User Groups:
(10)10
© 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-infringement
SAP® BusinessObjects™ Analysis, edition for application design
Powerful analytical & planning apps on SAP BW and HANA – PREVIEW
Target User Groups:
IT
Key Users
Designers
Direct Access to BW
and HANA via BICS
State of the art
rendering: HTML5
Eclipse-based
application design
environment
iPad Apps
Premium alternative
to BEx WAD
(11)Interoperability Between Analysis and Other Clients in
2010 based on BI 4.0
Interoperability through Analysis View
Captures view on the data including filters and other features (similar to BEx query view)
Stored in BI platform
Can be created in SAP BusinessObjects Analysis (both editions)
Can be consumed by SAP BusinessObjects Analysis (both editions), Web Intelligence and Crystal
Reports (each tool interprets the analysis view in a way that is consistent with its native environment)
Semantic Layer 4.0
Web Intelligence
Crystal Reports
Analysis,
edition for MS Office
Analysis,
edition for OLAP
Shared Query
(Analysis View)
Create /
consume
Create /
consume
BICS Component
Create /
consume
Create /
consume
Interoperability
(Consume through
transient universe)
(12)(13)1 Umbrella Name / 2 Sets of Functionality
SAP BusinessObjects
Analysis,
edition for
OLAP
SAP BusinessObjects
Analysis,
edition for
Microsoft Office
SAP NetWeaver BW and SAP
HANA Appliance only
Excel-based
OLAP analysis
Excel-based BI applications
Live PowerPoint presentations
SAP NetWeaver BW
MS SQL Server Analysis Services
Web-based
OLAP analysis
(14)14
© 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-infringement
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
SAP BusinessObjects Analysis, edition for OLAP
Dashboards
Crystal
Reports
Web
Intelligence
Analysis
Explorer
(15)SAP BusinessObjects Analysis
The Premium Alternative to BEx
W
e
b
M
S
O
ff
ic
e
A
n
a
ly
s
is
C
li
e
n
ts
Analytical Applications
AdHoc OLAP
Analysis, edition for application design
•
Premium Alternative to BEx Web App
Designer
•
Design studio for power users to create
purpose-built OLAP analysis & planning
apps
•
Customer- and SAP-delivered content
•
Mobile support
•
HANA support
Analysis, edition for Microsoft Office
•
IT / Developers, Data Analysts, Business Users
•
Excel-based OLAP analysis
•
Excel-based BI applications
•
Live PowerPoint presentations
•
HANA support
Analysis, edition for OLAP
•
Dedicated Ad-Hoc OLAP client for
business users to analyze OLAP
data and share it with others
•
Enabled for 3rd party OLAP
•
Seamless interoperability between
designer and ad-hoc client
(16)16
© 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-infringement
Use Cases for Analysis, edition for OLAP
Business User &
Task Worker
Power User / IT
Business Analyst
Creation of re-usable Analysis
workspaces
Not necessarily an expert for
sophisticated BI Application
Design
Ad Hoc data access and data
analysis, slicing & dicing
Creation of Analysis
workspaces for personal use
Can use pre-defined Web
workspaces
Need to operate between
Analysis and more BI
consumer tools like Web
Intelligence
(17)SAP BusinessObjects Analysis, edition for OLAP
Product description
Analysis, edition for OLAP is a self-service, data exploration and analysis tool for business analysts in mid to
large enterprises who want to quickly answer their complex questions. It is THE go-to analysis tool for BW &
HANA customers and also caters for selected 3
rd
party OLAP providers.
Analyze your Data
Highly interactive
Powerful charting options
Native online connectivity to OLAP sources
Multiple sources in one workspace
SAP NetWeaver BW and SAP HANA
Microsoft Analysis Services
SAP EPM providers
Other sources
Integrated with BI suite
Interoperability with Web Intelligence, Crystal
Reports, and other analysis clients
(18)18
© 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-infringement
Analysis Options
New options for the end-user
Define conditional formatting (aka
“exceptions”)
Define filter by measure
(aka“conditions”)
Define simple and dynamic
calculations
(19)Data Presentation – Charts
Chart types from shared CVOM library: Column (Clustered, Stacked, 100% Stacked, 3D Clustered), Line,
Pie, Bar (Clustered, Stacked, 100% Stacked), Scatter, Bubble, Radar, Box Plot
Interactivity – if a chart and a crosstab are linked to the same analysis, both components display the same
data and update simultaneously whenever you make changes to either component
Scope of Analysis – change window to focus on most important data in the chart
Scope of
Analysis
(20)20
© 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-infringement
What’s New for SAP BusinessObjects Voyager or SAP BEx
Web Analyzer Users
New user experience
Task panel
Layout panel
Sheets
Quick Access & Tabbed
toolbars
New data presentation
Positioning of members
Asymmetric drilling
Member reordering
Swap axes
New analytical capabilities
Sorting
Search
Conditional formatting
Calculations
Null and zero suppression
Multiple data sources
Deferred query (auto update)
New information sharing
Interoperability with SAP
BusinessObjects BI solutions
Export to Excel and PDF
(21)News in BI 4.0 Feature Pack 3 – 1 –
Compact Axis
Improvement to visual display of stacked dimensions
Forms a “hierarchy” out of existing stacked dimensions
Helps to simplify navigation on stacked dimensions with large data volumes
Enable compact
axis
Stacked
dimensions are
compacted
Drill down on
what you want
(22)22
© 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-infringement
News in BI 4.0 Feature Pack 3 – 2 –
Focused Analysis
New feature that displays what you want to see in a linked chart, based upon
selected cells in a cross-tab
Helps to easily visualize data that may not be clear or particularly visible
Selection will be
reflected in
sub-analysis
Enable focused
analysis
(23)News in BI 4.0 Feature Pack 3 – 3 –
Pivot With
New feature that is two separate features combined into one
Takes a member and drags it into a background filter, and at same time replaces
the dimension that member belongs to…with different dimension
(24)24
© 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-infringement
News in BI 4.0 Feature Pack 3 – 4 –
Display Attributes
(25)News in BI 4.0 Feature Pack 3 – 5 –
Further News
Additional Data Sources
SAP HANA
EPM (Planning and Consolidation, Profitability and Cost Management, Financial
Consolidation)
Performance optimizations for MS Analysis Services
(26)26
© 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-infringement
High-Level Functional Architecture
2 Modes to Deploy and Use the edition for MS Office
Edition for MS Office
Edition for OLAP
BW
MS Analysis
Services
BW
IE
Safari
Firefox
BI Platform
BI Platform
Client/Server
(27)Analysis, edition for OLAP – Prerequisites
Prerequisites
Browser: MS Internet Explorer 7 and 8, Firefox 3.5, Adobe Acrobat 8 and 9, and Safari 4 for
Apple Mac
.
SAP BusinessObjects BI platform 4.0
–
LCM, authentication, repository services
For SAP BW connectivity: SAP NetWeaver BW 7.0 SP 23 or higher or
SAP NetWeaver BW 7.0 EHP1 SP5 or higher
–
Recommendation: use SAP NetWeaver BW 7.3 as there are significant TCO and integration
improvements between BI platform and NetWeaver
–
Queries defined in SAP BEx Query Designer 3.5 (within SAP NetWeaver 7.0!) or 7.0+ ; also: direct
access to SAP BW InfoProvider and query views (no need to migrate queries or change data models)
For MSAS connectivity: MS Analysis Services 2005 SP1 and SP2; Microsoft Analysis
Services 2008
(28)28
© 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-infringement
Road Map for Enhanced Microsoft Analysis Services
(MSAS) Support
Major MSAS features already supported in first version of SAP BusinessObjects
Analysis, edition for OLAP. It fully takes advantage of the MSAS security model.
Planned support of following MSAS features in future SAP BusinessObjects
Analysis releases
Server-based named sets
Dimension attributes (within hierarchies)
Actions
KPIs
Drill-Through
*Please note: these are preliminary statements .
(29)Voyager and Analysis, edition for OLAP
With the release of Analysis, edition for OLAP, SAP BusinessObjects Voyager
enters a maintenance lifecycle and follows SAPs standard maintenance schedule.
While similar to Voyager, Analysis, edition for OLAP is a new product and some
features/functionality are different to Voyager. A white paper on the differences will
be published soon.
Voyager workspaces need to be converted to Analysis, edition for OLAP using the
new Upgrade Manager tool.
(30)(31)BI Launch Pad
Using of BEx Web Application Designer Templates in BO
Enterprise/InfoView in BI 4.0
Integration of SAP BEx Web
Application Java runtime into SAP
BusinessObjects BI platform
No additional SAP NetWeaver
J2EE stack required
BusinessObjects BI Platform
BI Consumer Services
SAP NetWeaver BW
BEx Queries /
InfoProviders
BEx Web
Templates
Adv. Analysis
(Web) Runtime
BEx Web
Runtime
BEx Web
Applications
BEx Web Application
Designer 7.x
(32)32
© 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-infringement
Integration into SAP NetWeaver Portal 7.0
Integration with Portal Integration Kit (PIK)
Document List Portlet displays complete BI launch pad (formerly InfoView)
Document Viewer iView displays all kind of single BI reports (including Analysis, Web edition).
Analysis, edition for MS Office workbooks must be open via Document List Portlet
Administration
Document Viewer iView allows creation of Portal Roles with specific, pre-defined reports
Document List Portlet allows instant
access to newly created ad hoc reports
Preferences
Users can change viewer type in their BI platform
preferences (e.g., thin vs. thick client for
Crystal Reports)
Security
Single Sign-On is supported by identity
propagation using SAP Logontickets
Single Sign-On ensures usage of analysis
authorization of SAP NetWeaver BW
(33)SAP Business Explorer (BEx)
Maintenance
BEx 7.0 continues to be delivered with the next SAP NetWeaver BW releases. At this point
in time, there‘s no planned end of life. The maintenance period is renewed with every major
BW release.
BEx 3.5 is part of BW 3.5/SAP NetWeaver 04 and the maintenance cycle is coupled to this
release (see SAP note 1410878). BEx 3.5 in BW 7.0x and BW 7.3x will be supported while
BEx 3.5 (NetWeaver 2004) is in extendend Maintenance (2013). Note that full PAM support
of BEx 3.5 cannot be granted by SAP – as Microsoft has removed, e.g., support for some
components within Windows 7 that had been used by BEx Web Application Designer 3.5.
Also see:
https://www.sdn.sap.com/irj/sdn/bex
Coexistence BEx Analyzer and Analysis, edition for MS Office
You can install BEx and Analysis on a single PC.
Only one add-in can be active in an Excel session (in other words, either BEx or Analysis
can be active)
(34)34
© 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-infringement
Tool vs Application
Tool
Application
Ad-hoc and self-service
Custom/specific OLAP analysis
End user empowerment
Planning application / guided
navigation
Full set of functionality
Selected set of functionality
De-centralized content creation
(IT-)centralized content creation
Analysis OLAP
Web Intelligence
Analysis
Application Design
(35)Thank You!
Contact information:
Alexander Peter
Director, Product Management
SAP AG
(36)36
© 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-infringement
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, POW ER6+, POW ER6, POW ER5+, POW ER5, POW ER,
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.
Oracle is a registered trademark of Oracle Corporation.
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.
Java is a registered trademark of Sun Microsystems, Inc.
JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for
technology invented and implemented by Netscape.
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.
© 2012 SAP AG. All rights reserved
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.
This document is a preliminary version and not subject to your license agreement or any
other agreement with SAP. This document contains only intended strategies, developments,
and functionalities of the SAP® product and is not intended to be binding upon SAP to any
particular course of business, product strategy, and/or development. Please note that this
document is subject to change and may be changed by SAP at any time without notice.
SAP assumes no responsibility for errors or omissions in this document. SAP does not
warrant the accuracy or completeness of the information, text, graphics, links, or other items
contained within this material. 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.
SAP shall have no liability for damages of any kind including without limitation direct,
special, indirect, or consequential damages that may result from the use of these materials.
This limitation shall not apply in cases of intent or gross negligence.
The statutory liability for personal injury and defective products is not affected. SAP has no
control over the information that you may access through the use of hot links contained in
these materials and does not endorse your use of third-party Web pages nor provide any
warranty whatsoever relating to third-party Web pages.