SAP-COMERIT_BOBJ_for_2009_v4

Werbung
What to Do With BOBJ in 2009
Tanner Spaulding, SAP Labs
Dr. Bjarne Berg, COMERIT
The Business Intelligence Experts
Introductions
You can request a copy of today’s presentation
by sending an email request to
[email protected]
The Business Intelligence Experts
2
Agenda
The SAP BOBJ Roadmap
Current development status by tool
Software rampup plans
Training plans
What can be done now
What are others doing
Key points take away
Questions and Answers
The Business Intelligence Experts
3
Product Directions for BI Solutions
Richest Offering for All Business Users
And Much
More…
Dashboards,
Visualization
Web App Designer
Xcelsius
Polestar
Enterprise
Reporting
Report Designer
Crystal Reports
Ad-hoc
Query &
Reporting
BI Widgets
Web Intelligence
Advanced
Analysis
Mobile BI
SAP BEx Analyzer
Voyager
Predictive
Enterprise Data
Warehousing
& BI Platform
Web Services
SAP NetWeaver BW and BWA
© SAP 2008 / Page 4
BusinessObjects Enterprise
Product Directions for BI Solutions
SAP BusinessObjects BI Solutions
And Much
More…
Dashboards,
Visualization
Web App Designer
Xcelsius
Polestar
Enterprise
Reporting
Report Designer
Crystal Reports
Ad-hoc
Query &
Reporting
BI Widgets
Web Intelligence
Advanced
Analysis
Mobile BI
Pioneer (OLAP Analysis)
Predictive
Enterprise Data
Warehousing
& BI Platform
Web Services
SAP NetWeaver BW and BWA
© SAP 2008 / Page 5
BusinessObjects Enterprise
How Business Objects Tools Expand the
Scope of BI
Pioneer
Web
Intelligence
Xcelsius
Advanced
Analytics
Crystal
DashDashboards
boards
Enterprise
Enterprise
Reporting
Reporting
Ad-hoc
Reporting
Polestar
Ad-hoc BI
Search
Functional Scope of the SAP
BusinessObjects Tools Suite
© SAP 2009 / 6
How Business Objects Tools Expand the
Scope of BI
Pioneer
Xcelsius
Web
Intelligence
Polestar
Crystal
Dashboards
Fast BI Search for
Polestar
masses
of casual users
Enterprise
Reporting
Each tool in the suite has its specific strengths and is tailored
to a specific purpose . Which tools and combinations to use
depends on customer needs & strategy
© SAP 2009 / 7
How Business Objects Tools Expand the
Scope of BI
Pioneer
Xcelsius
Crystal
Dashboards
WebIntelligence
Web
AdHoc Reporting
for
Intelligence
Business
users
- Adhoc report design
- Merge personal & corporate data
- Same online & Offline
experience
Polestar
Enterprise
Reporting
Each tool in the suite has its specific strengths and is tailored
to a specific purpose . Which tools and combinations to use
depends on customer needs & strategy
© SAP 2009 / 8
How Business Objects Tools Expand the
Scope of BI
Pioneer
Pioneer
Advanced Analytics for
Business Analysts
Xcelsius
Crystal
Web
Intelligence
- AdHoc OLAP
- Packaged OLAP Content
Dashboards
Polestar
Enterprise
Reporting
Each tool in the suite has its specific strengths and is tailored
to a specific purpose . Which tools and combinations to use
depends on customer needs & strategy
© SAP 2009 / 9
How Business Objects Tools Expand the
Scope of BI
Xcelsius
Pioneer
Dashboards for
information consumers
Xcelsius
- Packaged BI dashboards
- Dashboard design for
professional users
Crystal
Dashboards
Web
Intelligence
Polestar
Enterprise
Reporting
Each tool in the suite has its specific strengths and is tailored
to a specific purpose . Which tools and combinations to use
depends on customer needs & strategy
© SAP 2009 / 10
How Business Objects Tools Expand the
Scope of BI
Pioneer
Xcelsius
Web
Intelligence
Crystal
Packaged formatted
Dashreports for the entire
boards
Crystal
enterprise
-- easy to consume Enterprise
-- pixel exact & print optimized
Reporting
Polestar
Each tool in the suite has its specific strengths and is tailored
to a specific purpose . Which tools and combinations to use
depends on customer needs & strategy
© SAP 2009 / 11
Agenda
The SAP BOBJ Roadmap
Current development status by tool
Software rampup plans
Training plans
What can be done now
What are others doing
Key points take away
Questions and Answers
The Business Intelligence Experts
12
Overview:
Options for Universe-Based Access to BW 7.0
Xcelsius
WebI
QT
QaaWS
Universes
SQL Access
MDX Access
Data Federator
RDBMS
© SAP 2009 / 13
ODA
XMLA
BW
BIA
OLAP BAPI
Analytic Engine
ODBO
Overview:
Options for Universe-Based Access to BW 7.01
Xcelsius
WebI
QT
QaaWS
Universes
SQL Access
MDX Access
Data Federator
RDBMS
BW
XMLA
DF Fascade
OLAP BAPI
Analytic Engine
BWA
changes and additions in red
© SAP 2009 / 14
ODA
ODBO
Comparison
BW Server Feature
MDX
BW Hierarchies

