Transcript Slide 1

Business Intelligence Accelerator (BIA)
Business Case Justification
Presented by:
Michael Briles, Product manager, SAP Labs
Dr. Bjarne Berg, Director SAP BI, Comerit
SAP BIA – Field Experiences
7 Hints from the Field:
How to make SAP BI Accelerator
work for you
• Sizing and Implementation
• Management and Costs
Dr. Bjarne Berg
Michael Briles
Director of SAP BI
MyITgroup
[email protected]
SAP NetWeaver Product
Manager
SAP Labs, LLC
3410 Hillview Avenue
Palo Alto, CA 94304
M 206.355.6059
E [email protected]
Customer Experiences - BI Accelerator is simple to install
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 HPA
engine after each data
load
IBM, Sun, HP & Fujitsu have standard
solutions ranging from $32K to $250K+
that can be installed and tested in as little
as 2-4 weeks (+ SAP license fees)
Breaking news:
32 GB Blades are now
certified by SAP (July 2008)
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).
A Real Customer Example from September 2008
Environment
Production
Production
Production
Production
Production
Production
Production
Production
QA
QA
QA
QA
QA
QA
QA
QA
Development
Development
Development
Development
Development
Development
Development
Development
Area
Blade servers
Memory
Processors
Processor speed
Network cards
External storage
File system
Chassis
Blade servers
Memory
Processors
Processor speed
Network cards
External storage
File system
Chassis
Blade servers
Memory
Processors
Processor speed
Network cards
External storage
File system
Chassis
Recommended size
14 Blades
2x8 GB (2x4) DDR2 total 16 GB
2 x Quad Core Intel Xeon Processor
3.00 GHz+
2 x Gigabit Cisco cards
Dedicated disks (500 GB+)
General Parallel file system (GPFS)
14 blades capacity
14 Blades
2x8 GB (2x4) DDR2 total 16 GB
2 x Quad Core Intel Xeon Processor
3.00 GHz+
2 x Gigabit Cisco cards
Dedicated disks (500 GB+)
General Parallel file system (GPFS)
14 blades capacity
4 Blades
2x8 GB (2x4) DDR2 total 16 GB
2 x Quad Core Intel Xeon Processor
3.00 GHz+
2 x Gigabit Cisco cards
Dedicated disks (300 GB+)
General Parallel file system (GPFS)
14 blades capacity
IBM example*
BladeCenter HS21 -8853G6U
39M5797
2 x Quad Core Intel Xeon Processor
3.00 GHz
32R1760
DS-4800
GPFS
H-series (rack-mount/9U) 88524XU
BladeCenter HS21 -8853G6U
39M5797
2 x Quad Core Intel Xeon Processor
3.00 GHz
32R1760
DS-4800
GPFS
H-series (rack-mount/9U) 88524XU
BladeCenter HS21 -8853G6U
39M5797
2 x Quad Core Intel Xeon Processor
3.00 GHz
32R1760
DS-4800
GPFS
H-series (rack-mount/9U) 88524XU
The BIA should be sized for critical applications. Most companies use BIA
only for Production, while others have a complete landscape 5
Sizing is critical, but good tools are available to help
SAP has integrated key sizing parameters for BIA in the new QuickSizer.
You can give it a try at: http://service.sap.com/quicksizer
Customer with existing BI systems and data loaded can get good sizing
estimates by running the SAP program available in SAP Note: 917803
How does it work in reality??
Currently, the BIA performs aggregation and data selection for
the query, all other processing is done by the OLAP analytical
engine. Not all query processing will be dramatically faster…
In the next SAP NetWeaver release the BIA will handle more of the
analytics processing such as “top-5 products sales” which is
currently done in the OLAP analytical engine.
SAP BIA is not used when the result set exceeds 3 million records (max.
default). When the result set is less, the data is sent as one
large data package to the application server (need fast
network).
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)
8
BIA is becoming mainstream
Some of SAP reference clients
BIA is no longer
something exotic.
Nike
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
Agenda
1.
2.
3.
4.
Business Case
Value Proposition
Technical Offering
Outlook
Opportunities not Harvested
Traditional methods too inflexible, unreliable or not economical
THE TRENDS
THE CHALLENGES
Increased adoption of analytics
Traditional BI platforms are bottlenecks
 Data explosion, growing 50% p.a.
 Unpredictable response times
 Frequent need for change
 Inability to meet demand for change
 More users / usage of analytics
 € (tuning or boutique hardware)
 Users create queries despite having no
