1100-1130 paul barker how can i do operational analytics on real-time data
DESCRIPTION
TRANSCRIPT
28th May 2014 – Dubai, UAE
How can I do Operational
Analytics on Real-time Data? Paul Barker 28th May 20114 Public
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 3 Public
What real ‘real-time’ means
© 2013 SAP AG. All rights reserved. 3
More runs with fewer resources
Simplified operations and data management
with reduced layers
Better decisions with instantaneous knowledge on live data
Optimal planning and simulations in real-time
Instant, unified scenarios for full
automation
© 2011 SAP AG. All rights reserved. 4
Need a breakthrough technology Today's technology requires tradeoff
Broad
Deep
High Speed
Complex & interactive questions
on granular data
Big data,
many
data types
Fast
response-time,
interactivity
Broad
Deep
High Speed
Simple Real-time
Complex & interactive questions
on granular data
Big data,
many
data types
Fast
response-time,
interactivity
No data preparation,
no pre-aggregates,
no tuning
Recent data, preferably
real-time
Simple Real-time
No data preparation,
no pre-aggregates,
no tuning
Recent data, preferably
real-time
OR
© 2011 SAP AG. All rights reserved. 5
Intelligence
Value
Triggered Event
Data Integrated & Ready for Analysis
Information Delivered
Time
Action Taken
Value
Diminishes
Data
Latency
Analysis
Latency
Decision
Latency
Action Time
Increased
Value
Action
Time Reduced Time
To Action
Source: Dr. Richard Hackathorn. Bolder Technologies Inc.
We Need to Address Latency
© 2011 SAP AG. All rights reserved. 6
SAP HANA Platform is the only solution that does it all Delivering across 5 dimensions of modern decision-processing
Broad
Deep
High Speed
Simple Real-time
Complex & interactive questions
on granular data
Big data, many
data types
Fast response-
time, interactivity
No data preparation, no
pre-aggregates, no tuning
Recent data, preferably
real-time
© 2013 SAP AG. All rights reserved. 7 © 2014 SAP AG. All rights reserved. 7
OLTP
OLTP and OLAP together
Traditional: OLTP & OLAP Separate
>48 Hours 10:00 AM 10:00 AM
OLTP + OLAP in SAP HANA
10:00:00 AM 10:00:00 AM
Immediate
Instant Insight to Action on Live Data
>48+hr Old Data
Aggregate
ETL
Multiple Data Sources
OLAP
Replication
Replication
Replication
Application 101010010101 001001010011 0101101101110 100100010011 101010010101
001001010011 0101101101110 100100010011
SAP HANA Platform Inc. Suite On HANA
Decisions and Actions on Old Data
Multiple Data Sources
© 2013 SAP AG. All rights reserved. 8 © 2014 SAP AG. All rights reserved. 8
Massive IT simplification Reduce database size, footprint and more
All data processed in hot partition of database is brought and kept into main memory and as a single copy
Multiple Data Sources
101010010101 001001010011 0101101101110 100100010011
Eliminate unnecessary process steps
Accelerate business process performance
Data processing optimizations delivered by SAP
Deliver real-time reporting & analysis on live data
New virtual data model with SAP HANA Live with +2200 views already available
Only 1/50th of total data footprint
© 2011 SAP AG. All rights reserved. 9
Customer
Service
Risk Management
Team
Finance and
Operations
Account
Administration
Executive
Management
Customers Channel Suppliers Accounting Forecasting Inventory Products Pricing Planning
Vision across entire business process is a must Legacy of stove-piped fragmented operational data views
OLAP
DB
OLTP
DB
© 2011 SAP AG. All rights reserved. 10
Legacy of stove-piped fragmented operational data views Vision across entire business process is a must
SAP HANA
SAP
HANA Live
Customer
Service
Risk Management
Team
Finance and
Operations
Account
Administration
Executive
Management
Customers Channel Suppliers Accounting Forecasting Inventory Products Pricing Planning
SAP HANA Live provides a generic
datamodel which is:
• …easy to read and understood for
business people
• …for operational requests (no latency)
• …not duplicating data
• …ready to be used and extended
© 2011 SAP AG. All rights reserved. 11
SAP HANA Live Unified view of business processes across organizational functions
Instantaneous
transactions -
results-to-
actions
Empowerment
for front-line
employees
Unified view of
operations
without delay
Out-of-the-Box
Custom-built
Open Interface
Customer Extensions
Personalized
Views
Personalized
Views
Personalized
Views
Private Views
Reuse Views
Physical Tables
SAP-
delivered
Query
Views
SAP HANA Live (VDM)
Multi-channel Unified User Experience
SAP Business Suite
SAP NetWeaver
SA
P
NetW
eaver
BW
New
SA
P A
pp
s
Part
ner
Ap
ps
SAP HANA PLATFORM
Database Services
Synchronizations Services
Application Services
Operational
Reporting
* SAP HANA Live is a separate package for SAP Business Suite
© 2011 SAP AG. All rights reserved. 12
Pre-configured SAP BusinessObjects BI content SAP-certified best practices from transactions to analytics out-of-the-box
Immediate rollout
with no integration
challenges
Rapid
Deployment
Solutions
Easy
extension and
customization
Personalized
Views
Personalized
Views
Personalized
Views
Private Views
Reuse Views
Physical Tables
SAP-
delivered
Query
Views
Customer Extensions
SAP HANA Live (VDM)
SAP BusinessObjects BI
© 2011 SAP AG. All rights reserved. 13
SAP Business Objects BI Clients Using the Virtual Data
Model
Crystal Reports Enterprise 4.0.5
Dashboards 4.0.5
Explorer 4.0.5
Analysis Office 1.0.3 Design Studio
WebIntelliegnce
Lumira
© 2011 SAP AG. All rights reserved. 14
SAP HANA Live architecture Foundation for new class of applications
Atomic data
set for detailed
drill-down
information
Pre-defined
models across
entire suite
Operational data
available
instantaneously
HTTP(S),
HTML, CSS, JS, …
HTML5-based (web & Mobile)
Other SAP Solutions SAP BusinessObjects BI
XS Engine
Application Services
Web
Resource
oData
Service
Database Layer
Physical Tables
SAP HANA PLATFORM
Customer Extensions
Personalized
Views
Personalized
Views
Personalized
Views
Private Views
Reuse Views
SAP-
delivered
Query
Views
SAP HANA Live
Virtu
al D
ata
Model
3rd Party
Open Interfaces: https | oData | SQL | MDX
© 2011 SAP AG. All rights reserved. 15
Multi-channel Unified User Experience
SAP Business Suite
SAP NetWeaver
SA
P
NetW
eaver
BW
New
SA
P A
pp
s
Part
ner
Ap
ps
SAP HANA PLATFORM
New class of real-time analytical applications
SAP Working Capital
Analytics, DSO Scope
SAP Invoice & Goods Receipt
Reconciliation
SAP Access Control
Role Analytics
SAP Supply Chain Info
Center
Analytics on
real-time
Transactions
Simplified
Architecture
No
Unnecessary
Data Movement
Real-Time
Applications
Database Services
Synchronizations Services
Application Services
© 2011 SAP AG. All rights reserved. 16
Flexible analysis
paths
Example: SAP Working Capital Analytics, DSO Scope Days sales outstanding
New intuitive
user-experience
(iPad enabled)
Quick fact-based
decisions
Real-time analysis of drivers of your
company‘s days sales outstanding
(DSO)
Enables interactive build up of flexible
analysis paths to analyze data
Innovative visualization of analysis
process sequence
© 2011 SAP AG. All rights reserved. 17
Existing Stack
SAP HANA Live deployment options
Customers can add new analytics capabilities immediately without disruption to their existing
landscape. Any investment today will be valid for SAP Business Suite powered by SAP HANA.
SAP Business
Suite (ERP, CRM, SCM,…)
SAP Frontend
SAP HANA
Sidecar Approach
AnyDB
SAP Business
Suite (ERP, CRM, SCM,…)
SAP Frontend
Replication
BOBJ
HTML 5
Any frontend
SAP HANA Live
Suite on HANA
BOBJ
HTML 5
Any frontend
SAP HANA
SAP HANA Live
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 18
SAP Data Provisioning Access, improve, and deliver quality of data regardless of data domain, type, or source
• Access and deliver data with
scalable, high-performance,
enterprise data provisioning
solutions on premise or in the
cloud
• Unlock meaning from
unstructured documents with
native text data processing
• Improve the quality of data
regardless of data domain,
type, or source for any
stakeholder, project or
application
SAP Business
Suite
Non-SAP Data
Sources
Cloud
Deployments
Complex Event
Data Source
Network Devices
– Wired /
Wireless
Data Sources
(SP6: HANA, IQ, ASE,
Hadoop, Teradata)
SAP LT
Replication
Server
SAP Replication
Server
SAP Data
Services
SAP Event
Stream
Processor
SAP SQL
Anywhere
Smart Data
Access
Any Source Data Movement
Over Networks Transform, Unify
and Persist Data
Trigger-Based
Event Streams
Data
Synchronization
Data
Virtualization
Log-Based
ETL-Based
ODBC
© 2011 SAP AG. All rights reserved. 19
Strategic and tactical
Integration, harmonization,
cross-system consistency
Consumption
Planning
Preconfigured content
Data lifecycle
Data governance
Full-blown analytical suite
Operational data
Real-time
Lightweight modeling
and consumption
Extensible
Uniform
Deployment model
Model reuse in
analytical applications
All analytics requirements fulfilled with one unified solution
SAP HANA Live + SAP NW BW
SAP BW on HANA
SAP HANA Live
Multi-channel Unified User Experience
SAP Business Suite
SAP NetWeaver
New
SA
P A
pp
s
Part
ner
Ap
ps
SAP HANA PLATFORM
SA
P
NetW
eaver
BW
Database Services
Synchronizations Services
Application Services
SAP HANA Live
(Virtual Data Model)
© 2014 SAP AG or an SAP affiliate company. All rights reserved. 20
A new way to manage all forms of data. Unprecedented speed and efficiency for real-time business
transformation
SAP Data Management End-to-End, Real-Time Data Management
Real Time Lower TCO No Limits
SAP ESP Real-time Complex Event
Processing
SAP SQLA Mobile & Embedded Database
SAP IQ Logical Big Data Warehousing
(OLAP)
SAP Data Services All types of data integration
Real-time, in-memory
database, data
processing, and
application platform
SAP HANA
PLATFORM
SAP ASE Database for On-line Transaction
Processing (OLTP)
SAP Replication Server High volume transactional
data replications
© 2014 SAP AG or an SAP affiliate company. All rights reserved.
Thank you
Contact information:
Paul Barker
EMEA Enterprise Architect
+44 7787 154709