Restricted and Calculated Key Figures

Security

BW Variables

Currency and Unit Conversion

Exceptions, Conditions

SUM, MIN, MAX Aggregations


AVG, COUNT, COUNT DISTINCT, … Aggregations


OLAP Cache

Navigational Attributes


Mass Data Enabled


Federation (e.g. BW – RDBMS, BW – BW)
 = fully supported
 = limited support / workaround
© SAP 2007 / Page 15
SQL


WebI – BW Interoperability via ODA (MDX)
Architectural Overview
Adapt MDX
and Flattening
to new Format
ODA
Optimization of
the exchange
protocoal
(binary XML)
and format
(rowsets;
internal API)
RFC
Dataset
BAPIs
Rowset
APIs
Metadata
BAPIs
Query execution controller
Parser
Execution
instance
Function
library
MDX engine
Analytic Engine
BIA or RDBMS
© SAP 2007 / Page 16
Optimization
of memory
consumption
Implementation
of Unorder()
function for
optimizing Sorting
WebI – BW Interoperability via ODA (MDX)
Details
Improvements
1. Avoid unnecessary sorting
 MDX standard imposes results to be sorted
 However, those sorts are typically ignored or not required by WebI
 sorting can be avoided by using a new UNORDER() function in SAP's MDX
2. Leaner memory consumption during flattening
 optimized flattening algorithm
 non-standard result structure
3. Leaner communication ODA – OLAP BAPI
 use compressed data exchange via binary XML
Availability


SAP NetWeaver BW 7.01 SP 3
Business Objects Enterprise XI3.0/XI3.1
 XI3.0 :Fix Pack 2 w/ LAFix2.1
 XI3.1 :Fix Pack 1.2
 SAP Integration Kit Fix Pack 2 w/LAFix2.1
