The Complete Guide to Reporting Tools Portfolio - with performance options

The Complete Guide to Reporting Tools
in SAP NetWeaver & the BusinessObjects
Portfolio - with performance options
Bjarne Berg
Director SAP BI
[ Learning Points
This is a comprehensive guide to SAP NetWeaver Business Intelligence
presentation tools
We will take an overview tour of the Analysis Process Designer (APD), SAP
NetWeaver Visual Composer (VC), Web Application Designer (WAD),
Report Designer, Web publishing, Java Server pages (JSP) and the new SAP
NetWeaver BI Query Designer & BEx Analyzer.
We will look at the strengths and limitations of each tool and see how they
can be used independently or collectively in a SAP BI environment.
Leave this session with a good understanding of how to use SAP
NetWeaver BI tools to make your system more flexible and adaptive to the
needs of end users.
Real Experience. Real Advantage.
2
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
3
[ The SAP BI Core Toolset
SAP BI is an
enterprise-wide
comprehensive
decision support (DSS)
system for analytical
needs of an enterprise.
BI can also support
some degree of
operational reporting
The SAP BI tool set has many presentation tools
and options for companies to leverage.
Real Experience. Real Advantage.
4
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
5
[
BEx Query Designer gets a ‘facelift’ in BI 7.x
The 3.5x BEx
Query Designer
The new 7.x Query designer was
totally re-developed in MS-Visual Basic
.NET
This new property pane makes it
easier to format and control displays
than in the past.
BEx Ad-Hoc Query
Designer functionality is
replaced by BEx Web
Analyzer in BI 7.0
Real Experience. Real Advantage.
The NWBI 7.0 BEx
Query Designer
6
[BEx – Analyzer (Excel Workbooks)
1. BEx Workbooks is Excel 'on steroids'.
2. BW queries can be opened in Excel
3. Queries can be refreshed
and standard Excel functions can
be used
This is a great tool for financial
analysts and power users.
To use this tool you
need BEx installed
Real Experience. Real Advantage.
7
[
BEx web Analyzer integrates Excel
The Excel integration in the
BEx analyzer is far better.
Source: SAP AG, 2008
Unlike the old days of dynamic
HTML, you can now use the
BEx analyzer more like a real
application without refreshing
the whole page every time you
click on something (this is due
to the Java component in BI
7.0)
Important: BEx browser goes away
in SAP BI 7.0 (so does BEx
Download Scheduler)
Real Experience. Real Advantage.
8
[BEx – Analyzer Design Mode
1. Application building in Excel (similar to WAD)
2. New options for queries with two structures
3. Excel formulas allow access to any cell of the result set
4. Excel formatting options can be fully leveraged for BEx
workbooks (e.g., blank lines, fonts, etc.)
5. Combining Excel formulas and Excel formatting allows the design
of complex formatted workbooks
6. Integration of Business Planning is available
To use this tool you
need BEx installed
Source: SAP, Zane Connally 2008
Real Experience. Real Advantage.
9
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
10
[Creating new data inside SAP BI
 In Data warehousing v2.0 (Bill Immon’s new terminology), we
are using BI applications to create new data that needs to be
fed to the data warehouse, and /or the transactional system
 Tools are now available to build association data sets that
creates updates based on BI findings (i.e. customer
segmentation, risk, profitability flagging etc).
Real Experience. Real Advantage.
11
Images: Bhanu Gupta, ASUG 2005 Illinois chapter
[APD – Analysis Process Designer and data mining
Complex scenarios can be
built for structured analysis
such as risk modeling,
customer segmentation,
market basket analysis,
predictive modeling and much
more
Image: SAP
“New data” based on the
findings can be loaded back into
data targets and used by others
for reporting i.e. CRM analysis.
Real Experience. Real Advantage.
12
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD)
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
13
[ Visual Composer
A Visual Composer is a tool to visualize the data. It is a browser-based
modeling and design tool for rapid application development & prototyping
in a code-free development environment.
Real Experience. Real Advantage.
14
[ Visual Composer for Complex cockpits
Modeling of BI applications using the BI kit of the Visual Composer
allows business users to create analytical content for SAP portal. It
offers the integration with BI infoproviders, views, BEx web
applications, PDF and more via WEB API as access to
other data
sources such
as OLAP and
relational data
sources) via
Java
connectors
Image source: Cubeserv
Real Experience. Real Advantage.
15
[ Visual Composer Data Methods
 Can integrate data from multiple data sources, including SAP
and non-SAP systems, into one model
 Different options available for data access include:
 BI Extension Kit
 Remote Function Call (RFC)
 Web services
 BI Extension Kit allows access
to the following DataSources
 SAP NetWeaver 2004 BI
(BW 3.5 Support Package 14)
 SAP NetWeaver BI 7.0
 JDBC
 XMLA
Real Experience. Real Advantage.
16
[
Visual Composer is Easy for Power Users to Learn
Visual Composer is a power user tool that is simple to learn for
someone with a little bit of technical background (i.e. controllers,
report writers, analysts).
No coding required to
create great-looking
Web-based cockpits
Source: SAP
Take advantage of prebuilt analytic business packages
Real Experience. Real Advantage.
17
[
The future of Visual Composer
Source: SAP, July 2008
Composition Environment including Visual Composer
“continues to be the go-to product for creating
composite applications” (SAP, 2008)
Real Experience. Real Advantage.
18
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
19
[ BEx Web Application Designer (WAD)
BEx Analyzer/
Query Designer
BEx Web Application Designer
Web Browser
WAD is an intuitive tool
to build powerful web
applications and to
interact with portals and
custom templates.
OLAP Processor
Web Service
Charting Engine
Real Experience. Real Advantage.
HTLM Templates
InfoProvider
BW queries can be
manipulated in WAD for
better display
20
[New Features of SAP NetWeaver SAP BI 7.0
Web AD
Web Items: Tab Pages, Button, Script Item (in SAP BI 7.0 Support Package
Stack 7)
Drag and drop using Analysis item
New chart types (heat map, Gantt, milestone trend analysis)
Export BI Web applications in PDF format
Command Wizard for generating Web API commands
Integration with SAP NetWeaver BI 7.0 BEx Report Designer for
formatted reports
NEW: User can change the XHTML
source code of any web template
either directly, or the ABAP program
RS_TEMPLATE_MAINTAIN_70, or in
any external XHTML editor.
Real Experience. Real Advantage.
21
[ Command Wizard and JavaScript
 You can use Command Wizard for generating JavaScript code for
the Script Item to use in custom cockpit applications
Real Experience. Real Advantage.
22
[ Product Directions for BI Solutions
And Much
More…
Dashboards,
Visualization
Web App Designer
Xcelsius
Enterprise
Reporting
Polestar
Report Designer
Crystal Reports
Ad-hoc
Query &
Reporting
BI Widgets
Web Intelligence
Mobile BI
Advanced
Analysis
SAP BEx Analyzer
Enterprise Data
Warehousing
& BI Platform
Voyager
Predictive
Web Services
SAP NetWeaver BW and BWA
BusinessObjects Enterprise
Source: SAP 20009
Real Experience. Real Advantage.
[ Product Directions for BI Solutions
And Much
More…
Dashboards,
Visualization
Web App Designer
Xcelsius
Polestar
Enterprise
Reporting
Report Designer
Ad-hoc
Query &
Reporting
Crystal Reports
BI Widgets
Web Intelligence
Mobile BI
Advanced
Analysis
SAP BEx Analyzer
Enterprise Data
Warehousing
& BI Platform
Voyager
Predictive
Web Services
SAP NetWeaver BW and BWA
BusinessObjects Enterprise
Source: SAP 20009
Real Experience. Real Advantage.
[
BI Web Application Designer Roadmap
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 NW BW
Real Experience. Real Advantage.
BEx Web
App
Designer
BEx Queries/
InfoProviders
SAP NW BW
Migration
BEx Web
BEx Web
App
Templatesoptions via
Designer
Pioneer SDK
25
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
26
[ The BEx Report Designer
This new tool was created
to simplify the formatting of
reports and fix many of the
printing issues in previous
versions of BW.
Source: SAP AG
We now get color control, header-footer control and many new features such
as location control of cells and integration of pictures, charts and fixed text.
Real Experience. Real Advantage.
27
[ BEx Report Designer is new in BI 7.0
Customizable font styles (i.e.
bold, italic), colors, etc.
Group-level changes with
individual formatting
Layout options, e.g.: Height of
rows, width of columns
Multi-line column headers
Flexible field positioning
Merging cells
Support for hierarchies
Rules for the presentation of
special characteristic values
Integration of text, pictures,
and charts
Header & footer for reports
Real Experience. Real Advantage.
News: BEx Report Designer 7.1, (last release in
2008) will be available under maximum
maintenance until 2016 and will be replaced with
the Crystal Base product.
28
[ Crystal Report is still available (also in SAP BW 3.x)
 With BW you get access to Crystal reports. In fact you have many predeveloped reports that comes with SAP-BW. Currently, you can modify, or
develop and deploy a few Crystal reports without additional licensing cost.
 Crystal is a great tool for batch reporting of "pixel controlled' formatted
reports.
Real Experience. Real Advantage.
29
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
30
[ Web Cockpits in the Portal
You can integrate queries
and Web applications into
the portal through
publishing, broadcasting, or
Web calls
Publishing
The portal can either
receive designed pages
passively or actively create
communities, Web pages,
collaboration rooms, or
cockpits
Broadcasting
Real Experience. Real Advantage.
31
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
32
[
BI Java SDK-Based Applications in SAP BI 7.x
 BI Java SDK can be used for custom applications based on SAP BI
and non-SAP data.
 BI Java SDK provides access to relational and OLAP data sources
using JDBC, XMLA, ODBO etc.
 Access to 200+ data sources using the JDBC drivers.
Java programmers will
recognize the standard
development kit's (SDK)
main libraries such as the
abstract windowing toolkit
(AWT) and the GUIoriented Swing object
library as well
Real Experience. Real Advantage.
Source: SAP AG, 2008
33
[ BI Java SDK-Based Cockpits (cont.)
 SAP NetWeaver Developer Studio can develop BI Java SDK-based
applications
 Can use along with SAP Java Web Dynpro
Interested developers
should familiarize
themselves with SAP
NetWeaver
Developer Studio
Real Experience. Real Advantage.
34
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
35
[
SAP’s Premium Offerings
SAP Acquired Business Objects in 2007/2008 and is working on
integrating BOBJ into the core SAP BI offerings.
Real Experience. Real Advantage.
36
[
BOBJ capabilities – Dashboards and Reports
• Dashboards can be built using Xcelsius.
• Xcelsius+ will be launched in 2009, and
will be “the flagship product for data
visualization & dashboards”
Crystal Reports for pixel formatted reports has
been available with SAP BI/BW since 2002. This
tool can be integrated into your tool portfolio
using existing SAP NetWeaver BI queries
(NOTE: Crystal & Crystal Base will be the core tools for formatted
reports starting 2010)
Source SAP AG, 2009
Real Experience. Real Advantage.
37
[ BOBJ capabilities – Analysis,
Ad-hoc & Widgets
The Web Intelligence tool from BOBJ is
a tool for ad-hoc web based reporting,
query & analysis.
It is intended for end users and can
leverage queries to both relational and
OLAP sources.
It will be the core offering for ad-hoc
end user analysis starting 2009.
With the current offering of BOBJ you can
also use Desktop Widgets to place BI
content direct onto a PC desktop and
monitor reports and KPIs.
Source SAP AG, June 2008
Real Experience. Real Advantage.
38
[ New Tools Roadmap
Source SAP
Real Experience. Real Advantage.
39
[ The Move towards Pioneer
Web
based
• Pioneer (for 1st Quarter 2010 release) provides
a superset of the capabilities in BEx Analyzer
(Excel), BEx Analyzer (Web), and Business
Objects Voyager.
• Voyager customers migrate to Pioneer.
Excel
based
• BEx Analyzer & BEx Web Analyzer customers
migrate to Pioneer. (Note: BEx is planned to go
into regular maintenance)
Source SAP, April, 2009
Real Experience. Real Advantage.
40
[ 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 Accelerator
Web Intelligence
(webi)
Real Experience. Real Advantage.
Widgets
[ 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 conscious
decisions about
which method you
select. There are
pros and cons of
each
Real Experience. Real Advantage.
42
[ Overview: Options for Universe-Based Access to BW 7.0
Xcelsius
WebI
QT
QaaWS
Universes
SQL Access
MDX Access
Data Federator
RDBMS
Real Experience. Real Advantage.
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
Real Experience. Real Advantage.
ODA
XMLA
DF Fascade
OLAP BAPI
ODBO
Analytic Engine
BWA
44
[ Comparison
BW Server Feature
MDX
SQL
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

Real Experience. Real Advantage.
= limited support / workaround


[ 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
Worth a Prototype
Xcelcius
Polestar
Purpose
Dashboards
Search engine
Keep an Eye on, but wait
until the new release
Pioneer
BEx web & Excel
Real Experience. Real Advantage.
Tool
Polestar
[ What can be Done in 2009- Prototype
 Consider
building a
Xcelsius
Prototype to
get used to
really
interactive
dashboards
and what-if
analysis.
Xcelsius
Suggestion
Tool
Worth a Prototype
Xcelcius
Polestar
Purpose
Dashboards
Search engine
Keep an Eye on, but wait
until the new release
Pioneer
BEx web & Excel
Image source: Adobe, 2009
Real Experience. Real Advantage.
[ 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
Real Experience. Real Advantage.
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 maintenance at the end
of 2009, and stop further development of this tool.
 Looking forward to Xcelsius and Pioneer, it may be advisable
to limit further custom development in JSP unless it is not
intended to be migrated at a future date.
Suggestion
Stop when possible
Real Experience. Real Advantage.
Tool
Report Designer
Custom JSP pages
Purpose
Formatted reports
Custom applications
[ Training 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
http://www.sap.com/usa/services/education/usacourse.epx?c
ontext=%5b%5b|SAPBO||1|091|US|%5d%5d|
Real Experience. Real Advantage.
[ Agenda
 The SAP BI Tool Revolution







SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
 The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
51
[
Why BI-A? Disk speed is growing slower than other HW
components
Architectural Drivers
Technology Drivers
1990
2009
CPU
0.05
8.30
MIPS/$
MIPS/$
Memory
0.02
8.51
MB/$
MB/$
Addressable
Memory
216
264
Network
Speed
100
10
Mbps
Gbps
Disk
Data Transfer
5
400
MBPS
MBPS
Improvement
166x
425x
248x
100 x
1990
2009
Disk based data
storage
In-memory data
stores
Simple
consumption of
apps (Fat client
UI, EDI)
Multi-channel
UI, high event
volume, cross
industry value
chains
Generalpurpose,
applicationagnostic
database
80x
Physical hard drive speeds only grew by 80 times since 1990.
All other hardware components grew faster.
Real Experience. Real Advantage.
Applicationaware and
intelligent data
management
Source: 1990 numbers SAP AG
2009 numbers Dr. Berg
[BI Accelerator Works by Indexing InfoCubes in Hardware memory
BI Accelerator has been simple
to install and operate for
established SAP BI teams
SAP
BW
Any
tool
You use process chains to
maintain the BI-A engine after
each data load
IBM, Sun, HP & Fujitsu have standard
solutions ranging from $32K to $300K+
that can be installed and tested in as
little as 2-4 weeks (+ SAP license fees)
Real Experience. Real Advantage.
32 GB Blades are
certified by SAP
[ BI Analytical Engine’s Query executing priorities
Information Broadcasting /
Precalculation
Information Broadcasting /
Precalculation
Query Cache
Query Cache
Aggregates
SAP NetWeaver BI Accelerator
InfoProvider
Query Execution
Without BI Accelerator
Query Execution
With BI Accelerator
Aggregates can be replaced with BI-A, while
the memory cache is still useful.
Real Experience. Real Advantage.
[ Performance is Near-Linear: Benchmarks
BIA’s strength resides in its
near-linear scalability
Performance is measured in
terms of:
1. BI-A index creation time
2. Multi-user throughput per hour
3. Average report response time
4. Average number of records
touched by each report
BIA Currently reads data from
InfoCubes. DSOs & InfoObjects
are still read from base/physical
tables (even when the InfoObject
is indexed as part of master data).
Real Experience. Real Advantage.
[ Most customers have found BIA Admin to be minimal
The training & admin to run
BI Accelerator has proven to
be minimal. Training is
included in the SAP courses:
BW310, BW360 and in the
online course BW361
Many companies, have spent 2-5 days in
BIA training (total for 1-2 administrators)
and a work through a single interface:
RSDDBIAMON (Checks available at: RSRV)
In the past, SAP has also offered a 2 day workshop
called “BI Upgrade & Accelerator” (WNABIA)
Real Experience. Real Advantage.
[ BIA is becoming mainstream
Some of SAP reference clients
BIA is no longer
something exotic.
Many of the large BI
systems have already
implemented BIA and
many more projects are
under way in Europe
and in the Americas.
Once you exceed a few hundred
critical users and/or 3-4 TB of data you
should seriously consider SAP BIA
Real Experience. Real Advantage.
[ Who gets to do what?
The major decision for a SAP BI driven enterprise is to determine
who gets access to each tool.
There is often a temptation for the IT community of wanting to
keep the tools under their domain – That is a mistake
The IT community should actively work with the power and
casual users to improve human capabilities and thereby teach
them to become more productive employees.
Chinese Proverb
Real Experience. Real Advantage.
58
[ Agenda
 The SAP BI Tool Revolution








SAP NetWeaver BI Query Designer & BEx Analyzer
Analysis Process Designer (APD),
SAP NetWeaver Visual Composer (VC)
Web Application Designer (WAD)
Report Designer
Web publishing
Java Server pages (JSP) and the old Business Server Pages (BSP)
The BOBJ Roadmap for front-end tools
 Empowering the users – a mind shift
 Who Should get access
 Wrap-up
 Bonus material: All SAP BOBJ tools
Real Experience. Real Advantage.
59
[ Resources
COMERIT (Presentations, guides and accelerators)
www.comeritinc.com

 SAP Documents - Interfaces for Enterprise Reporting, Query, and
Analysis
 https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/libra
ry/uuid/f52e9cc1-0d01-0010-d88b-d808b69391a4
 SAP Business Intelligence (BI) by Norbert Egger, Jean-Marie Fiechter,
Sebastian Kramer, Ralf-Patrick Sawicki, and Stephan Weber.
 Galio Press - Hardcover, 653 pages, ISBN 978-1-59229082-6
Real Experience. Real Advantage.
60
[
Key Learnings
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
Real Experience. Real Advantage.
Web development
Web reporting
Excel reporting
Structured Analysis
Planning
Formatted reports
Custom applications
61
[ Questions and Answers
How to contact me:
Dr. Bjarne Berg
[email protected]
Real Experience. Real Advantage.
62
[
Bonus Material – The total BOBJ toolset
This Bonus Material Include all
SAP BOBJ tools, not just tools
for the SAP market
Source: SAP March, 2009
Real Experience. Real Advantage.
63
[
Bonus Material – The total BOBJ toolset
This Bonus Material Include all
SAP BOBJ tools, not just tools
for the SAP market
Source: SAP March, 2009
Real Experience. Real Advantage.
64
[
Bonus Material – The total BOBJ toolset
This Bonus Material Include all
SAP BOBJ tools, not just tools
for the SAP market
Source: SAP March, 2009
Real Experience. Real Advantage.
65
[
Bonus Material – The total BOBJ toolset
This Bonus Material Include all
SAP BOBJ tools, not just tools
for the SAP market
Source: SAP
March, 2009
Real Experience. Real Advantage.
66
[
Bonus Material – The total BOBJ toolset
This Bonus Material Include all
SAP BOBJ tools, not just tools
for the SAP market
Source: SAP March, 2009
Real Experience. Real Advantage.
67