knowledge of BI technology
Daily Business Processes Require Intelligence
It’s 12/23, and You Are on the Phone with Your CEO...
800,000
600,000
Last week’s sales in Chicago
400,000
200,000
0
Cat 1
Cat 2
HOURLY DATA
Last hour’s sales in Chicago
This year’s sales in Chicago, by retail store
Last 5 year’s sales in Chicago,
by retail store, and comparable sales
Hourly data available
after store close
Processing Request
60 minutes remaining
Special Query
Required
Cat 3
Operational Business Intelligence Is Not Easy
Conflicting demands are difficult to reconcile
3 second response
time
Mine my 10
terabytes
Fresh data
every 3 minutes
Within
budget
You Can Have Some of What You Want: Special
Tuning
3 second response
time
Fresh data
every 3 minutes
5 hours
to update
aggregates
Mine my 10
terabytes
Need IT
to build
special
aggregate
Within
budget
You Can Have Some of What You Want: Custom
Database
3 second response
time
Fresh data
every 3 minutes
3 minutes to
read
database
5 hours
to update
aggregates
Mine my 10
terabytes
Within
budget
€2 million
equipment,
& €500.000
annually
Traditional Databases Built for Transactions
Traditional Databases Built for Transactions
Optimized for Record
Read / Write
Transaction
Screen
Traditional Databases Not Built for Analytics
∑
∑
∑
 Loading aggregated data will only satisfy some
queries
 Loading detailed data and keeping the
reporting performance , will need multiple
aggregates within the BI
?
∑
Free Your Information
Technology Drivers
1990
CPU
Memory
0.05
7.15
MIPS/$
MIPS/$
0.02
5
MB/$
MB/$
Addressable
Memory
Network Speed
Disk
Data Transfer
© SAP 2007 / Page 19
2006
216
264
100
10
Mbps
Gbps
5
130
MBPS
MBPS
Architectural Drivers
Improvement
143x
250x
248x
100 x
25x
1990
2006
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
Applicationaware and
intelligent data
management
The physical limits of a database
The physical access to the data
is limiting the speed of reporting
New Approach: “In-Memory” Technology
Columnar, memory-based, compressed
Calculation on the fly
 Lighting fast
 Always same performance
 Any query
∑
Compression, columnar optimized for analysis
 Agile,
 low TCO
 Fast to upload
BI Apps Benefit from “In-Memory” Technology
Gartner confirmed growing market trend
“ By 2012, 70% of Global 1000
organizations will load detailed
data into memory as the primary
method to optimize BI
application performance (0.7
probability).”
* Source: Gartner, 2006
SAP NetWeaver BI Accelerator Delivers
… faster and deeper insights, more value
3 second response
time
Mine my 10
terabytes
Fresh data
every 3 minutes
Within
budget
Agenda
1.
2.
3.
4.
Business Case
Value Proposition
Technical Offering
Outlook
SAP NetWeaver BI Accelerator
Value Proposition
Performance / Scalability
Cost of Operation

Ready for high data volumes
(retail, utilities, banking etc.)
Save disk space

Challenging response time SLA

Take load off BI hardware

Ad-Hoc reporting / stable response
times

Consolidate BI landscape

Scalable blade server platform

Save time to build and maintain
aggregates

Time for Development
IT

Business
Data Latency
New Business Scenarios

Get more detailed insight into your
business
Less focus on performance
aspects (aggregates, caching
strategies, DB tuning etc.) 
Faster development of new models
and queries

Extremely shortened roll-up and
change run times

Opportunity for more frequent data
alignments

Compression not always needed
SAP NetWeaver BI Accelerator
• SAP NetWeaver BI Accelerator for high performance BI at
lowest operation costs
A new transparent approach to boost BI query performance
• Performance speedup factor between 10 and 100 - also for
BusinessObjects clients
• Without changing the BI user experience (transparent to users)
• Ensures low cost of operations
• Prerequisite: BI in SAP NetWeaver 7.0
Compressed and Column-based
Optimized for Analysis
Calculation on the fly

Fast as Lightning

Predictable query performance

Any query
Calculation
DBMS
∑
Business
Warehouse
Bypassed
for queries
SAP NetWeaver BI

Agile

Low TCO

Fast to Upload
BIA
Query Execution
1
Information Broadcasting /
Precalculation
Information Broadcasting /
Precalculation
2
Query Cache
Query Cache
3
Aggregates
SAP NetWeaver BI Accelerator
4
InfoProvider
Query Execution
Without BI Accelerator
Query Execution
With BI Accelerator
SAP NetWeaver BI checks the listed repositories (in the order shown) to obtain the
query result.
© SAP 2007 / Page 27
Value Overview
User Experience
 Fast Query response times (also for BOBJ usage)
 Highly consistent response times
 Higher usage of BI and deeper analysis of company data or less time for BI
interaction
 More flexibility in Query definition
Maintenance
 No more need for maintenance of aggregates
 Reduced time for data loading (up to 80%)
 Reduce time for change runs
 Reduce times of SEM Consolidation runs
Hardware
 No more need for storage in aggregates
 Less Hardware needs on application server level
