bi102 title of the presentation this is the subtitle · presentation and sap's strategy and...

22
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.

Upload: others

Post on 21-Apr-2020

2 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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.

Page 2: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 3: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 4: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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)

Page 5: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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)

Page 6: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 7: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 8: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 9: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 10: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 11: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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.

Page 12: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 13: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 14: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 15: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 16: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 17: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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.

Page 18: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 19: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 20: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 21: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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

Page 22: BI102 Title of the Presentation This Is the Subtitle · presentation and SAP's strategy and possible future developments are subject to change and may be changed by SAP at any time

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