bi102 title of the presentation this is the subtitle · presentation and sap's strategy and...
TRANSCRIPT
1
BI102
SAP BusinessObjects (Advanced)
Analysis
Overview
Alexander Peter
Director Product Management Analysis Clients
October 2010
© 2010 SAP AG. All rights reserved. / Page 2
Disclaimer
This presentation outlines our general product direction and should not be relied on in making a
purchase decision. This presentation is not subject to your license agreement or any other
agreement with SAP. SAP has no obligation to pursue any course of business outlined in this
presentation or to develop or release any functionality mentioned in this presentation. 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. SAP
assumes no responsibility for errors or omissions in this document, except if such damages
were caused by SAP intentionally or grossly negligent.
2
© 2010 SAP AG. All rights reserved. / Page 3
Agenda
1. Overview & Roadmap for Analysis Clients
2. Product Details: SAP BusinessObjectsAnalysis, Edition for Microsoft
Office
3. Product Details: SAP BusinessObjectsAnalysis, Edition for OLAP
4. Appendix
© 2010 SAP AG. All rights reserved. / Page 4
Analysis
BEx WAD
Web Intelligence
Explorer
The Right Tool For The Job
Providing best fit solutions across the range of BI requirements
Crystal Reports
Full
Dashboards(fka
Xcelsius)
DataExploration
Advanced Analysis
InteractiveAnalysis
Dashboards & VisualizationReporting
Interactive Experience, ResponsivenessLimited
Professionally
Informed
Technically
Capable
Information
Consumer
Executives,
Managers
Business
Analysts
PredictiveWorkbench
3
© 2010 SAP AG. All rights reserved. / Page 5
Analysis
BEx WAD
Web Intelligence
Explorer
The Right Tool For The Job
Providing best fit solutions across the range of BI requirements
Crystal Reports
Full
Dashboards(fka
Xcelsius)
DataExploration
Advanced Analysis
InteractiveAnalysis
Dashboards & VisualizationReporting
Interactive Experience, ResponsivenessLimited
Professionally
Informed
Technically
Capable
Information
Consumer
Executives,
Managers
Business
Analysts
PredictiveWorkbench
SAP Business Objects
Analysis Clients
© 2010 SAP AG. All rights reserved. / Page 6
Step 1 (BI 4.0): SAP BusinessObjects Analysis
Clients for SAP BW
Analysis, edition for MS Office
Covers all of the above directly within MS Office Excel & PowerPoint
We
bM
S O
ffic
e
Analy
sis
Clie
nts
BEx WAD Explorer
Instant ExplorationCustom Analytic &
Planning Apps
Explorational (OLAP)
Analysis
Self-Service Reporting &
Analysis
Analysis, edition
for OLAP
Web Intelligence
IT / Developer for Task
workers
Technical expertise (design), business domain
expertise (consumer)
Purpose-built BW-based
apps for routine analytic & planning scenarios
BEx WAD runtime
integrated into BI platform, Publishing into InfoView
Data Analyst(s)
Analytical expertise
Analytical question can be immediately pursued
Optimized for highly
interactive analysis
Limited layouting & formatting
Business Users
(Limited) technical
expertise (report designers), business
domain expertise (consumer / prosumer)
Interactive report creation
Flexible formatted reports with built-in analysis
features
Search and navigation tool
for casual users to access business data
No training required
Ability to search, explore and visualize massive data
volumes via BWA
Smart visualization capabilities
4
© 2010 SAP AG. All rights reserved. / Page 7
Roadmap (BI 4.x): SAP BusinessObjects
Analysis Clients for SAP BW W
eb
MS
Off
ice
Analy
sis
Clie
nts
Analytical
Application
Development Kit
Explorer
Instant ExplorationCustom Analytic &
Planning Apps
Explorational (OLAP)
Analysis
Self-Service Reporting &
Analysis
One merged product:
Web Intelligence & Analysis, edition for OLAP
Allows IT and developers
to create purpose-built applications on top of BW
Technical expertise
Integrates Planning and analytic workflows
Built as Eclipse Plug-In, fully integrated with BI
platform
One Client for Data Analysts and
interactive report designers
Optimized & Integrated UIs and workflows to seamlessly move from
advanced analysis into report creation and publishing
Analysis, edition for MS Office
Covers all of the above directly within MS Office Excel & PowerPoint
Search and navigation tool
for casual users to access business data
Ability to search, explore
and visualize massive data volumes via BWA
No training required
Smart visualization capabilities
© 2010 SAP AG. All rights reserved. / Page 8
Analysis client strategy for BW
BI 4.0: SAP BusinessObjects Analysis, edition for OLAP
Stand-alone OLAP web client for Business Analysts (sources: BW & MSAS)
Mid-term : Merge Web Intelligence & Analysis, edition for OLAP
One Analysis client for Business Users: Analysis, edition for OLAP and Web Intelligence will be
merged to offer a harmonized user experience
Interactive reporting and multi-dimensional OLAP analysis in one single tool
Protect your Investments
Advanced Analysis Web and Voyager workspaces can be imported into merged product
For BW IT & Power Users: Additional investment into an Analytical Application Development
Kit (premium alternative to BEx WAD for OLAP & planning application design)
5
© 2010 SAP AG. All rights reserved. / Page 9
Roadmap & Timeline for SAP BusinessObjects
Analysis and Web Intelligence
BI 4.0 BI 4.X 2012
Analysis, edition
for OLAP
Web Intelligence
Analytical
Application
Development Kit
Te
chnic
al U
se
rB
usin
ess U
se
rs &
Analy
sts
OLAP analysis
only client for
immediate use
First set of
integrated
OLAP features
Import Analysis
workspaces based on BW
as blueprint for an
analytical app
One client for OLAP
analysis and interactive
reporting
Eclipse Plug-In to
build custom BI &
planning apps
Relational and
OLAP sources
MSAS & BW
BW only
© 2010 SAP AG. All rights reserved. / Page 10
Semantic Layer
(next generation)
Web IntelligenceCrystal ReportsAnalysis,
edition for MS OfficeAnalysis,
edition for OLAP
Interoperability Between Analysis and Other Clients
in 2010 based on BI 4.0
Analysis state is captured in a query object called analysis view that is shared between products in the SAP
BusinessObjects suite (similar for the BEx query view in the BEx Suite)
The analysis view captures the view on the data including filters and other features – it is stored in BI platform
SAP BusinessObjects Analysis can create and consume the analysis view, The first clients who are able to
consume it are Crystal Reports & Web Intelligence. Each tool interprets the analysis view in a way that is
consistent with its native environment
Shared Query
(Analysis View)
Create / consume
Create / consume
BICS Component
Create / consume
Create / consume
Interoperability
(Consume through
transient universe)
6
© 2010 SAP AG. All rights reserved. / Page 11
Agenda
1. Overview & Roadmap for Analysis Clients
2. Product Details: SAP BusinessObjects Analysis, Edition for
Microsoft Office
3. Product Details: SAP BusinessObjectsAnalysis, Edition for OLAP
4. Appendix
© 2010 SAP AG. All rights reserved. / Page 12
SAP BusinessObjects Analysis
SAP BusinessObjects Analysis, edition for Microsoft Office
MS Office Add-Ins that allow ad hoc multidimensional analysis of OLAP sources in MS Excel,
intuitive creation of BI presentations with MS PowerPoint as well as Excel workbook-based
application design.
SAP BusinessObjects Analysis, edition for Microsoft Office will evolve into a fully-fledged
productivity suite for MS Office by converging with SAP BusinessObjects Live Office
Premium Alternative to SAP BEx Analyzer
7
© 2010 SAP AG. All rights reserved. / Page 13
Step 1 (BI 4.0): SAP BusinessObjects Analysis
Clients for SAP BW
Analysis, edition for MS Office
Covers all of the above directly within MS Office Excel & PowerPoint
We
bM
S O
ffic
e
Analy
sis
Clie
nts
BEx WAD Explorer
Instant ExplorationCustom Analytic &
Planning Apps
Explorational (OLAP)
Analysis
Self-Service Reporting &
Analysis
Analysis, edition
for OLAP
Web Intelligence
IT / Developer for Task
workers
Technical expertise (design), business domain
expertise (consumer)
Purpose-built BW-based
apps for routine analytic & planning scenarios
BEx WAD runtime
integrated into BI platform, Publishing into InfoView
Data Analyst(s)
Analytical expertise
Analytical question can be immediately pursued
Optimized for highly
interactive analysis
Limited layouting & formatting
Business Users
(Limited) technical
expertise (report designers), business
domain expertise (consumer / prosumer)
Interactive report creation
Flexible formatted reports with built-in analysis
features
Search and navigation tool
for casual users to access business data
No training required
Ability to search, explore and visualize massive data
volumes via BWA
Smart visualization capabilities
© 2010 SAP AG. All rights reserved. / Page 14
Use Cases for Analysis, edition for MS Office
Business User &
Task Worker
Power User / IT Business Analyst
Power User Tools Easy BI consumption
Consuming BI
Content
ExplorationConsuming
Dashboards
Active/static
Report
Consumption
Advanced
Analysis
Building Content
(Dashboards, Reports,
workspaces)
Interactive
Analysis
CR XCE AA Web WebI WebI/CR XCE Explorer
Analysis, edition for MS Office
Web
MS
Off
ice
Building MS Office
Content in Excel & PPt
Ad hoc Data Analysis
in Excel
Centralized creation of Analysis content (workbooks & PowerPoints)
Sophisticated workbook design (VBA APIs and so on)
Ad Hoc data access and data analysis, slicing & dicing, and so on, in Excel
Ad Hoc embedding of BI data into PowerPoint presentations
Consuming pre-defined BI content in Microsoft Excel and Microsoft PowerPoint
Note: the bigger the orange share, the more suitable the tool for the user segment
8
© 2010 SAP AG. All rights reserved. / Page 15
Preliminary Roadmap – SAP BusinessObjects
Analysis, Edition for Microsoft Office
This presentati on 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.
2010
2011+
INNOVATE ANALYSIS
Highly interactive multidimensional
analysis
Best integration into SAP NetWeaver BW
Best-in-class usability
MS PowerPoint Publishing
MS Excel Formula mode (online access to
data and metadata via Excel formulas)
Excel-based application design
Support of next-generation SAP
NetWeaver BW Accelerator
EXTEND THE REACH
Analysis Excel write-back enabled on
BW-IP (integrated planning)
BusinessObjects BI platform
services (publishing, personalization,
report-report interface, BW
documents)
Support of further sources via new
semantic layer: MSAS, Essbase, etc.
© 2010 SAP AG. All rights reserved. / Page 16
Analysis, Edition for MS Office
MS Excel Add-In with Query Panel
9
© 2010 SAP AG. All rights reserved. / Page 17
Analysis, Edition for MS Office
MS PowerPoint Add-In
© 2010 SAP AG. All rights reserved. / Page 18
Analysis, Edition for MS Office
Design Panel
New Design Panel for easy navigation
Views
Analysis: Allows navigation, filtering, and so on
Information:
General information on the embedded data source or the
workbook itself (i.e. last data refresh, created by, and so on)
All relevant information (filters, variables, and so on) at one
glance, in one place
Components: Structural information view either from
the data source or the worksheet perspective
Navigation
Simplified drag&drop within panel or into grid to filter, drill-
down, slice&dice, replace, and so on
Finger-tip access to hierarchies
Access to display attributes
10
© 2010 SAP AG. All rights reserved. / Page 19
Analysis, Edition for MS Office
Advanced Analysis
New options for the end-user
Define conditional formatting (formerly ―exceptions‖)
Define filter by measure (formerly ―conditions‖)
Define easy calculations and dynamic calculations
Excel commentary on data cells
New hierarchy features
Collapse into hierarchical structures (―display hierarchy‖)
Show/hide hierarchy levels
Sort breaking hierarchies
© 2010 SAP AG. All rights reserved. / Page 20
Analysis, Edition for MS Office
Easy Application Building
Workbook Design
Easy insertion of multiple data source
(from multiple systems)
Improved overview of BW elements in an
Excel workbook
Free formatting of text elements (cells with
meta data retrieval formulas)
New APIs as Excel formulas
Add Excel-based charts
Easy consumption of Workbooks created
by Analysis, edition for MS Office
Add information on the data sources
(name, last update, and so on
Add information on the filter status
Integrate filter dialog
Sharing Workbooks/PowerPoint files
Save workbook/ppt presentation in
BusinessObjects Enterprise
11
© 2010 SAP AG. All rights reserved. / Page 21
Analysis, Edition for MS Office : High Level
Architecture
Direct BW Connectivity via BI Consumer
Services
Connection management via BI platform
(optional)
BI platform repository services for
workbooks and PowerPoint filesAnalysis,
edition for Microsoft Office
BusinessObjects BI
Platform
Repository/
InfoView
SAP Sources
SAP NetWeaver BW 7.x(BEx Queries, views,
InfoProviders)
SAP NetWeaver BW
Accelerator
BI Consumer Services
Connections
© 2010 SAP AG. All rights reserved. / Page 22
SAP BusinessObjects Analysis, Edition for
Microsoft Office 1.0 – Prerequisites
Prerequisites
MS 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 2010
SAP NetWeaver BW 7.0 or higher**
– Recommendation: use BW 7.0 EHP1 or even 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
– No need to migrate queries, no change in BW data models necessary
– The SAP BEx Query Designer stays as it is and can continues to be the semantic modeling level for
SAP NetWeaver BW data.
SAP Business Objects Enterprise (BOE) XI 3.1 (can run side-by side with SAP NetWeaver
BW)
– See next slide for information about platform capabilities
Client Sizing: See SAP note 1466118
** Requirements may be higher for other clients
*Please note: these are preliminary statements .
The statements remain to be finalized once Analysis, edition for MS Office becomes available.
12
© 2010 SAP AG. All rights reserved. / Page 23
Analysis, Edition for MS Office – Platform
Capabilities and Roadmap
BI platform (fka BO Enterprise) is strategic for all SAP BusinessObjects Clients
Analysis 1.0 on SAP BusinessObjects Enterprise XI 3.1
– Central provisioning of BW connections
– Client-side Single-Sign On
– Saving and sharing workbooks centrally (common xls / ppt InfoObject)
Analysis 1.1 (planned) on BI platform 4.0 (as of begin of ramp-up for BI 4.0)
– Support system-type connection
– Server-side and client-side Single-Sign On
– Saving and sharing workbooks centrally (common xls(x) / ppt(x) InfoObject)
– Lifecycle Management
– Interoperability with other clients: Web Intelligence, Crystal Reports and SAP
BusinessObjects Analysis, edition for OLAP based on Analysis View
Although technically possible and good for testing purposes direct operation of the Office
Add-In on BW without BI platform is not recommended for productive usage (main
services like central repository, interoperabilty, and so on are not supported)
*Please note: these are preliminary statements .
The statements remain to be finalized once Analysis, edition for MS Office becomes available.
© 2010 SAP AG. All rights reserved. / Page 24
Agenda
1. Overview & Roadmap for Analysis Clients
2. Product Details: SAP BusinessObjectsAnalysis, Edition for Microsoft
Office
3. Product Details: SAP BusinessObjects Analysis, Edition for OLAP
4. Appendix
13
© 2010 SAP AG. All rights reserved. / Page 25
SAP BusinessObjects Analysis, Edition for
OLAP
SAP BusinessObjects Analysis, edition for OLAP
As premium web-based OLAP analysis client for business analysts to run ad hoc OLAP
analyses, and create OLAP workspaces for private usage or sharing with others
SAP BusinessObjects Analysis, edition for OLAP completes SAP BusinessObjects‘ client
portfolio in the area of OLAP analysis and interoperates with offerings such as Web
Intelligence & Crystal Reports
The mid-term plan is to bring Web Intelligence and Analysis, edition for OLAP together into
one harmonized user experience
Successor of SAP BusinessObjects Voyager
© 2010 SAP AG. All rights reserved. / Page 26
Step 1 (BI 4.0): SAP BusinessObjects Analysis
Clients for SAP BW
Analysis, edition for MS Office
Covers all of the above directly within MS Office Excel & PowerPoint
We
bM
S O
ffic
e
Analy
sis
Clie
nts
BEx WAD Explorer
Instant ExplorationCustom Analytic &
Planning Apps
Explorational (OLAP)
Analysis
Self-Service Reporting &
Analysis
Analysis, edition
for OLAP
Web Intelligence
IT / Developer for Task
workers
Technical expertise (design), business domain
expertise (consumer)
Purpose-built BW-based
apps for routine analytic & planning scenarios
BEx WAD runtime
integrated into BI platform, Publishing into InfoView
Data Analyst(s)
Analytical expertise
Analytical question can be immediately pursued
Optimized for highly
interactive analysis
Limited layouting & formatting
Business Users
(Limited) technical
expertise (report designers), business
domain expertise (consumer / prosumer)
Interactive report creation
Flexible formatted reports with built-in analysis
features
Search and navigation tool
for casual users to access business data
No training required
Ability to search, explore and visualize massive data
volumes via BWA
Smart visualization capabilities
14
© 2010 SAP AG. All rights reserved. / Page 27
Power User Analysis Tools
Use Cases for Analysis, Edition for OLAP
within the family of analysis products
Building MS Office
ContentAdvanced Analysis
Consuming BI
Content, eg. WebI, CR
MS
Off
ice
Ad Hoc OLAP
Analysis
Creation of re-usable Advanced Analysis workspaces
Not necessarily an expert for sophisticated BI Application Design
Ad Hoc data access and data analysis, slicing & dicing
Creation of Advanced Analysis workspaces for personal use
Can use pre-defined Web workspaces
Need to operate between Advanced Analysis and more BI consumer tools like Web Intelligence or Explorer
Note: the bigger the orange share, the more suitable the tool for the user segment
Pre-Built and Explorational Analysis
Exploration
Using OLAP &
Planning Apps
on BW
Active
Consumption of
Interactive reports
Building OLAP &
Planning Apps on BW
Interactive
Reports &
Analysis
BEx WAD Analysis4OLAP WebI WebI BEx WAD Explorer
Web
Business User &
Task Worker
Power User / IT Business Analyst
© 2010 SAP AG. All rights reserved. / Page 28
Preliminary Roadmap – SAP BusinessObjects
Analysis, Edition for OLAP
This presentati on 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.
2010
2011/2012+
INNOVATE ANALYSIS
Highly interactive OLAP analysis
Analysis directly on top of BW
InfoPoviders (Query Views, Queries,
Cubes, DSO …)
MSAS Support & Migration from
Voyager
Interoperability with Web Intelligence
and Crystal Reports
Publishing of SAP BEx Web Application
Designer applications into InfoView
SIMPLIFY PRODUCT PORTFOLIO AND
EXTEND THE REACH
Bring Web Intelligence and Analysis,
edition for OLAP together into one
harmonized user experience
Dedicated Analytic Application Design
Kit custom apps on BW
15
© 2010 SAP AG. All rights reserved. / Page 29
Analysis, Edition for OLAP – Workspace with
BW and MSAS Components
© 2010 SAP AG. All rights reserved. / Page 30
Analysis, Edition for OLAP
Advanced Analysis
New options for the end-user
Define conditional formatting (formerly ―exceptions‖)
Define filter by measure (formerly ―conditions‖)
Define simple and dynamic calculations
Create custom calculations
16
© 2010 SAP AG. All rights reserved. / Page 31
Analysis, Edition for OLAP:
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
© 2010 SAP AG. All rights reserved. / Page 32
Analysis, Edition for OLAP
High Level Architecture
Analysis, edition for OLAP leverages
BI platform services (LCM,
persistency, authentication, and so
on) and cannot be used without BI
platform
Server component for Analysis,
edition for OLAP can be optionally
installed on
NW J2EE 7.1 or on
Any J2EE supported by BI platform
Analysis workspaces & analysis
views stored in BI platform repository
Analysis, edition for OLAP
AJAX/ HTTP
Application Server
Any J2EE supported by BI platform
(e.g., SAP NetWeaver)
BusinessObjects BI Platform
OLAP Data Access & Drivers
BI Consumer Services
SAP Sources
SAP NetWeaver BW 7.x(BEx Queries, views,
InfoProviders)
SAP NetWeaver BW
Accelerator
3rd Party OLAP Sources
e.g., MS Analysis
Server
17
© 2010 SAP AG. All rights reserved. / Page 33
SAP BusinessObjects 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
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
** Aurora program requirements may be higher for other clients
*Please note: these are preliminary statements .
The statements remain to be finalized once Analysis, edition for OLAP becomes available.
© 2010 SAP AG. All rights reserved. / Page 34
Roadmap for Enhanced Microsoft Analysis
Services (MSAS) Support
Major MSAS features already supported in first version of SAP BusinessObjects Analysis,
edition for OLAP.
Planned support of following MSAS features in the harmonized SAP BusinessObjects
Analysis & Web Intelligence product
Server-based named sets
Dimension attributes (within hierarchies)
Actions
KPIs
Drill-Through (available in Voyager)
*Please note: these are preliminary statements .
The statements remain to be finalized once Analysis, edition for OLAP becomes available.
18
© 2010 SAP AG. All rights reserved. / Page 35
Developing OLAP and Planning Applications
on BW
What tool does SAP recommend for developing Analytic and Planning
Applications on BW?
Dashboards & Enterprise Reporting
For building highly formatted reports or state-of-the-art dashboards and visualizations that do
NOT require in-depth BW OLAP or BW-IP (planning) capabilities Crystal Enterprise and
Xcelsius are the tools of choice
BW-specific OLAP & Planning Apps
Short-term: SAP BEx Web Application Designer
Advanced Analytic Application Design and web-based planning apps via WAD in 2010
Less complex analytic scenarios via pre-defined AA Web workspaces
Mid-term: Analytical Application Development Kit
Eclipse-based OLAP & Planning apps
Integration with Xcelsius visualization capabilities
© 2010 SAP AG. All rights reserved. / Page 36
Preliminary Roadmap – Analytical Application
Development Kit
This presentati on 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.
2011
2012+
INNOVATE APPLICATION DEVELOPMENT
Build App from scratch or based on existing
Analysis web workspace
BW-Integrated Planning application
building – wave 1 features
BW OLAP application building – wave 1
features
Based on SAP Business Objects
Enterprise Platform
Eclipse plug-in as infrastructure
EXTEND APPLICATION
DEVELOPMENT
BW-Integrated Planning application
building – wave 2 features
BW OLAP application building –
wave 2 features
Integration with Xcelsius visualization
Importing Analysis Office workbooks
as blueprint for application building
19
© 2010 SAP AG. All rights reserved. / Page 37
Preview 2011: Analytic Application Development
Kit in Eclipse – OLAP & Planning apps on BW
© 2010 SAP AG. All rights reserved. / Page 38
Agenda
1. Overview & Roadmap for Analysis Clients
2. Product Details: SAP BusinessObjectsAnalysis, Edition for Microsoft
Office
3. Product Details: SAP BusinessObjectsAnalysis, Edition for OLAP
4. Appendix
20
© 2010 SAP AG. All rights reserved. / Page 39
InfoView
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
© 2010 SAP AG. All rights reserved. / Page 40
Integration into SAP NetWeaver Portal
Integration of SAP BusinessObjects BI platform 4.0 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
21
© 2010 SAP AG. All rights reserved. / Page 41
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). As BEx 3.5 is also compatible with a BW 7.0
backend and had been delivered with BW 7.0, SAP will maintain BEx 3.5 functionality
within BW 7.0 and subsequent releases until the end of BW 7.0 maintenance cycle.
Maintenance is NOT extended with BW 7.30 or other future releases. 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)
Opening a BEx workbook activates the BEx add-in.
© 2010 SAP AG. All rights reserved. / Page 42
Further Information
SAP Public Web:
SAP Developer Network (SDN): http://www.sdn.sap.com/irj/boc/advanced-
analysis
Business Process Expert (BPX) Community: www.bpx.sap.com
SAP BusinessObjects Community (BOC): boc.sap.com
Related SAP Education and Certification Opportunities
http://www.sap.com/education/
Related Workshops/Lectures at SAP TechEd 2010
BI102: SAP BusinessObjects Advanced Analysis: Overview, Lecture
BI260: SAP BusinessObjects Advanced Analysis, edition for Microsoft Office,
Hands-On
BI360: Technical Deep-Dive into SAP BusinessObjects Advanced Analysis,
edition for Microsoft Office, Hands-On
22
ContactFeedback
Please complete your session evaluation.
Be courteous — deposit your trash,
and do not take the handouts for the following session.
© 2010 SAP AG. All rights reserved. / Page 44
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.
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 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. in the United States and in other countries.
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.
© 2010 SAP AG. All Rights Reserved