© SAP 2007 / Page 17
Advanced OLAP Analysis
Product Integration Roadmap
STANDARD
PREMIUM
2008
OLAP
Analysis
Voyager
2009
Voyager
2010
Pioneer
BEx Web Analyzer
BEx Web Analyzer
BEx Web Analyzer
BEx Analyzer (Excel)
BEx Analyzer (Excel)
BEx Analyzer (Excel)
BEx Web App Designer*
BEx Web App Designer*
BEx Web App Designer*
Pioneer (code name for 2010 release) provides a superset of capabilities from
SAP Business Explorer (BEx) Analyzer (Excel), SAP BEx Analyzer (Web), and
SAP BusinessObjects Voyager
Migration from Voyager workspaces to Pioneer Web and from BEx Analyzer
workbooks to Pioneer Office
*Embedding of web apps built with BEx Web Application Designer into Pioneer
Web by 2010 with a later migration to the Pioneer Design SDK
© SAP 2008 / Page 18
Option for BW Customers: Embedding BEx Web
Templates with Long-Term Migration Strategy
future
planned 2010
InfoView /SAP NetWeaver Portal
InfoView /SAP NetWeaver Portal
Pioneer Web Client
Pioneer Web Client
Workspace
Workspace
PIO Web
Tab
BEx Web
Tab
…
PIO Web
Tab
BEx Web
Tab
…
SAP BOE
Platform
SAP BOE
Platform
Pioneer Designer/ SDK
Pioneer Web
Server
Pioneer Web Server
BI Consumer Services
BI Consumer Services
BEx Queries/
InfoProviders
BEx Web
Templates
SAP NetWeaver BW
© SAP 2007 / Page 19
BEx Web
App
Designer
BEx Queries/
InfoProviders
SAP NW BW
Migration
BEx Web
BEx Web
App
options via
Templates
Pioneer Designer
SDK
What Is Polestar? It’s Search Against BI…
Use familiar key-word search
to find business information
Answers “on-the-fly” and
investigative questions
Searches directly on
pre-indexed data
No previous reports or metrics
need exist
Provides fast search and
exploration
Searches across all data
sources
Any universe accessible
source
Any BW Accelerator accessible
source
Note: BI Accelerator is now called BW Accelerator
© SAP 2008 / Page 20
…and Then It’s Exploration Of the Results
Intuitively explore on
data
No data model or data
knowledge required
Automated relevancy
of results
Most relevant
information is displayed
first
Best chart type auto
generated
Share insights with others
Export to Web Intelligence, CSV or image
Save it locally as a browser bookmark
One-click to send a link to the results by email
© SAP 2008 / Page 21
SAP NetWeaver BW Accelerator and
SAP BusinessObjects Polestar Integration
Agenda
The SAP BOBJ Roadmap
Current development status by tool
Software rampup plans
Training plans
What can be done now
What are others doing
Key points take away
Questions and Answers
The Business Intelligence Experts
23
Ramp-Up Availability
Some Observations….
Agenda
The SAP BOBJ Roadmap
Current development status by tool
Software rampup plans
Training plans
What can be done now
What are others doing
Key points take away
Questions and Answers
The Business Intelligence Experts
25
SAPBO SAP Business Objects for SAP
NetWeaver BW
future
New 2 day course offering from SAP Education for training
on Business Objects integration with SAP NetWeaver BW
Two dates are currently scheduled in June for virtual
course delivery
June 1 – 2, 2009
June 25 – 26, 2009
See the following link to the Course Description for more
detailed information on the content covered
SAPBO Course Description
Agenda
The SAP BOBJ Roadmap
Current development status by tool
Software rampup plans
Training plans
What can be done now
What are others doing
Key points take away
Questions and Answers
The Business Intelligence Experts
27
What can be Done in 2009- Implementations
Suggestion
Candidates for
Implementations in 2009
Tool
Visual Composer
Web Intelligence
BI Widgets / BO Universe
Crystal Report
BPC
BI Accellerator
Purpose
Visualization
Ad-hoc
Desktop Intelligence
Formatted reports
Consolidation & Planning
In memory performance
Visual
Composer
BI Accellerator
Web Intelligence (webi)
Widgets
Source: SAP, 2009
The Business Intelligence Experts
The two types of Universes
There are currently 2
ways to get at the SAP
BI data.
If you implement this
year, you need to
make concious
decisions about which
method you select.
There are pros and
cons of each
The Business Intelligence Experts
29
What can be Done in 2009- Take a Look at…
Xcelsius
Polestar is an interesting
technology that companies may
start a prototype with and see
how it can help them access BI
data from a variety of sources
(NW and others)
Suggestion
Polestar
Worth a Prototype
Xcelcius
Polestar
Purpose
Dashboards
Search engine
Keep an Eye on, but wait
until the new release
Pioneer
BEx web & Excel
The Business Intelligence Experts
Tool
What can be Done in 2009- Prototype
Consider
building a
Xcelsius
Prototype to
get used to
really
interactive
dashboards
and what-if
analysis.
Xcelsius
Source: Adobe, 2009
Suggestion
Worth a Prototype
Xcelcius
Polestar
Purpose
Dashboards
Search engine
Keep an Eye on, but wait
until the new release
Pioneer
BEx web & Excel
The Business Intelligence Experts
Tool
What can be Done in 2009- Keep doing…
There are many classical SAP
NetWeaver tools that should still be
used by companies that are planning
go-lives in 2009.
 Integrated planning is still supported.
 Pioneer is still 12 months away
 WAD will continue to be the development
