1201 asug - operational analytics for apo powered by sap hana
DESCRIPTION
Operational Analytics for APO powered by SAP HANATRANSCRIPT
-
Operational Analytics for APO, powered by SAP HANA
Eric Simonson Solution Management SAP [email protected]
-
Agenda Solution Overview
Data Replication
Solution in Detail Demand
Solution in Detail Supply
Roadmap
-
Solution Overview
-
Value Proposition
Better decision making with near real-time information
Ability to quickly analysis relevant planning situations at multiple levels of aggregation
Visibility into key Supply Chain Planning data in an easily consumable way
Less time spent compiling, generating, and waiting for reports
-
Solution
y Out of the box analytical reporting with streamlined data load. Decision support based on near real time information.
y Pre-defined dashboards for different use cases (analytical workflows) for APO based planning scenarios.
y Use cases based on best practices for operational reporting on APO data leveraging the full potential of HANA
Key Benefits
y Reporting on data aggregates possible e.g. grouping by product family.
y Increased performance for APO analytics by order of magnitudes allows close to real time reportingy Highly attractive, user friendly UI Design y Simplified approach for operative reporting (e.g. no BW reporting framework)
New analytical capabilities on APO data residing in SAP HANA
-
Supports the demand planner with indicators on the quality and reliability of the forecast on all possible levels Informs the demand planner about the forecast accuracy over time in
order to understand patterns
Forecast Accuracy
Supply Projection
Supports the supply planner to measure the quality of a plan Supports the supply planner to identify bottlenecks supporting supply
chain improvement objectives
Stock Coverage
Supports the supply planner to understand inventory on different levels and locations in the supply chain Provides inventory information based on future demand and supply
Use Cases
-
Data Replication
-
Deployment options for Supply Chain Info Center
SAP APOwith SAP HANA Side-by-Side
SAP APOon SAP HANA data base
Live Cache
SCM Server
SCM Basis
SNC
APO
HanaDB
Analytics
VDM
Live Cache
SCM Server
Classical DB
SCM Basis
SNC
APO
HanaDB
Analytics
VDM
Full and delta replication of APO data for snapshot and near to real time Analytics
SLT
Replication
LC replication LC replication
-
Create a Replication Model 1 / 2
Call transaction Replication Model Maintenance (/SAPAPO/REPL_MODEL)
Click on the 'New' button to create a new Replication Model
The list shows you already existing and active Replication Models
-
Create a Replication Model 2 / 2
A new window Replication Model will be opened.
y Enter Replication Model ID and Description.
y Select your planning book, data view and planning version.
y Secondary Database Connection: APO_REPLICATION
y Map the corresponding key figure semantics to determine which KF in Apo map to the KF in HANA.
y Specify a selection ID from your DP/SNP Planning Area to replicate relevant products
y Enable replication model for DELTA replication
-
Activation of the Replication Model
y Select the formerly created replication model in the list and click on the 'Activate' button.
y Note: It is not possible to have several active Replication Models with the same settings. In this case you get an Information during activation.
-
Example of an Activated Replication Model
-
Replicate Planning Data to SAP HANA System
Call transaction /SAPAPO/REPL Replication of Planning Data to SAP HANA in your Planning System
Enter your formerly created Replication Model.You can use Parallel Processing and choose if you want to save Application Log.
Start the Replication.
-
You can use Parallel Processing and choose if you want to save Application Log.
Start the Replication.
Call transaction /SAPAPO/REPL_DELTA in your Planning System
All logged changes are processed for selected Planning Version
Replicate Planning Data to SAP HANA System
-
Simply schedule the delta replication report as a batch job running periodically (e.g. every minute)
Replicate Planning Data to SAP HANA System
-
Solution In Detail - Demand
-
Demand Planning Use CasesU
se c
ase Forecast Accuracy
(covered in version 1)Current Consumption(Planned for future)
Demand Waterfall Analysis (Planned for future)
Desc
riptio
n Analyse forecast quality of your products. See trends and take actions.
Compare forecast vs. sales orders and see deviations from plan.
See how demand is developing over time.
Bene
fit
Better insight leads to more accurate demand forecast. Ability to do dynamic accuracy calculations at any level.
Gives you up to date view on current forecast/consumption situation.Allows quick response to demand changes.
Analyze forecast stability for Demand Planning. Visual Notification of forecast changes outside of threshold.
Leve
r Insight Agility Insight
-
Forecast Accuracy Introduction
Focus on past forecasting performance Supports the demand planner with indicators on the quality and reliability of the forecast
on all possible levels
Informs the demand planner about the forecast accuracy over time in order to understand patterns
Supports the demand planner to evaluate forecasts on different levels Offered KPIs are focused on past forecasting performance
-
Forecast Accuracy Overview Screen
Overview Tab selectedSelection Area - Limits characteristics to view data
Configurable KPIs - Absolute Numbers and Percentage
Historical View of Forecast accuracy
Selectable KPI charts. Set via Overview Settings
-
Forecast Accuracy Drill-Down View
Select the charts to be displayed
Configure the Pie Chart
Select the characteristics by which you want to drill-down on your data
Drill-Down tab selected
Drill-Down View selected
-
Forecast Accuracy Detailed View
Select the Key Figures you want to display in the chart.
Choose whether you want to display lines or bars in the chart
You can shift the time horizon simply by dragging the bar
You can select the items to analyze manually, or just double click them on the Overview Screen to come here automatically
Detailed tab selected
Drill-Down View selected
-
Demand Planning Forecast Accuracy KPIs
Forecast Error (MAPE)
Weighted Forecast Error (Volume Weighted MAPE)
Forecast Accuracy (based on MAPE)
Weighted Forecast Error (based on Volume Weighted MAPE)
Bias (MPE)
Link to online helpOSS Note 1792742 for Calculations
-
Solution In Detail - Supply
-
Supply Network Planning Use CasesU
se c
ase Supply Projection
(covered in version 1)
Capacity Analysis(Planned for version 1.5)
Stock Coverage (covered in version 1)
Supply Waterfall Analysis (Planned for future)
Desc
riptio
n Analyse projected service level or shortage for your products in top-down way.
See capacity load across the supply chain and get insight on consuming products.
Analyse inventory development over time with value, quantity or days supply based KPIs
See how supply is developing over time.
Bene
fit
Aggregated view allows faster decision making.Ability to drill into the details.
Enhanced visibility allows better capacity utilization.Aggregation and drilldown to analyse consumption by product group or SKU.
Allows fast response to inventory shortfalls or surplus.Quickly identify target and safety stock deviations.
Analyze supply plan stability for supply planning. VisualNotification of distribution/production changes outside of threshold.
Leve
r Agile Agile Agile Insight
-
Supply Projection Introduction
Focus on Projected Future Demand Fulfillment Supports the planner to measure the quality of a plan Supports the planner to identify bottlenecks supporting supply chain improvement
objectives
Supports the planner to evaluate a supply plan created by APO with predefined KPIs Offered KPIs are focused on providing a forward-looking perspective
-
Supply Projection Overview Screen
Selection Area - Limits characteristics to view data
Configurable KPIs - Absolute Numbers and Percentage
Projected Service Level chart
Overview Tab selected
Selectable KPI charts. Set via Overview Settings
-
Supply Projection Drill-Down View
Select the KPI charts to be displayed
Drill-Down tab selected
Drill-Down View selected
Select the characteristics by which you want to drill-down on your data
-
Supply Projection Detailed View
Select the Key Figures you want to display in the chart. These can be custom KFs from APO macros.
Detailed View Settings selected
Choose whether you want to display lines or bars in the chart
You can shift the time horizon simply by dragging the bar
You can select the items to analyze manually, or just double click them on the Overview Screen to come here automatically
Detailed View tab selected
-
Supply Projection KPIs
Demand Under Coverage %
Demand Under Coverage Absolute
Supply Shortage (# of Location Products)
Supply Shortage %
Projected Service Level
Link to online helpOSS Note 1792742 for Calculations
-
Stock Coverage Introduction
Focuses on Stock Situation Supports the planner to understand inventory on different levels and locations in the
supply chain
Provides inventory information based on future demand and supply Supports the planner to find the right balance between service level and inventory
-
Stock Coverage Overview Screen
Days Supply chart or Supply Projection chart
Overview Tab selectedSelection Area - Limits characteristics to view data
Configurable KPIs - Absolute Numbers and Percentage
Selectable KPI charts. Set via Overview Settings
-
Stock Coverage Drill-Down View
Select the KPI charts to be displayed
Drill-Down tab selected
Drill-Down View selected
Select the characteristics by which you want to drill-down on your data
-
Stock Coverage Detailed View
Select the Key Figures you want to display in the chart. These can be custom KFs from APO macros.
Detailed View Settings selected
Choose whether you want to display lines or bars in the chart
You can shift the time horizon simply by dragging the bar
You can select the items to analyze manually, or just double click them on the Overview Screen to come here automatically
Detailed View tab selected
-
Stock Coverage KPIs 1 / 2
Average Days Supply
Projected Stock on Hand
Projected Stock Value
Stock Below Safety Stock (Absolute in UOM)
Stock Below Safety Stock (# of Location Products)
Stock Below Safety Stock (% in Location Products)
Stock Above Safety Stock (Absolute in UOM)
Stock Above Safety Stock (# of Location Products)
Stock Above Safety Stock (% in Location Products)
-
Stock Below Target Stock (Absolute in UOM)
Stock Below Target Stock (# of Location Products)
Stock Below Target Stock (% in Location Products)
Stock Above Target Stock (Absolute in UOM)
Stock Above Target Stock (# of Location Products)
Stock Above Target Stock (% in Location Products)
Link to online helpOSS Note 1792742 for Calculations
Stock Coverage KPIs 2 / 2
-
Supply Chain Info Center Demonstration
Internal Link
External Link
-
Roadmap
-
Legal Disclaimer
The information in this presentation is confidential and proprietary to SAP and may not be disclosed without the permission of SAP. This presentation is not subject to your license agreement or any other service or subscription agreement with 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 on this document is not a commitment, promise or legal obligation to deliver any material, code or 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, 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, and shall have no liability for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the use of this document. This limitation shall not apply in cases of intent or gross negligence.All forward-looking statements are subject to various risks and uncertainties that could cause 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.
-
Roadmap - Supply Chain Info Center
~6 mo.ReleaseCycles
Forecast Accuracy Analytics
Supply Projection Analytics
Stock Coverage Analytics
Dec 17th 2012
Supply Chain Info Center 1.0restricted shipment - for APO 7.02, can go live
Innovation Accelerators (TBD)
Capacity Analytics
Demand & Supply Waterfall Analytics
Current Consumption Analytics
Beginning Q3 2013 (July-August)
Supply Chain Info Center 1.5
Q1 - 2014
Roll-Over Use Cases
PP/DS Use Cases
Additional Innovation Accelerators
Supply Chain Info Center 2.0
Feb 2013
Deployment option Analytics + SCM on HANADeployment option Analytics Side by Side
Supply Chain Info Center 1.0restricted shipment - for APO 7.0 and 7.01, can go live
Ramp Up DatesRamp Up Dates
Please note: Dates are subject to change and may not require Ramp-Up
-
Innovation Accelerators
KPI Framework
Customer Definable Dashboards
Download to Excel
Selection IDs from APO
Insight-to-Action Navigation
Value Based Selection Concept
; View data on aggregates, by different time buckets and product groups
; Supports Custom specific Key Figures and characteristics without any development effort
; Pre-delivered KPIs by module
; Personalization features
; Covered in version 1.0
Planned for version 1.5
-
Where to Find More Information
service.sap.com/rkt-scm *service.sap.com/rkt-scm *
Keep in mindKeep in mind
http://wiki.sdn.sap.com/wiki/display/SCM/SAP+SCM http://wiki.sdn.sap.com/wiki/display/SCM/SAP+SCM
service.sap.com/rampup *service.sap.com/rampup *
sap.com/scmsap.com/scm
* Requires login credentials to the SAP Service Marketplace
-
Learning Points
1. SAP Supply Chain Info Center is now available for APO customers, and is licensed separately
2. The KPI Framework will be extended in Version 1.5 as well so you can configure your own KPIs and calculations
3. Additional Use Cases are planned to be developed for future Supply Chain Info Center releases
4. Delta replication is supported
5. Analytics displayed via HTML5 dashboards, and move quite fast
6. More detailed information can be found on the SAP Service Marketplace for SCM
-
THANK YOU FOR PARTICIPATING
Please provide feedback on this session by completing a short survey via the event mobile application.
SESSION CODE: 1201
For ongoing education on this area of focus,visit www.ASUG.com