Analysis Office and EPM
Add-In - Convergence
Alexander Peter, SAP SE
© 2014 SAP SE or an SAP affiliate company. All rights reserved. Customer 3
Agenda
Overview
Convergence of Office Clients
© 2014 SAP SE or an SAP affiliate company. All rights reserved. Customer 5
Analytics Solutions from SAP
Planned Simplification of the SAP BI Client Portfolio
Reporting
Discovery and Analysis
Office Integration
Crystal Reports
Web Intelligence
Desktop Intelligence
Crystal Reports
Web Intelligence
Set Analysis
Lumira Desktop/Cloud/Server
Explorer
Analysis OLAP
Design Studio
Dashboards
Analysis Office
EPM Add-in
Lumira
Design Studio
Converged Office
Client
Inte
ro
p
e
ra
b
il
it
y
Convergence of Office Clients
Analytics in Microsoft Office
Today
BPC
(Planning)
SAP BW
SAP HANA
© 2014 SAP SE or an SAP affiliate company. All rights reserved. Customer 9
Analytics in Microsoft Office
Mid-Term
BPC
(Planning)
SAP BW
SAP HANA
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 and BPC
Embedded Model
Create live PowerPoint
© 2014 SAP SE or an SAP affiliate company. All rights reserved. Customer 11
SAP® EPM Solutions, Add-In for Microsoft Office
EPM 10.0 Applications Office Client
Mixing powerful and
dynamic cell-based
formulas and navigation
in a single mode
Cross data sources
reporting directly
performed on client side
Direct typing capability
Target User Groups:
Finance Business Users
Reports Copying/
Pasting between MS
Excel, Word and
Powerpoint
Dynamic formatting based on
Excel worksheet templates
Offline mode and
Strategy – Planning@SAP
Unified Planning
BPC Embedded (fka unified) Model
Combines traditional BW integrated planning with
flexible LOB scenarios
Unified Excel Client
© 2014 SAP SE or an SAP affiliate company. All rights reserved. Customer 17
Use Case Examples for Analysis Office
Interactive, analytic requirements
Switch hierarchies
Work with hierarchies and
hierarchical measures (including flat
member selector)
Variant support
Use Case Examples for EPM Add-In
Flexible Reporting
Asymmetric reports
Join data from different data sources
by axis sharing
Easy Formulas Input
Local members
Grouping & Sorting by Properties
Custom Members
Connectivity Standards Support
© 2014 SAP SE or an SAP affiliate company. All rights reserved. Customer 19
SAP Product Road Map for Converged Office Client
Key themes, capabilities, and planned innovations
Analysis Office & EPM Excel
client as separate clients
First Convergence Release:
•
Co-existence of both clients
in one workbook
•
Single installer, single license
•
Separate ribbon tabs for
Analysis and EPM usage
•
No shared entities (filter, report
definition)
•
First UX harmonization
•
Refresh
Continued Integration
•
Ribbon configuration
•
UX Harmonization
•
Open/Save
•
Undo
•
Settings
•
Common task pane
This is the current state of planning and may be changed by SAP at any time.
Planned Release: Q2 2015
© 2014 SAP SE or an SAP affiliate company. All rights reserved. Customer 21
Scheduling in Analysis Office 1.4 Feature Pack
Scenario and Features
Schedule reports for oneself or others (requires admin
authorizations)
Send email or to inbox
Formats: xlsx, xlsm
Filtering via authorization or exit variables
Prompt support available as of BI 4.1 SP5 and Analysis
Office 1.4 SP10
History panel available as of BI 4.1 SP5
Requirements
BI Platform 4.1 (at least one node on Microsoft Windows)
Analysis Office 1.4 Feature Pack – Add-On Installer on BI
Platform 4.1
Analysis,
edition for Microsoft Office
BI Platform
Central Management Console
Precalculation Server
(on Windows node)
Schedule
Send to email
or inbox
News in Release 2.0
Architecture
Ready for convergence with EPM Add-In
New Settings Framework
Table Design
Flexible crosstab handling – still interactive crosstab
Add empty lines for structuring reports & highlight specific cells
Enhanced Design Panel – Property View
Set properties for one or several measures or dimensions
New HANA Access
http access replaces ODBC/JDBC access (requires HANA SP9)
Continuous Improvements
© 2014 SAP SE or an SAP affiliate company. All rights reserved. Customer 23
SAP Product Road Map for Analysis, edition for MS Office
Key themes, capabilities, and planned innovations
Highly interactive multidimensional analysis on
SAP sources (BW & HANA)
MS PowerPoint Publishing
Excel-based application design via powerful API
Analysis Excel write-back on BW-IP (integrated
planning) and BPC embedded model
Combine local and corporate data (via BW
Workspaces)
Conversion support for BEx workbooks
Transformation into web and mobile apps (via
Design Studio)
Scheduling on BIP
Table Design
Common client for Analysis Office and
EPM Add-In
Formula Editor (BW and HANA)
Restricted Measures in HANA
Table Design Enhancements ( Style
Handling, API)
Precalculation 2.x
Continuous Improvements
Message Handling (hiding messages, adding
messages to end users)
Log On/Off API (e.g. for reading new master
data)
System remapping (local and BIP
connections)
Further Convergence with EPM
Add-In
HANA Platform
Continuous Improvements
Comments
Enhanced PowerPoint support
Enhanced Table Design
This is the current state of planning and may be changed by SAP at any time.
Planned Release: Q2 2015
SAP BusinessObjects Analysis, Edition for Microsoft Office
Prerequisites
Client Prerequisites
MS Office 2007, MS Office 2010 or MS Office 2013 (on MS Windows Vista and higher)
SAP GUI installation not required
–
But local SAPLOGON.INI file required if you don‘t use BI Platform for connection management
Server Prerequisites
SAP NetWeaver BW 7.0 or higher
–
Recommendation: use BW 7.0 EHP1 or SAP NetWeaver BW 7.3 as there are significant TCO and 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: direct access to SAP NetWeaver BW
InfoProvider and query views
o
No need to migrate queries, no change in BW data models necessary
o
The SAP BEx Query Designer stays as it is and can continues to be the semantic modeling level for SAP NetWeaver BW data.
–
Some new features might require patching your BW system
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