environment for 2009.
Suggestion
Tool
Web Application Designer
BEx Web
Keep doing for a while longer BEx Excel
Analysis Process Designer
Integrated Planning
The Business Intelligence Experts
Purpose
Web development
Web reporting
Excel reporting
Structured Analysis
Planning
Stop As soon as possible
If you need Formatted Reports in 2009, you should seriously
consider Crystal Reports. The current roadmap calls for moving
Report Designer into regular maintenaice at the end of 2009,
and stop further development of this tool.
Looking forward to Xcelsius and Pioneer, it may be advisable to
limit futher custom development in JSP unless it is not intended
to be migrated at a future date.
Suggestion
Stop when possible
The Business Intelligence Experts
Tool
Report Designer
Custom JSP pages
Purpose
Formatted reports
Custom applications
Agenda
The SAP BOBJ Roadmap
Current development status by tool
Software rampup plans
Training plans
What can be done now
What are others doing
Key points take away
Questions and Answers
The Business Intelligence Experts
34
What are Others Doing – Example 1
Many are starting to develop and
prototype on the SAP BOBJ toolset.
Area
BI version
Company A
Mfg.
7.0
Casual users
209
Power users
15
This company is planning to rollout webi
and their new ad-hoc query
environment to a limited set of users in
2009.
Dashboards
-
System size
3 Tb
Live since
2001
The project team is small and the
development will also serve as a proofof-concept for future cokpit
development in 2010.
Team size
The Business Intelligence Experts
2009 Initiatives
Webi and Crystal
Reports go live in
October
3.5
What are Others Doing – Example 2
This company wants to start tooling up
their development team and have
decided to start an Xelcius prototype
effort for 2009.
They also plan of migrating some of their
current custom web dashboards into
Visual Composer for a go-live this fall.
Area
BI version
Casual users
713
Power users
30
Dashboards
28
System size
800 Gb
Live since
The Business Intelligence Experts
2000
2009 Initiatives Prototype with Xcelcius
and VC dashboard
deployment in
September 2009
Team size
Their initial team size is relativly small,
with one consultant and a couple of
employees.
Company B
Insurance
7.0
2.5
What are Others Doing – Example 3
This company is rolling out formatted
reporting to their core financial team
and have decided not to use Report
Designer.
Instead they are rolling out Crystal as
their core platform for pixel controlled
formatted reports.
Area
BI version
Casual users
806
Power users
50
Dashboards
42
System size
4.6 Tb
Live since
2009 Initiatives
Team size
They also want to start the team
transition to Xcelsius and is therefore
also developing some prototypes on this
technology.
The Business Intelligence Experts
Company C
Utility
7.0
2004
Crystal rollout October
and Xcelsius Prototype
5
What are Others Doing – Example 4
This company rolled out Crystal reports
on SAP BI in 2006 and is starting in 2009
with a project effort to migrate to
Xcelsius for web rendering and cockpits.
They have also started to develop visual
composer cokpits that they plan on
integrating into Xcelsius later in spring
2010.
The Business Intelligence Experts
Area
BI version
Company D
Mfg.
7.0
Casual users
1012
Power users
18
Dashboards
22
System size
2.1 Tb
Live since
2009 Initiatives
Team size
2003
Visual composer and
Xcelsius integration of
existing crystal reports,
go-live Nov. 2009
6
Agenda
The SAP BOBJ Roadmap
Current development status by tool
Software rampup plans
Training plans
What can be done now
What are others doing
Key points take away
Questions and Answers
The Business Intelligence Experts
39
Summary – Ideas for SAP BOBJ in 2009
Suggestion
Candidates for
Implementations in 2009
Worth a Prototype
Keep an Eye on, but wait
until the new release
Tool
Visual Composer
Web Intelligence
BI Widgets / BO Universe
Crystal Report
BPC
BI Accellerator
Xcelcius
Polestar
Purpose
Visualization
Ad-hoc
Desktop Intelligence
Formatted reports
Consolidation & Planning
In memory performance
Dashboards
Search engine
Pioneer
BEx web & Excel
Web Application Designer
BEx Web
Keep doing for a while longer BEx Excel
Analysis Process Designer
Integrated Planning
Report Designer
Stop when possible
Custom JSP pages
The Business Intelligence Experts
Web development
Web reporting
Excel reporting
Structured Analysis
Planning
Formatted reports
Custom applications
40
The total BOBJ toolset - Advanced Analytics
While we covered the core BOBJ tools that relates directly to
SAP BI, there are many other tools available:
Source: SAP
March, 2009
This Bonus Material Include all SAP BOBJ tools,
not just tools for the traditional SAP ERP market
The Business Intelligence Experts
41
The total BOBJ toolset –Dashboards & Visualization
This Bonus Material Include all SAP BOBJ tools,
not just tools for the traditional SAP ERP market
The Business Intelligence Experts
Source: SAP
March, 2009
42
The total BOBJ toolset – BI Best-of-Breed tools
This Bonus Material Include all SAP BOBJ tools,
not just tools for the traditional SAP ERP market
The Business Intelligence Experts
Source: SAP
March, 2009
43
The total BOBJ toolset – Data Integration
This Bonus Material Include all SAP BOBJ tools, not just tools for the traditional SAP ERP market
Source: SAP March, 2009
The Business Intelligence Experts
44
The total BOBJ toolset – Masterdata Management
This Bonus Material Include all SAP BOBJ tools,
not just tools for the traditional SAP ERP market
The Business Intelligence Experts
Source: SAP
March, 2009
45
Agenda
The SAP BOBJ Roadmap
Current development status by tool
Software rampup plans
Training plans
What can be done now
What are others doing
Key points take away
Questions and Answers
The Business Intelligence Experts
46
Questions and Answers
The Business Intelligence Experts
47
Resources
On –line Material, Presentations and Downloads
www.Comerit.net
Help @ SAP
http://help.sap.com > ‘BusinessObjects’ top level navigation tab
 SAP BusinessObjects Developer Community on SDN
http://boc.sdn.sap.com
‘BusinessObjects version of SDN’
Communities, Beta Product downloads, Webinar information, E-Books,
Developer Conference 2007 slides, Free Trial downloads, more!...
Check out the blogs and forums – there is already some great content posted
Ingo Hilgefort’s
bolg:https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/251909211
SAP NetWeaver Business Warehouse Roadmap and Roadmap FAQ
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b00a1a
75-c49d-2b10-0ebb-ecc80ab88994
https://www.sdn.sap.com/irj/boc/business-objects-for-sap-faq
The Business Intelligence Experts
48
New SAP Press Book

New SAP Press book by Ingo
Hilgefort to be released in May
2009
Great resource for technical
installation, implementation, and
integration information

http://sappress.com/product.cfm?account=
&product=H3034
The Business Intelligence Experts
49
confidential
How to contact us:
Dr. Bjarne Berg
[email protected]
The Business Intelligence Experts
Tanner Spaulding
[email protected]
50
Herunterladen
Explore flashcards