Agenda
1.
2.
3.
4.
Business Case
Value Proposition
Technical Offering
Outlook
Appliance Shipment – 1 –
•SAP NetWeaver BI Accelerator will only be
available as an appliance (“in a box”)
• Complete SAP NetWeaver BI Accelerator preinstalled
• Only little configuration effort by the customer, e.g. indexing
relevant InfoCubes
• Advantages
• Rapid Deployment
• Performance-optimized
• Minimized Maintenance
• Premium Hardware Partners (as of Q2 2008)
•
•
•
•
Hewlett-Packard
IBM
Fujitsu-Siemens
SUN
SAP NetWeaver BI Accelerator Architecture
Business Business Any Client
Objects Explorer Tool
In-Memory
Processing
Analytic Engine
InfoCubes
Any
Source
Indexin
g
Data Acquisiton
SAP NetWeaver BI
SAP NetWeaver
BI Accelerator
Benefits of Appliance Shipment
Rapid Deployment
Appliance
 Instantaneous operation
 Minimized maintenance
 Pre-Installed by
hardware vendor
 Centralized monitoring
through CCMS
 Minimal pre-defined
configuration
requirements for the BIA
software
 Simple purchase
 Limited variations based
on standard components
 Quick Time-to-market
Reduced Costs of
Operation
 Easy scalability through
blade server architecture
Performance &
Integration
 Optimized hardware/software
efficiency
 Combination of hardware
components and configuration
optimized for high-end
performance and high availability
 Assured quality of functionality
 Reduced integration effort with
hardware and software
 Affordable commodity
hardware
 Reduced license costs for
3rd party components
 Minimized upgrade risk
 Optimized HW/SW
support offers
Shipment and Availability
Availability
BI Accelerator is functionality of SAP NetWeaver 7.0
Available for SAP NetWeaver BI 7.0 and above
SAP NetWeaver BI Accelerator is only available as an appliance (“in a box”)
Complete SAP NetWeaver BI Accelerator preinstalled
Only little configuration effort by the customer, e.g. indexing relevant InfoCubes
Operating Systems and Storage
SUSE Linux 64-bit, Intel based
Memory based and file storage (no database for Accelerator)
Available Hardware Platforms
HP (HP ProLiant and HP StorageWorks)
IBM (IBM Blade Center and IBM Total Storage)
FujitsuSiemens (FSC Blade Server and EMC Storage)
SUN microsystems (SUN Blade Server and StorageTek)
Resounding Success with BI Accelerator
With Early Adopters and Market Analysts
 10 million records
 Query up to x102* faster
 Index update in 1min /day
 “we are absolutely happy”
 Measurable TCO reduction
 527% (avg.) performance
increase
“.. end users will benefit from
SAP raising the bar with its
new BI accelerator solution.”
* = as compared to traditional query without aggregates
 650 million records
 Query up to x300* faster
 Index update in 1min /day
 Live since September ‘06
 800+ users
 Across SAP- & non-SAP data
 1.3 billion records
 Query mean 0.9 sec (± 0.8)
 Index built at 200 million rows
per hour
Agenda
1.
2.
3.
4.
Business Case
Value Proposition
Technical Offering
Outlook
SAP NetWeaver BI –
Roadmap for BI Accelerator
High Performance BI
Existing Solution
PREMIUM
SAP NetWeaver
BI Accelerator
 Accelerator for InfoCube
Read Times
 Low Cost of Operations
 High Availability /
Backup & Recovery
2008
 Optimized BusinessObjects
Webl integration on top of
SAP NetWeaver BI/BIA
 BusinessObjects Polestar
integration: Self-Service BI
based on search paradigm
2009/2010
 Analytic Capabilities
(e.g. top n)
 DataStore Object
Acceleration
 Standalone BIA for
source-independent
acceleration via
Business Objects
 Agile BI: Local and
source-independent
innovation space for
departments
Key Points
Turn-key solution for BI performance
Breaking down the barrier between structural flexibility and performance
Commodity hardware based appliance
SAP NetWeaver BI Accelerator Roadmap – 1 –
BusinessObjects Polestar
BusinessObjects Polestar and SAP NetWeaver BI Accelerator – a perfect match
Easy, intuitive information exploration and analysis for business users
Bring self-service BI for business and casual users
Get fast facts and answer investigative questions
Explore and understand new data sources and unexamined parts of the business
No need to understand the data,
where it's located, or how it's structured
Rely on proven performance and scalability
of SAP NetWeaver BI Accelerator
Benefits of BI Accelerator
Very fast query response time
Performance improves by a factor of 10–200
Stable query response time
Increased
end-user
satisfaction
and extended
BI reach
Independent of DB optimizer, aggregates ...
High scalability
Planned support of new hardware paradigms like
grid and adaptive computing
Low maintenance
No aggregate maintenance, minimized rollup …
Significant
TCO
reduction
How do I get started with BI Accelerator??
Some options to consider:
• SAP Solution Manager – Early Watch Report
• Full SAP BI Assessment from MyITgroup
• Send inquiries to [email protected]
QUESTIONS
ANSWERS