SAP S/4HANA Embedded Analytics : Experiences in the Field

Imagine you are a business user, consultant, or developer about to enter an SAP S/4HANA implementation project. You are well-versed with SAP's product portfolio and you know that the preferred reporting option in S/4HANA is embedded analytics. But what exactly is embedded analytics? And how can it be implemented? And who can do it: a business user, a functional consultant specialized in financial or logistics processes? Or does a business intelligence expert or a programmer need to be involved? Good questions! This book will answer these questions, one by one. It will also take you on the same journey that the implementation team needs to follow for every reporting requirement that pops up: start with assessing a more standard option and only move on to a less standard option if the requirement cannot be fulfilled. In consecutive chapters, analytical apps delivered by SAP, apps created using Smart Business Services, and Analytical Queries developed either using tiles or in a development environment are explained in detail with practical examples. The book also explains which option is preferred in which situation. The book covers topics such as in-memory computing, cloud, UX, OData, agile development, and more. Author Freek Keijzer writes from the perspective of an implementation consultant, focusing on functionality that has proven itself useful in the field. Practical examples are abundant, ranging from "codeless" to "hardcore coding." What You Will Learn Know the difference between static reporting and interactive querying on real-time data Understand which options are available for analytics in SAP S/4HANA Understand which option to choose in which situation Know how to implement these options Who This Book is For SAP power users, functional consultants, developers Table of Contents About the Author About the Technical Reviewers Acknowledgments Introduction Chapter 1: Before the Work Starts Business Intelligence: The Art of Enriching Data Data Modeling for Dummies Where Are the Numbers? Layered Approach Operators for Data Integration HANA Changing the OLTP vs. OLAP Game Cloud Flavors: SaaS vs. IaaS Front End: Fiori and UI5 SAP’s BI Portfolio The Latest Thing: CDS Views S/4HANA Embedded Analytics Chapter 2: No Work: Use What Is Delivered Which Tiles Are Shown, and How Are They Grouped? Discover Analytical Apps Activate Them Use Them Export to Excel...Please Don’t Retrospective Chapter 3: Some Work: Smart Business Service Demo Retrospective Chapter 4: More Work: Building Analytical Queries Using Tiles Discovery of SAP-Delivered CDS Views with Tiles View Browser and Query Browser Custom Analytical Query in an Almost Ideal Situation: Part 1 Custom CDS View in an Almost Ideal Situation Custom Analytical Query in an Almost Ideal Situation: Part 2 Custom CDS View in a Not-So-Ideal Situation Transporting Custom CDS Views and Analytical Queries Retrospective Chapter 5: Most Work (Basic): Building Analytical Queries in an IDE Getting Started with an IDE Naming Convention for CDS Views Documentation and Data Lineage Getting Started with ABAP CDS Embedded Analytics from Scratch: Requirements and Data Model Embedded Analytics from Scratch: Basic Views Embedded Analytics from Scratch: Data Integration Embedded Analytics from Scratch: Cube View Embedded Analytics from Scratch: Query View and Final Result Retrospective Chapter 6: Most Work (Advanced): Building Analytical Queries in an IDE Custom Master Data Views Custom Text View Custom Attribute View Complex Logic Transposition from Columns to Rows Transposition from Rows to Columns Homework! Using Parameters Using Session Variables and Environment Annotations Compatibility Views Author-Delivered Content Material Classification Characteristics Flattened Hierarchies Inventory Levels and Movements Financial Actuals, Plan, and Commitments Making the Data Less Real-Time Multilingual Descriptions of Field Names “Jump To” Functionality Creating a Dedicated Tile for a Query Data Authorization Query Performance Performance Analysis Performance Optimization Transporting CDS Views Analysis for Office Topics Not Covered by This Book...for a Reason Retrospective Chapter 7: Extensibility, OData, and Beyond S/4HANA Extensibility APIs and OData Services How to Turn a CDS View into an OData Service Agile Development and Business Intelligence DevOps and Business Intelligence Ideal Skill Set for an Embedded Analytics Expert Epilogue Index