SAP BPC Optimized or SAP BPC 11 - Which one to choose

A deep view of the characteristics of the Optimized version (S/4HANA) and the 11 version (BW/4HANA) for SAP BPC. Find out which one to choose for your company.

Transcript

1. SAP BPC Optimized vs 11 Which one to choose?
4. INTRODUCTION • What is SAP BPC • Environment • Standard • Embedded • Evolution SAP BPC 11 • General Landscape • Analytics • Recap SAP BPC Optimized • General Landscape • Financial Accounting • Types of Planning • Universal Journal • Hard Closing vs Soft Closing • RTC • Analytics • Forecast • Recap
5. PLANNING • Annual Budgeting • Sales / revenue planning • Capital expenditure planning • Headcount /staffing • Expenses planning • Cash Flow planning FORECASTING • Rolling forecast • Integrated financial statement modeling • P&L • Balance sheet • Cash Flow • Scenario modeling CONSOLIDATION • Intercompany matching /reconciliation • Intercompany eliminations • Management consolidation and reporting • Legal /statutory consolidation • Data mapping / submission FINANCIAL REPORTING & ANALYSIS • Ad hoc reporting • Variance analysis • Driver analysis (industry, growth, capacity, etc.) • Root cause analysis.
7. SAP BPC Standard SAP HANA SAP BW • Single Key Figure • Star Schema Tables • Logics (Business Rules, BAdIs, Member formulas, script logics, BEx, SQE) Calculation Engine Modelling Model Dimension BPC Infoprovider InfoObject BW
8. SAP BPC Embedded SAP HANA SAP BW • Multiple Key Figure • Logics (Business Rules, BAdIs, FOX) Calculation Engine Modelling Aggregation Level BPC Infoprovider InfoObject BW BW-IP PAK
9. FEATURE STANDARD EMBEDDED Implementation Effort Easier Interface A bit more complicated Master Data BPC BW Key Figures Single key figure model Multiple key figure model Time Dependent Attribute Not Yes DSO Planning Not Yes Logic Business Rules Business Rules Script Logics (Custom Logic & BAdI) BAdI (1) SQE FOX BEx Query BEx Query* Dimension member formulas Excel EPM Add-in (Easier) Analysis for Office Add-in (Requires queries) YTD, QTD,and Custom Time Measures Delivered Built in underlying query Account Logic Built-in reporting via EPM basedon Account type Account logic for AST,LEQ, EXP and INC needs to be built in query HANA integration Some Native HANA calculations PAK provides significant HANA integration incuding FOX and SQL *BEx is not supported by BW/4HANA but it can be used by the BI Tools
10. SAP BW/4HANA SAP HANA SAP BPC 11.0 SAP BPC Embedded BW-IP/PAK SAP HANA SAP NW *SAP BW Embedded* SAP BPC Standard SAP BPC Optimized SAP BPC Optimized Standalone SAP BPC Standard SAP BPC for S/4HANA SAP BPC for BW/4HANA SAP BPC Embedded BW-IP/PAK
11. • Raw Data • Cleaned & Validated • Reports • Predictive Analytics • Agile Visualization • Forecast • Prescriptive Analytics
13. SAP S/4HANA Simple Finance SAP BPC SAP Netweaver SAP HANA SAP Accounting SAP Cash Management Planning Engine Planning Data SAP S/4HANA CORE SAP BW Embedded SAP BPC Embedded SAP BPC Optimized SAP BPC Optimized Standalone SAP BPC Standard BW-IP/PAK
15. General Ledger Profitability Analysis Management Accounting Asset Accounting Material Ledger
16. ✓ RTC ✓ During month ✓ Real Time Information & Analysis ✓ Embedded or Standard ✓ End of month *Images owned by SAP
17. ACDOCA : Universal Journal ACDOCC : Consolidation Journal ACDOCP : Planning Journal
18. ✓ Directly or Indirectly affects SAP BPC ✓ Advanced Analytics thanks to Universal Journal ✓ Predictive Analytics thanks to Machine Learning
19. ✓ Predictive accounting Bottom-Top Prediction (Individual Business Processes) Affects other financial areas Ex: Insights from expected revenue and expected expenditures
20. ✓ Real Time Consolidation • Reduce end of month clossing times • Improve decission taking due to advanced central results ✓ Analytical Improvement • Universal Journal • Machine Learning of SAP HANA • Machine Learning of SAP Leonardo ✓ Planning wider structure • Integration with other modules (FI, CO, CO/PA,…) ✓ Forecast
22. SAP BW 7.5x SAP HANA SAP BPC 10.1 Standard Embedded BW-IP PAK Client SAP BW/4HANA SAP HANA SAP BPC 11.0 Standard Embedded BW-IP/PAK Client
23. SAP HANA AFL EIM SAP BW/4HANA Application Analytical Manager Data Warehousing Tools Developer SAP BW/4HANA Modeling Tools SAP HANA Modeling Tools SAP BPC SAP Analytics 3rd parties Standard Embedded Cloud SAP BI Great integration with external data sources. • SAP Data • Non-SAP Data • Files • Big Data BW/4HANA • Modeling Tool replaces RSA1>Modeling • Elements simplification Analysis improvement • SAP HANA – AFL Non-SAP Data Text E-mail RDBMS/Hadoop Social Media Structured Big Data HIVE SPARK VORA Hadoop Files SAP Data Extractors SLT ABAP CDS BW Business By Design
24. Plan in the moment by leveraging data • Sources from SAP • Third-party • Geo-spatial • Hadoop • Others Better decisions analyzing both structured and unstructured data as part of the planning process Enhance data with Advanced Analytics using HANA specific libraries (AFL), R-Script or a custom HANA procedure • Predictive • Text Analysis • Data Mining • Machine Learning SAP BW/4HANA
25. ✓ Integration with external data sources. ✓ Available Standard & Embedded versions. ✓ Improvement of reporting (several queries for one report). ✓ Simplification of BW objects ✓ New friendly Eclipse interface for the BW Modelling design. ✓ Push-down to HANA, the logics used (Machine Learning, Text Analysis, Data Mining, Predictive, Formula Calculations, FOX calculation).
27. SAP S/4HANA SAP BPC Optimized (RTC) SAP BPC 11 Standard SAP BPC 11 Embedded Implementation Effort Higher Easier Higher Data Model Master Data BW BPC BW Data Replication BW to BPC Tables Schema 2 Tables Paradigm Star Schema 2 Tables Paradigm Account Based x Key Figures Multiple Single Multiple Time Dependant Attribute x x SAP BW Version SAP BW 7.5 Embedded BW/4HANA BW/4HANA SAP BW Objects 10 4 4 External Amount Data < 20% of the Total x x Integration FI,CO,CO/PA,… x BW folder ~ /CPMB/~ ~ Custom code and formulas Dimension Formulas x Script Logics (LGF) x BAdIs x(1) x x(1) SQE x Business Rules x x x FOX x x BEx* x *BEx is not supported by BW/4HANA but can be used in Analysis for Office SAP BW/4HANA
28. SAP S/4HANA SAP BPC Optimized (RTC) SAP BPC 11 Standard SAP BPC 11 Embedded Reporting - Excel Analysis for Office Add-in EPM Add-in Analysis for Office Add-in SAP Fiori x SAP GUI x x x Web BPC Console x x x BW/4HANA Modeling Tool x x HANA Modeling Tool x x x Planning Engine IP BPC IP Consolidation Engine BPC BPC BPC Real Time Consolidation x SAP BW/4HANA
29. Not Specified Specified End of Maintenance 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 SAP HANA Platform Edition 2.0 SAP S/4HANA 1809 SAP Netweaver 7.5 SAP BW/4HANA 2.0 SAP BPC 11 (for SAP BW/4HANA)
30. ✓ Uses SAP BW 7.5 Embedded in S/4HANA ✓ Standard, Embedded & Optimized BPC ✓ Business Oriented > ERP (HR, Logistics, Finance) ✓ Embedded Analytics ✓ Machine Learning improvement ✓ Forecast Functionalities ✓ Uses BW/4HANA ✓ Standard & Embedded BPC ✓ World Wide Data Integration ✓ Machine Learning & Big Data with Planning ✓ Sooner End of Maintenance Focus on company daily issues and ‘short’ future. Focus on a bigger picture.
33. SAP S/4HANA + SAP Leonardo = SAP Cash Application Finance Machine Learning Foundation Automate payment and invoice matching. SAP S/4HANA + SAP Leonardo = Contract Consumption Sourcing and Procurement SAP HANA Predictive Analytics Proactively renew contracts by predicting their expiration and consumption. SAP S/4HANA + SAP Leonardo = Stock in Transit Material Management SAP HANA Predictive Analytics Mitigate production risks by forecasting stock in transit delays. SAP S/4HANA + SAP Leonardo = Remittance Advice Extractor Finance Machine Learning Foundation Extract payment info form unstructured documents to automate clearing process. SAP S/4HANA + SAP Leonardo = SAP Business Integrity Screening Finance SAP HANA Predictive Analytics Increase accuracy of fraud alerts with predictive analytics. SAP S/4HANA + SAP Leonardo = SAP Predictive Maintenance Asset Management IoT Application Enablement by SAP Data Science Services Avoid unplanned machine downtime and reduce maintenance costs.
36. REACH ME