Real-Time Analytics: What's New with SAP S/4HANA Embedded Analytics? Helen Sunderland, SAP Canada Jürgen Butsmann, SAP Deutschland SE & Co. KG A5367
5367REAL-TIME ANALYTICS: WHAT'S NEW WITH SAP S/4HANA EMBEDDED ANAL ANALYTICS? YTICS?
5367REAL-TIME ANALYTICS: WHAT'S NEW WITH SAP S/4HANA EMBEDDED ANAL ANALYTICS? YTICS?
Legal disclaimer The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP. SAP. This presentation is not subject to your license agreement or any other service or subscription agreement with SAP. SAP. SAP has no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation and SAP's strategy and possible future developments, products and or platforms directions and functionality are all subject to change and may be changed by SAP at any time for any reason without notice. The information in this document is not a commitment, promise or legal obligation to deliver any material, code or functionality functionality.. This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, merchantability, fitness for a particular purpose, or non-infringement. This document is for informational purposes and may not be incorporated into a contract. SAP assumes no responsibility for errors or omissions in this document, except if such damages were c aused by SAP´s willful misconduct or gross negligence. All forward-looking forward-looking statements are subject to various risks and uncertainties that could cause actual actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.
Agenda
Real-time operational reporting in the context of SAP Suite on HANA and SAP S/4HANA
VDM Concepts in Suite on HANA and SAP S/4HANA
Demo
Content
What is CDS?
What is SAP’s BI strategy?
Do we replace BW with this?
Best Practices
Summary and additional information
Real-time operational reporting in the context of SAP Suite on HANA and SAP S/4HANA
Combining transactions and analytics on a single in-memory platform
• Decisions and Actions on Old Data
• Instant Insight to Action on Live Data
• Multiple Copies of the Data
• One Copy of the Data
• ETL and Batch Processing Efforts and Costs
• No ETL and Batch Processing
Virtual Data Models
UI’s
BI
Application
Transactional system, e.g. SAP S/4 HANA View
Virtual Data Model
View
View
Database Layer, e.g. SAP HANA
View
View
Physical Tables
View
VDM Concepts in Suite on HANA and SAP S/4HANA
SAP Business Suite real-time analytics architecture (SAP HANA Live) •
No latency
•
No data duplication
•
Ready-to-use content
•
Integration scenarios with SAP BW
HANA Database Layer
Atomic
SAP Business Suite Application Hybrid Transactional and Analytical Applications
Analytical Apps and BI Clients e.g. SAP BusinessObjects BI
e.g. SAP Smart Business cockpits
Virtual Data Model on Physical Tables
Instantaneous
Pre-defined
HANA Live Content Map as of Q2/2015 ERP - Finance and Logistics
ERP - HCM
CRM
GRC
Transportation and Logistics
SCM
Headcount, Capacity, Overtime, Positions and vacant positions
Sales Contract, Order, Quotation, Opportunity, Lead
Access Request, Access Risk, Emergency Access
Event Management: Delays of Deliveries, Average Cycle Times
Demand Planning and Supply Network Planning;
Real Estate Management
Service Request, Order, Problem, Complaint, Confirmation
Role Administration
Transportation Management: Forwarding Order, Settlement, Dangerous Goods, Transport Order Discrepancies, Tendering
Global Available-to-Promise (GATP)
Commodity Risk Mgmt: Net Position PhysicalDeals, Net Position Derivatives, Hedging Ratio
Marketing Contact Tracking, Campaigns
GTS- Compliance Mgmt., Customs Mgmt.
Extended Warehouse Management: Outbound and Inbound Delivery Item
SD: Sales, Delivery, Billing, Customer, Organizational Units, Quotation Pipeline
Ac ti vi ty, I nt er ac ti on R ec or d
O pe ra ti on al R is k M an ag em en t
Event Management/ Transportation Management Cross-Analytics: Delay Times, On-Time Performance, ENHANCED: Wave Pick Item
MM: Master Data, IM-Quantity, IMValuated stock, IM – Material Document, IM-Purchasing
CRM/SD – Cross reporting on Orders, Invoices and Credit Memos
FIN: Financial Accounting, Management Accounting
Manufacturing: Order Items, Capacity requirements, Order Backlog, Overall Equipment Effectiveness Recipe Development: Specification Basic Data, Recipe Basic Data and Calculations PLM: Where-used-list for BOM, BOMExplosion, NEW: BOM-Summary Plant Maintenance/ Enterprise Asset Management: Location Cost, Maintenance Order Cost
simple Finance
Project System: Network Activities, Missing Material, Purchasing Document, GL Accounting Documents, Cost Variance, Period Cost, Stock, Accounts Receivable and Accounts Revenue… Payable Line Items
Insurance
Utilities
Policy Management
Meter Reading
Insurance Paid Loss Ratio
Billi ng
Claims Management
Invoicing
Collections and Disbursements
Device Management Quotations and Contracts,
Retail ENHANCED: Retail Promotions, Promotion Articles/Prices, Retail Promotion Execution Issues
NEW: Oil&Gas NEW: Product Revenue Accounting
Others Process Observer
Highlights 2015 / 2016 Suite on SAP HANA – SAP HANA Live
Smart Business Cockpits for e.g. Smart Business Cockpits for e.g.
Extended Warehouse Management PLM: Impact Analysis of changed recipes Retail Promotion Execution Cockpit
Virtual Data Model, e.g.
IS-Utilities Product Lifecycle Management
Q1 2015
Identity Analytics Retail Promotion Execution Cockpit enhanced Supply Chain Management
Smart Business Cockpits for e.g.
Virtual Data Model, e.g.
Virtual Data Model, e.g.
Transportation & Logistics Improvements in Analysis Path Framework
Extended Warehouse Management Service Parts Planning
IS Retail CRM-Utilities: Contracts, Quotations Supply Chain Execution IS Utilities: meter2cash
Q2 2015
Q1 2016
What we want: 3 – Use cases for and in SAP S/4HANA
SAP Business Warehouse powered by SAP HANA
SAP HANA
In-memory platform
2011
SAP S/4HANA Simple Finance powered by SAP HANA
SAP Business Suite powered by SAP HANA
Real-time analysis
Real-time business
Instant financial insight
Real-time reporting
OLAP and OLTP together
No aggregates
SAP HANA Enterprise Cloud for SAP Business Suite on SAP HANA
Single source of truth
2012
2013
2014
Simplified data model
New user experience
Advanced processing
Choice of deployment
2015
Today transactions and analytics are handled separately but in reality, business processes are often a sequence of… transaction Enter Order
Create new employee salary data
analysis
transaction
Check Customer Churn Probability
Adjust discount percentage
Analyze yield and scrap of plants
Send email to all plant managers above/below certain thresholds
Check updated salary projection for cost centers
Built-in analytics – Imagine, one day we will have… Bi-directionally embedded Analytics in a transaction screen Purchase Request: 4711 Material :
515
Supplier :
101
Embedded multidimensional multidimensional Embedded report shows suppliers for report shows suppliers for theentered enteredMaterial MaterialNo. No.and and the theirDelivery DeliveryPerformance Performance + their trading volume
Default Discount :
…:
2
Navigate to a full screen version of the report and perform multidimensional analysis , personalize report and share data.
1
…: A supplier is selected in the report, and its ID and other relevant data is transferred to the corresponding fields in the Activity.
Supplier Overview for Material 515 Current month Supplier
Personalize
Delivery Performance
Trading Volume Last Year
100
98%
550 K €
101
95%
1.230 K €
102
94%
270 K €
3
Continue with… Supplier Overview for Material 515 Current month Supplier
Personalize Personalize
Deliver yPerfor mance
Integration into SAP Smart Business
Trading Volume Last Year
100
98%
550 K €
101
95%
1.230 K €
102
94%
270 K €
More concepts? Visualize using SAP BI
Search/Fact Sheets
SAP Business Suite real-time analytics architecture (SAP HANA Live) •
No latency
•
No data duplication
•
Ready-to-use content
•
Integration scenarios with SAP BW
HANA Database Layer
Atomic
SAP Business Suite Application Hybrid Transactional and Analytical Applications
Analytical Apps and BI Clients e.g. SAP BusinessObjects BI
e.g. SAP Smart Business cockpits
Virtual Data Model on Physical Tables
Instantaneous
Pre-defined
SAP S/4HANA real time analytics architecture •
No latency
•
No data duplication
•
Ready-to-use content
•
Integration scenarios with SAP BW
•
Full ABAP Lifecycle Integration
•
Supporting ERP authorizations
•
Supporting ERP hierarchies
•
Part of the general Extensibility concept
•
Supporting more business cases (analytics, search, fact sheets, planning,…) ABAP Layer
HANA Database Layer
Atomic
SAP S/4HANA Application Hybrid Transactional and Analytical Applications
Analytical Apps and BI Clients e.g. SAP BusinessObjects BI
e.g. SAP Smart Business cockpits
Virtual Data Model, based on Core Data Services (CDS)
Analytical Engine*
SQL-Runtime-Views on Physical Tables
Instantaneous
Pre-defined
Analytics Embedded in SAP S/4HANA Virtual Data Models as part of transactional systems SAP S/4 HANA UX
Transactions
Business Transactions
Built-inhybrid Analytics
Analytics
Logistics Etc.
Database
Virtual Data Models
View
Finance View View
Physical Tables
View View
View
The use cases for analytical processes in SAP S/4HANA VDM Consumers
Embedded Business Intelligence: Hybrid Transactional and Analytical Applications e.g. SAP Fiori apps or SAP Smart Business cockpits
Virtual VirtualData Data Model Model (VDM)
Read-access for
Other use cases
Fact Sheets
e.g. Integration with SAP BW*
Search
e.g. SAP Lumira, SAP BusinessObjects BI or SAP Cloud for Analytics
Specific Analytics Models Virtual Data Model operational and analytical processing
HANA Platform SAP HANA Platform
Strategic Business Intelligence: Stand-alone All-Purpose Applications
Application Tables
Customer Extensions
External Sources
SAP S/4HANA embedded analytics Offerings per Type of User End-User: Analyze the Data and act according to Insights Multidimensional reports and visualizations
SAP Smart Business KPIs / APF
Analytical Fiori Apps
Query Browser
BI Solutions integrate with SAP S/4HANA
SAP Cloud for Analytics
SAP Lumira
Key-User: Enable the End-User Query Designer
KPI Modelling Apps
IT-User: Provide the single source of truth in one semantic layer CDS View maintenance: ABAP for Eclipse
SAP BusinessObjects BI Suite: Examples: Analysis for Office, Design Studio
S/4HANA embedded analytics: Multidimensional Reporting Client
S/4HANA embedded analytics: SAP Smart Business cockpits
Example for enabling contextual Business Insides: SAP Smart Business cockpits
New working models combine different app types and demonstrate the value of SAP Business Suite 4 SAP HANA
Combining real-time insights with analytics and transactional follow-up activities to allow better and faster decisions as well as instant exec ution
Scenario specific content (KPI-definition, roles, ..) and drill-down applications/reports. All KPIs are based on the same KPI repository and services
Fiori Launchpad
Performance-driven Working Model
Analyze in SAP BI and
Smart Business Drill-Down
Analysis Path Framework
Analysis in SAP BI
SAP S/4HANA standard analysis
Collaborate
Situation-driven Working Model HANA Search, C‘est Bon, Fact Sheet
Task-driven Working Model
Execute Transactions
SAP Digital Boardroom ** and related Architecture (SAP Cloud for Analytics*)
* Connection to S/4HANA VDM planned
Query Browser
Analytical SAP Fiori Applications
SAP BusinessObjects BI Suite – Example: SAP BusinessObjects Analysis for Office (on premise only, separate license)
SAP BusinessObjects BI Suite – Example: SAP Design Studio (on premise only, separate license)
SAP Lumira (on premise only, separate license)
Query Designer
KPI Modelling Apps
SAP Cloud for Analytics
ABAP for Eclipse
Demo
SAP BI embedded in SAP Fiori
Content
S/4HANA EmbeddedAnalytics Content Release 1511 – (1/3) Reports, ready to run* View Name C_APCASHDISCOUNTFORECAST C_APCSHDISCUTILIZATION C_APDAYSPAYOUTST C_APFLEXIBLEAGING C_APFUTUREACCOUNTSPAYABLE C_APINVOICEPROCESSINGTIME C_APMANUALPAYMENTS C_APOVRD C_APVENDOROPENITEMS C_CASHPOSITIONANALYTICS C_CHARTOFACCOUNTS C_CMDTYBASISPOSITIONREPORT110 C_CMDTYPOSITIONREPORT110 C_CMDTYPRICINGSTATUSREPORT110 C_COLLECTIONPROGRESSQ C_COMPACTJOURNALQ0001 C_COSTCENTERACTIVITYTYPEQ0001 C_COSTCENTERQ2001 C_CREDITLIMITUTILIZATIONQ C_CUSTOMERPROJECTDETAILS C_CUSTPROJPLANQUERY C_CUSTPROJTEAMPLANQUERY C_DAYSBEYONDTERMS C_DAYSSALESOUTSTANDING C_DOCUMENTJOURNALQ0001 C_DUNNINGLEVELDISTRIBUTION C_FORECASTDEMANDACCURACYQRY
View Description Cash discount forecast Account Payable Cash Discount Utilization Accounts Payable. Days Payables Outstanding Aging Analysis Accounts Payable. Future Accounts Payable Accounts Payable. Invoice Processing Time Vendor Payment Analysis: manual and automatic payments Accounts Payable. Overdue Payables Accounts Payable. Vendor Open Items Cash Position Analytics chart of accounts Commodity Basis Position Report RP 110 Commodity Position Report RP 110 Commodity Pricing Status Report for Risk Profile 110 Collection Progress Query Compact Journal Query Cost Center Activity Type Cost Centers - Actuals Credit Limit Utilization with Threshold
Application Component FI-GL-IS FI-GL-IS FI-GL-IS FI-GL-IS FI-GL-IS FI-GL-IS FI-GL-IS FI-GL-IS FI-GL-IS FI FI FIN-FSCM-TRM FIN-FSCM-TRM FIN-FSCM-TRM FI-GL-IS FI FI FI FI-GL-IS
Customer Project Details Query View for Customer Project Plan Query for Customer Team plan Days Beyond Terms for Smart Business Apps Days Sales Outstanding Smart Business App Journal Dunning Level Distribution Smart Business App Forecast Demand Accuracy
CA-CPD CA-CPD CA-CPD FI-GL-IS FI-GL-IS FI FI-GL-IS PP
S/4HANA EmbeddedAnalytics Content Release 1511 – (2/3) Reports, ready to run* View Name C_FUNCTIONALAREASQ2801 C_FUTUREACCTRBLS C_GLLINEITEMSQ0001 C_INTERNALORDERQ0001 C_INTERNALPROJPLANQUERY C_INTERNALPROJTEAMPLNQUERY C_INTPROJCOSTPERFQUERY C_MARKETSEGMENTQ2501 C_MATERIALSTOCKACTUAL C_MATERIALSTOCKBYKEYDATE C_MATERIALSTOCKTIMESERIES C_MFGORDERITEMDURATIONQRY C_MFGORDEROPERATIONDURATIONQRY C_MLBALANCESUMMARY C_MLLINEITEM C_MLROUNDDIFF C_NONMNGDPURGSPEND C_OPENDISPUTECASE C_OVERDUEACCTRBLS C_PROFITANDLOSSQ2901 C_PROFITCENTERQ2701
View Description Functional Areas - Actuals Future Accounts Receivables Smart Business App Journal Entry Analyzer Internal Order Internal Project Planning Query Internal Project Team Plan Query Internal Project Cost Performance Query Market Segments - Actuals Total actual stock quantity Material Stock at posting date Determine material stock for periods of period type Manufacturing Order Item Duration Query Manufacturing Order Operation Duration Query Material Inventory Values - Balance Summary Material Inventory Values - Line Items Material Inventory Values - Rounding Differences Non Managed Purchasing Spend Open Dispute Case Overdue Accounts Receivables Smart Business App P&L - Actuals Profit Centers - Actuals
Application Component FI FI-GL-IS FI FI CA-CPD CA-CPD CA-CPD FI MM-IM MM-IM MM-IM PP PP FI FI FI MM-PUR FI-GL-IS FI-GL-IS FI FI
C_PROJECTQ2201 C_PROMISETOPAYOVERVIEW C_PURCHASECONTRACTLEAKAGE C_PURGMATLPRICECHANGE C_PURGSPENDCOMPRN
Projects - Actuals Promise To Pay Overview Purchase Contract Leakage Material Price Change Purchasing Spend Comparison
FI FI-GL-IS MM-PUR MM-PUR MM-PUR
S/4HANA EmbeddedAnalytics Content Release 1511 – (3/3) Reports, ready to run* View Name C_PURGSPENDOFFCONTRACT C_PURORDAVGDELIVTIME C_PURORDDELIVINVCVAL C_REVENUEFROMINVOICEQRY C_SALESORDERITEMQRY C_SALESORDERQ2301 C_STATISTICALKEYFIGUREQ0001 C_STRPTAXITEMQ C_STRPTAXITMWITHEUTAXCLASSQ C_SUPLRCOMPRNVIAPURVALS C_TOTALACCOUNTSRECEIVABLES C_TRIALBALANCEQ0001 C_TRIALBALANCEQ0002 C_UK_STRPTAXITMWITHEUTAXCLASSQ
View Description Spend Off Contract Purchase Order Average Delivery Time Purchase Order Delivery Invoice Value Sales Volume Incoming Sales Orders Sales Orders - Actuals Statistical Key Figure Tax Item for Statutory Reporting EU Sales Tax Item view for Statutory Reporting Supplier Comparison Via Purchase Values Total Accounts Receivables Smart Business App Trial Balance Trial Balance Comparison EU Sales Tax Item view for UK
Application Component MM-PUR MM-PUR MM-PUR SD SD FI FI FI-LOC FI-LOC MM-PUR FI-GL-IS FI FI FI-LOC
Content Overview and plan
See detailed document on request
What is CDS?
Core Data Services enable a consistent SAP Platform Story Next generation data definition and access for database centric applications Applications SAP BW on HANA
SAP Business Suite
High Performance Applications
SAP HANA Cloud Platform
Programming Interfaces ABAP
HANA XS
Core Data Services (CDS)
SAP HANA Database
CDS harmonize the programming model across all SAP platforms on HANA to ensure reuse and interoperability
Java
Extends SQL to capture the business intent in the data model instead of technical complexity in query
What are Core Data Services? A family of Domain Specific Languages and Services for defining and consuming semantically enriched data models
DDL
QL
DCL
Data Definition Language
Query Language
Data Control Language
Data modelling and retrieval on a higher semantic level
Consume CDS entities via platform embedded SQL (e.g Open SQL in ABAP)
Define authorizations for CDS views
Extends native SQL means for higher productivity
DML
Data Manipulation Language
Fully transparent SQL extensions
Write data
Integrates with classic authorization concepts
CDS: Data Definition Language (DDL) CDS DDL Entities with structured and custom-defined types Associations i.e. captured relationships
SQL DDL Calculated Fields pre-defined in data models Annotations to extend the meta models
CDS is “Standard SQL” 1:1 Representation of CDS Models in SQL Resulting SQL-View (in HANA DB Catalog):
CDS-View Definition:
Aliases
Projection List / Result set
Data Sources & JOINs
Filters Allows simply reactivating instead of manual CREATE/DROP/ALTER of SQL view
CDS: Development Environment Based on Eclipse platform Integrated in SAP HANA Studio and in ABAP in Eclipse Textual editor Rich feature set for fast development Integrated lifecycle management Code completion Data preview Quick-Fix function Syntax highlighting
ABAP for Eclipse
Key Takeaways Takeaways about Core Data Services
•
CDS provides a unified data model across all application domains
•
CDS provides one semantic layer for all use cases: search, operational and analytical
•
CDS extends SQL to capture business intent in the data model instead of technical complexity in query
What is SAP’s BI strategy and how does this relate to the above?
We continue to innovate our on-premise BI Portfolio Capitalizing on market momentum by protecting the investments customers have made in their existing BI infrastructure while showing customers the path to the cloud
Information Access [ Mobile | Portals ]
Reporting
Dashboards and Analytical Apps
Agile Data Discovery
BI Platform and Data Access (Semantic Layer)
ERP: SAP Business Suite and other ERPs
BW,TeraData, other DWs
Oracle, DB2, MS SQL and many other DBs
SAP HANA
OLAP Cubes
MS Excel
Unstructured data in Social Media and Hadoop
We continue to innovate our on-premise BI Portfolio Capitalizing on market momentum by protecting the investments customers have made in their existing BI infrastructure while showing customers the path to the cloud
Information Access [ Mobile | Portals ]
Web Intelligence & Crystal
Lumira & Analysis Office
Design Studio
BI Platform and Data Access (Semantic Layer)
ERP: SAP Business Suite and other ERPs
BW,TeraData, other DWs
Oracle, DB2, MS SQL and many other DBs
SAP HANA
OLAP Cubes
MS Excel
Unstructured data in Social Media and Hadoop
Strategic Analytics: All Use Cases – on-premise, cloud, hybrid
SAP Cloud for Analytics All analytics capabilities in one product
Consumer-grade user experience
Embedded and standalone
High-performance, real-time platform Cloud Edition
Public Cloud – SaaS/PaaS
Enterprise BI SAP BusinessObjects BI Suite BI 4.2 (Q4) Design Studio 1.6 (Q4) Analysis 2.2 (Q4)
On-Premise Edition
Agile Visualization SAP Lumira
Lumira 1.29 (Q4)
Advanced Analytics SAP Predictive Analytics Predictive Analytics 2.4 (Q4)
EPM
GRC
Ex. SAP Business Planning and Consolidation (BPC)
Ex. SAP Risk Management
BPC 10.1 NW SP08 (Q4)
Risk Management 10.1 SP11 (Q4)
On-premise and/or IaaS Deployments (HCP, Amazon, Azure)
SAP Digital Boardroom Reimagine your Boardroom for the Digital Economy
Total Transparency
Instant Data-Driven Insights
Simplified Boardroom Processes
Strategic Analytics for SAP S/4HANA Best integration to SAP S/4HANA
SAP Cloud for Analytics on HANA Cloud Platform
Native data access to S/4 Virtual Data Model and SAP BW
Replication-free real-time access using existing S/4HANA and HANA platform content (views)
Agnostic platform
Analytics Apps – on-premise or cloud-based
Virtual Data Model (CDS)
Transient Queries
SQL-Runtime-Views on Physical Tables
Integrate with all business applications – SAP and nonSAP
Optimized access all sources – relational, OLAP, and big data
Real-time predictive insights built in SAP HANA
Immediate 360° insights
Pull from multiple heterogeneous data sources
Mash-up different data sources together
Agile
access to 360° insights
Fiori Integration – High Level Architecture Fiori Launchpad
Design Studio applications running on the BI platform can be integrated into the Fiori Launchpad Design Studio applications appear as tiles in the Fiori Launchpad
Browser (Fiori UI) Fiori Launchpad
Design Studio App
iFrame via http(s)
Fiori Launchpad
OData via http(s)
ABAP Front End Server (SAP NetWeaver 7.31+)
SAP Business Suite ERP, ERP-FIN, CRM, SRM, …
Fiori Front End Server
UI Add-On (SAP UI5, SAP Fiori Launchpad)
SAP Gateway (OData enablement)
Trust
BI Platform (4.x) Design Studio Add-On
Trusted RFC (SSO)
ABAP Back End Server (SAP NetWeaver 7.31+)
Trust (RFC)
Trust (SQL/http)
SAP Business Suite ERP, ERP-FIN, CRM, SRM, …
BW
Universe
HANA
Back End Server (Application logic and data) 3rd Party Data
Do we replace BW with this?
SAP S/4HANA embedded analytics + SAP Business Warehouse Comprehensive operational + historical analytics and planning powered by SAP HANA SAP Business Warehouse on SAP HANA Multi-channel Unified User Experience
SAP S/4HANA (incl. Virtual Data Model)
r e v P a A e W B S W t e N
s p p A P A S w e N
SAP NetWeaver
SAP HANA PLATFORM Application Services Database Services (include SAP HANA Views) Synchronizations Services
r e s n p t r p a A P
Strategic and tactical
Preconfigured content
Integration, harmonization, crosssystem consistency
Data lifecycle
Data governance
Consumption Planning
Full-blown analytical suite
Multi-sourced data
SAP S/4HANA embedded analytics
Operational data
Uniform
Real-time
Lightweight modeling and consumption
Basis for multiple embedded use cases
Model reuse in analytical applications
Extensible
All analytics requirements fulfilled with one unified solution Data Integration Scenarios are possible in multiple hybrid system setups
Possible Hybrid Scenarios Example 1: SAP BW and S/4HANA side-by-side
BI Clients and other UI‘s
SAP S/4HANA
SAP S/4HANA embedded analytics CDS (VDM)
Data Staging
BW/OLAP SAP Virtual access via SDA
SAP HANA
SAP HANA SQL-RuntimeViews Transact. Tables
HANA optim.
Other Datamart
SAP DWH Data
HANA Tables Real-time replication or Data Staging
Possible Hybrid Scenarios Example 2: SAP BW and S/4HANA side-by-side
BI Clients and other UI‘s
SAP S/4HANA
SAP S/4HANA embedded analytics CDS (VDM)
Data Staging
BW/OLAP SAP Virtual access via SDA
SAP HANA
SAP HANA SQL-RuntimeViews Transact. Tables
HANA optim.
Other Datamart
SAP DWH Data
HANA Tables Real-time replication or Data Staging
Possible Hybrid Scenarios Example 3: embedded BW*
BI Clients and other UI‘s
SAP S/4HANA
SAP S/4HANA embedded analytics CDS (VDM)
SAP HANA
SAP HANA SQL-RuntimeViews Transact. Tables
*lim
Data Staging
BW/OLAP
HANA optim.
Other Datamart
SAP DWH Data
HANA Tables Real-time replication or Data Staging
Possible Hybrid Scenarios Example 4: S/4HANA and BW with SAP HANA Multitenant Database Containers (MDC)
BI Clients and other UI‘s
SAP S/4HANA
SAP S/4HANA embedded analytics CDS (VDM)
Data Staging
BW/OLAP
S
SAP HANA
SAP HANA
D
SQL-RuntimeViews Transact. Tables
A
HANA optim.
Other Datamart
SAP DWH Data
HANA Tables Real-time replication or Data Staging
SAP S/4HANA embedded analytics & SAP BW Data Integration – Scenarios Scenario A (Modeling via open ODS): Transactional and master data via S/4HANA embedded analytics consumed by BW (Consumption of SAP S/4HANA embedded analytics transactional and master data views by Open ODS Views in BW) Scenario B (Modeling-free only in embedded case): Transactional data provisioning via S/4HANA embedded analytics Open CDS View in BEx Query (Consumption of SAP S/4HANA embedded analytics open CDS views in BW via ODP Transient Provider)
Other possible scenario: • Loading of data into BW using Reuse Layer of S/4HANA embedded analytics as data source (Extract data from S/4HANA embedded analytics reuse views into BW)
Integration Scenario A HANA Smart Data Access & Modeling via Open ODS Views Consumption of SAP S/4HANA embedded analytics transactional and master data views by SAP BW From BW (optional)
From BW (e.g. hierarchy)
From S/4HANA embedded analytics
Integration Scenario A HANA Smart Data Access & Modeling via Open ODS Views Integrating BW and S/4HANA embedded analytics across different HANA instances with Open ODS Views and HANA Smart Data Access Use Cases
Transactional and master data from S/4HANA embedded analytics Virtual Data Model consumed by BW Open ODS view
This scenario is valid for BW and S/4HANA deployed across different HANA instances (prerequisite: HANA SDA configured)
SAP BW on HANA
BEx Query
HANA Composite Provider
Capabilities
Real-time (transactional and master) access to S/4HANA OLTP data with the help of Open ODS views consuming S/4HANA embedded analytics CDS views
Flexible, agile modeling through Open ODS Views
Capability to enrich data from S/4HANA embedded analytics views with BW managed master data (e.g. hierarchies)
Takes full advantage of BEx reporting capabilities
Security handled by BW authorization
Optional: Transactional data from S/4HANA embedded analytics can be enhanced with data stored in BW DataStore object (e.g. historical data / plan data) by utilizing HANA Composite Provider
Note •
Open ODS Views can be materialized in BW if required, e.g. for snapshot
Master Data
BW DSO
Master Data Transactional Data
SAP BW Schema
Open ODS View
Open ODS Open View ODS View
SDA
Transactional Data Master Data
S/4HANA Open CDS Views ( Interface Layer) S/4HANA System
SAP HANA
Recommendations / Findings for Integration Scenario A: HANA Smart Data Access & Modeling via Open ODS Views
Prerequisite: HANA Smart Data Access is configured in BW on HANA system and connects to S/4HANA system
Recommended to implement Open ODS Views based on S/4HANA ABAP CDS interface / reuse views
Distinguish between transactional and master data (attribute and text) views and create associations accordingly
Start with the Open ODS Views for master data (attribute and text), then proceed with transactional Open ODS Views
SAP Client needs to be added to the key of all Open ODS Views and needs to be uniquely filtered
Use BEx Query on top of Open ODS Views / Composite Provider to take advantage of full set of reporting features:
Restricted & calculated key figures
BEx variables e.g. hierarchy node variables
Exceptions and conditions
Currency conversion during report execution
Report-to-Report Interface, …
Open ODS View provides functionality to switch from virtual access to persistence. Generation of data flow with DataSource, DataStore object (Advanced) and BW Transformation (requires SAP BW 7.40 SP 8 or higher)
Integration Scenario B Modeling-free via ODP transient provider (only in embedded case) Consumption of SAP S/4HANA embedded analytics CDS views in SAP BW via ODP transient provider
From S/4HANA embedded analytics
From S/4HANA embedded analytics
Integration Scenario B Modeling-free via ODP transient provider (only in embedded case) Consumption of SAP S/4HANA embedded analytics Open CDS views in BW via ODP transient provider Use Cases
To simply display and use S/4HANA embedded analytics consumption / query views without any further investments
Mainly to leverage BEx capabilities and valid for embedded BW setup
S/4HANA
Generated ODP transient provider
Capabilities
BEx Query
All S/4HANA embedded analytics Open CDS views are automatically exposed as InfoProvider in BEx Query Designer
Supports BEx variables
Supports restricted key figures
Supports exceptions and conditions
Supports currency conversion
Supports BW Report-to-Report interface
Supports S/4HANA embedded analytics privileges
S/4HANA Open CDS Views ( Interface Layer) S/4HANA Schema
Not supported (Query not based on BW InfoObjects):
BW Hierarchies, node variables
BW analysis authorizations
SAP HANA
Recommendations / Findings for Integration Scenario B: Modeling-free via ODP transient provider (only in embedded case)
All S/4HANA CDS views are automatically exposed as a ODP transient InfoProvider and can be used in the BEx Query Designer to define custom queries
Quick way to add BW functionality without using BW modeling objects
It is recommended to implement BEx queries based on S/4HANA Analytics CDS consumption / query views
Input parameters / variables defined in S/4HANA embedded analytics CDS view must be defined in the Bex Query as static filter e.g. by a fix value or mandatory variable
BW analysis authorizations & BW hierarchies are not supported
BEx Queries created on ODP Transient Provider can be transported through the S/4HANA landscape, as the transient provider is generated with same technical name in all systems
Overview: SAP S/4HANA embedded analytics virtual data models and SAP BW powered by SAP HANA…
…complement each other
…can cover all analytic use cases on one data source
…together provide a comprehensive reporting platform
All described Integration scenarios will be further elaborated in our blog http://scn.sap.com/community/s4hana/blog/2015/11/23/unified-solution-saps4hana-embedded-analytics-sap-business-warehouse-powered-by-sap-hana and the respective how-to-guide: https://scn.sap.com/docs/DOC-68337
Best Practices
SAP Business Suite on HANA and SAP S/4HANA – S/4HANA – Business Content Suite on Hana:
S/4HANA
•
Traditional Traditional Business Content can be used (BI_CONT).
•
Short-term, existing extractors will be released, covering the scope of S/4HANA
•
Traditional Traditional Extractors will continue to be used
•
Mid-term, the extraction technology will be based on CDS Views. One technology for EDW and operational reporting
New HANA-optimized Business Content for BW was and is further planned to be created (using objects like Advanced DSO, HANA Composite Provider,…)
At-a-Glance: SAP Best Practices for analytics with SAP S/4HANA SAP Best Practices for analytics with SAP S/4HANA provides a comprehensive portfolio of analytical content based on SAP S/4HANA. It provides guidance on how to get started with SAP S/4HANA embedded analytics and how to integrate with best in class analytical platform and solutions from SAP for ex: SAP BI platform, SAP BW etc. Business Requirement What is my pain?
How to provide real time operational reports to the business users with SAP S/4HANA?
How to enhance productivity of business users by providing providing self-service BI with SAP BI platform based on SAP S/4HANA data.
How to provide transparency and reporting to the business users across different business applications by providing the consolidation of the data from SAP S/4HANA in central enterprise data warehouse with SAP BW platform.
What are my needs?
Solution Solution description SAP Best Practices for analytics with SAP S/4HANA provides a comprehensive solution with guidance and pre-built content on how customers can jump start with embedded analytics within SAP S/4HANA and how customers can build their analytical use cases by integrating with SAP BI, SAP BW etc.
In scope
Enable real-time operational reporting on SAP S/4HANA with embedded analytics.
Rapidly integrate SAP S/4HANA with best in class analytical solutions provided by SAP and get up and running with pre-built content built in SAP BI platform.
Set up of SAP S/4HANA Embedded Analytics with CDS views and various analytical apps based on CDS views.
Integration between SAP S/4HANA and SAP BI with pre-built reports and content.
Easily consolidate the data from SAP S/4HANA within SAP BW.
Integration between SAP S/4HANA and SAP BW with pre-built content.
Access the SAP S/4HANA data which which is exposed as CDS views views in a uniform way.
Learn more
Scope and benefits
Embedded Analytics with SAP S/4HANA
Jump start the implementation and activation of embedded analytics with SAP S/4HANA.
Enhance analytical use cases by integrating between SAP S/4HANA and SAP BI platform. Pre-built reports and content built in SAP BI client tools ex: Design Studio, Webi can be leveraged and extended based on business use cases.
Consolidate data from SAP S/4HANA in SAP BW and build analytical use cases based on enriched data environment from other data sources in SAP BW.
– set up of SAP S/4HANA Embedded Analytics with CDS views and various analytical apps based on CDS views.
Integration between SAP S/4HANA and SAP BI
Integration between SAP S/4HANA and SAP BW
Integration between SAP S/4HANA and SAP BI platform: Offerings Key functionality:
Pre-defined reports
-
Design Studio dashboards for Core-Finance scenarios
-
Design Studio dashboards for Procure-to-pay scenarios
-
Design Studio dashboards for Order-to-cash scenarios
-
Webi reports
-
Crystal Reports
Implementation of Analytics with SAP S/4HANA What’s included – Service scope
Embedded Analytics with SAP S/4HANA (mandatory) This scope option covers technical set up of CDS views for S/4HANA Analytics. After this is implemented, the customer can use S/4 HANA Embedded analytics.
Integration between SAP S/4HANA and SAP BI (optional): For several areas, like core finance or procure to pay, there is standard content available. This scope option covers the implementation and integration of one selected building blocks.
Integration between SAP S/4HANA and SAP BW (optional) This scope option is to inform and enable the
Service scope options A service scope option is a combination of scope t hat can be removed to reduce the service price.
Scope options
Required
Building Blocks / Functionality delivered
Embedded Analytics with SAP S/4HANA
Mandatory
BGE: Technical Setup for S/4 HANA Analytics
Integration between SAP S/4HANA and SAP BI (select 1 of the listed items)
Optional
BHC: Integration between BI Platform and Fiori Launchpad BHB: Analysis Reports for S/4 HANA On-Premise Edition: Core Finance BHG: Analysis Reports for S/4 HANA On-Premise Edition: Procure-to-Pay BGF: Analytical Report for S/4 HANA: Other repo rt types BHJ: Analysis Reports for S/4 HANA On-Premise Edition: Order-to-Cash
BGD: Integration scenarios between SAP S/4HANA and SAP BW
Integration between SAP S/4HANA and SAP BW
Optional
Partner’s scope of service may vary.
Integration points in scope
Integration point
From Product/ Solution
To Product/ Solution
Type
Description
Short description of integration point
From SAP product that integrates
To SAP product that integrates
Technical nature of integration e.g. ALE
Longer description of scope of integration perhaps covering business objects or data
S/4HANA – BI platform
S/4HANA
BI
Software Integration
Using BI Analysis reports in S/4HANA from BI (for example Design Studio). BHB: Analysis Reports for S/4 HANA On-Premise Edition: Core Finance BHG: Analysis Reports for S/4 HANA On-Premise Edition: Procureto-Pay BGF: Analytical Report for S/4 HANA: Other repo rt types BHJ: Analysis Reports for S/4 HANA On-Premise Edition: Order-toCash
S/4HANA – BW system
S/4HANA
BW
Smart Data Access, others
Master data, transaction data. Virtual or persistence access. Different scenarios supported: BGD: Integration scenarios between SAP S/4HANA and SAP BW
Project Team SAP project manager •
Serves as a central contact person, from project initiation to go-live and support. On the SAP side, responsible for functional project management, coordination, support, and coaching of the customer’s project manager, and so on
Core project team •
Application and Technology consultants. Particularly responsible for monitoring process configuration, know-how transfer, and so on
•
Functional department staff / key users Focus on leveraging knowledge gained from this project and share this within the organization. Gathered knowledge can be used as input for further decision making or input for a roadmap.
SAP consultants Business Process consultant, depending on the selected scope options knowledge of BW, Business Objects and/or Fiori is required. • Technology Consultant •
Responsibilities What does SAP do?
Prepare project
Confirm Installation
Project Kick-Off
Validation Workshop
Implement Customer Defined Options
What customer has to do?
Ensure prerequisites are met before start date of this service.
Prerequisites include software installation and hardware set up.
Configure Embedded Analytics
User interface is clear and agreed.
Set up of required security settings for integration
Optional: integration with Business Objects and the activation of reports of 1 selected building block. One of the available options is configuration of Fiori.
Inform stakeholders and ensure available of right resources at the agreed timings according to the project schedule during the course of this project
Confirm the selected options
Optional: integration with BW, including enablement
Validate and sign off deliverables
Validation of selected options
Documentation about applied configuration
Knowledge transfer
Partner’s scope of service may vary.
Summary and additional information
Analytics Solutions for SAP S/4HANA Key Take-Aways ■
■
■
SAP Business Suite 4 SAP HANA provides enhanced analytical capabilities due to the architecture based on SAP HANA – the value proposition gets enhanced by the unique possibilities given with the new architecture, including reimagined simplified business processes, user experience and business decisions Does not replace SAP HANA Live, SAP Business Warehouse or any other SAP analytics offering but complements and integrates with them SAP Cloud for Analytics completes the on-premise SAP Analytics suite with a new cloud deployment opportunity, combining all analytics capabilities in one product, leveraging S/4HANA in the same way as the on-premise analytics applications.
SAP Digital Boardroom
SAP Cloud for Analytics, SAP BusinessObjects BI, SAP Lumira
SAP SMART BUSINESS COCKPITS
OPERATIONAL REPORTS & VISUALIZATIONS
QUERY BROWSER
ANALYTICAL FIORI APPS
QUERY DESIGNER
SAP FIORI KPI MODELER
ABAP FOR ECLIPSE
SAP S/4HANA embedded analytics
Spend offcontract
Incoming Sales Order
PO Avg. Delivery Time
Non-managed purchasing spend
SAP S/4HANA Virtual Data Models
SAP BW on HANA
….
Metadata driven Analytic UIs: How Annotations translate to Business Semantics Definitions A KPI evaluates a one leading measure from an aggregated management perspective.
Annotations KPIs
- Selection Variant - Data Point
Reports
A Report is consumed by the end-user and is a simple table or chart based on multiple measures and dimensions. An Analytical Query prepar es the relevant columns and filters for analytical use.
- Selection Variant - Presentation Variant (e.g. UI.Chart, UI.Lineitem,..)
Analytical Query
Query Annotations for Analytical Engine CDS Annotations
Virtual Data Model Application Tables
SAP S/4HANA Enterprise Management
Cross Topics
Enterprise Technology
Cross Topics - Analytics Cloud and On Premise Edition
Cloud and On Premise Edition
Cloud and On Premise Edition
IT User • Maintain CDS views in ABAP for Eclipse
IT User • Create/extend CDS views
IT User • Create planning functions
Analytics Key User • Create new KPI Tiles using existing KPIs • Create Query Views
Analytics Key User • Manage report assignments • Create new KPIs
Analytics Key User • Define planning models
Analytics End User • Query Browser • Multidimensional reporting • KPIs, Smart Business Applications • Specific analytical apps (CEI, FIN) • Analysis for Office (on premise only) • Lumira (acquisition mode, on prem)
Analytics End User • Overview Pages • UI-Embedded Analytics • Analysis Path Framework Business Content • Further Views, KPIs, Reports to cover S/4 scope
Analytics End User • Excel integration • KPI&Report Gallery Business Content • Further Views, KPIs, Reports to cover S/4 scope
Business Content • ~ 2300 Open CDS Views • Reports: FIN, SD, CPM • KPIs: areas above + MM, PP
Solution today
Planned innovations
Future direction
HANA Live vs. S/4HANA embedded analytics
Additional helpful links SAP S/4HANA Landing Page: http://go.sap.com/product/enterprise-management/s4hana-erp.html Article on SAP Insider about SAP S/4HANA embedded analytics: http://go.sap.com/docs/download/2015/12/92865b4d-537c-0010-82c7eda71af511fa.pdf SAP S/4HANA FAQ: http://scn.sap.com/community/business-suite/faq/contentbzw.
SAP S/4HANA embedded analytics FAQ: http://a248.g.akamai.net/n/248/420835/c56a5b43b4f7b3942360af99933f52678d0528154abb3614d5d28a3f35b75c24/sapasset.download.aka mai.com/420835/sapcom/docs/2015/11/7e25a80f-507c-0010-82c7-eda71af511fa.pdf Positioning with SAP BW:
Blog: http://scn.sap.com/community/s4hana/blog/2015/11/23/unified-solution-sap-s4hana-embedded-analytics-sap-business-warehousepowered-by-sap-hana HTG for SAP S/4HANA Analytics & SAP BW Data Integration in SCN: https://scn.sap.com/docs/DOC-68337 ASUG Webcast S/4HANA embedded analytics and SAP BW: https://www.asug.com/events/detail/SAP-S-4HANA-Analytics-SAP-BW-DataIntegration-Overview
SAP HANA Academy Videos Playlist for S/4 HANA videos: S/4 HANA They cover these topics so far … Establishing CAL instance and setting up SAP ERP user Creating the ABAP Project and Loading sFLIGHT sample data Creating Basic and Interface Views using open CDS Creating Consumption Views using Open CDS Exposing and Viewing Open CDS using Odata Services
Thank you
Contact information:
[email protected] [email protected]
ABAP Open CDS versus HANA Calculation Views Delta Comparison ABAP Open CDS Open SQL
ABAP in Eclipse Editor
HANA Live (Calculation Views) HANA SQL / SQL Script / CE Functions
HANA Studio - graphical modeler - text editor for script-based calculation views
associations and path notation - views contain elementary fields and associations to other views providing additional fields
no associations - views contain superset of all potentially necessary fields - many joins to collect all fields (at runtime calc model is again reduced to necessary nodes)
SQL statement directly executed by SQL engine - SQL optimizer has to be intelligent enough to avoid reading unnecessary data (e.g. ignore left outer join with cardinality *:1 if no data requested)
pre-processing of select statement by calc engine - dynamic reduction of calc model based on selected columns
pure SQL semantics - non-SQL-like calculations performed by Analtic Engine
‚template semantics‘ - dynamic adjustment af aggregation levels based on selected columns
sub-selects currently not supported within the same CDS view
sub-selects supported within the same calc model
embedded into ABAP software logistics
embedded into software logistics for HANA content - difficult to synchronize with ABAP shipments - different package concept (package = namespace)
embedded into ABAP user management
HANA user required - must be identical to ABAP user (no user mapping)
views belong to ABAP DB schema
views belong to SYS BIC schema and are linked to only
3 KEY LEARNING POINTS • What is SAP S/4HANA embedded analytics and what are the main use-cases SAP has in mind for it? • How does SAP S/4HANA embedded analytics relate to SAP Business Warehouse powered by SAP HANA • How do the 2 solutions integrate?
