Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

SAC Planning & Reporting - Complete Hands-On Training

Name: SAC Planning & Reporting - Complete Hands-On Training
Rating: 4.6 (623 reviews)

SAC Planning & Reporting - Complete Hands-On Training based on real-customer scenario of P&L (income statement) planning

Created byDebanshu Mukherjee

Last updated 3/2026

English

German [Auto],English [Auto],

What you'll learn

Build an end-to-end SAC Planning & Reporting Application for FP&A - P&L planning customer scenario
Complete hands-on based step-by-step instructions for modeling, reporting and planning in SAC
Integrate S4HANA master and transaction data CDS Views using oData services and extract the attributes, text, hierarchies and transaction data into SAC planning
Learn all the basic planning features such as Version Management, Disaggregation, Data Locking, Data Actions, Multi Actions, Allocations and Currency Conversion
Learn all the advanced planning features such as VDTs, Rolling Forecast Layout & Calendar Functionality
Learn all the basic Reporting functionalities such as ODEs, Input Controls, Story filters, Linked Analysis, Geo Maps, Blending, Sorting and Ranking
Learn all the Advanced Reporting functionalities such as Variance analysis, Reference Lines, Conditional Formatting, Calculated and Restricted measures
Learn about Live data connectivity between BW4HANA and SAC, S4HANA and SAC, Native HANA and SAC
Learn about complex advanced-formula based data actions to achieve complex business requirements
Interview Preparation Tips & tricks to excel any technical or managerial SAC interview
Learn all the modeling aspects of both Analytic and Planning models such as private vs public dimensions, calculated dimensions, inverse formula and migration

Course content

45 sections • 121 lectures • 82h 21m total length

Consolidated Notes - OneNote notebook0:06
Consolidated Notes - PDF0:07
Hands-On - Exercise Files, including customer scenario files0:05
Other Materials0:04

S1 - Part 1 - Welcome & Introduction to SAC- Logistics57:49
Learn the SAC Planning & Reporting batch logistics, with 12 weekend sessions, access to SAC, S4HANA and BW for HANA, recordings, Q&A, and hands-on end-to-end planning.
S1 - Part 2 - Welcome & Introduction to SAC - Main Content52:56
SAC is a cloud-based SAP analytics tool for planning and reporting, delivering live SAP reporting, write backs, and augmented analytics through quarterly updates.

S2 - Part 1 - SAC Architecture & Connectivity - Theory - Part 156:45
Explore the SAP Analytics Cloud architecture, connectivity options, and workflow—from source connections to models and stories—covering live vs import data, licenses, and basic terminologies.
S2 - Part 2 - SAC Architecture & Connectivity - Theory - Part 244:21
Compare live connections and data acquisition in SAC, showing when real-time data is preferred and how metadata defines the model. Explore planning licensing, data limits, and widget customization with JavaScript.
S2 - Part 3 - SAC Architecture & Connectivity - Hands-On31:19
Log into the SAS planning tenant, load a flat file, build a new analytic model with dimensions and measures, then create a responsive story with a table and chart.

S3 - Part 1 - Connections in SAC29:11
Discover SAC connections, including live vs import data, on-prem and cloud sources, and the basics of BTP licensing and modeling concepts, data sets vs models.
S3 - Part 2 - BTP Introduction & Concepts36:07
SAP business technology platform (BTP) combines application development, automation, integration, data and analytics, and AI on a single cloud platform hosted by hyperscalers such as AWS, Azure, and Google Cloud.
S3 - Part 3 - SAC basic modeling concepts, Datasets in SAC1:10:31
Learn SAC basic modeling: define dimensions and measures, explore master data and transaction data, and distinguish analytic from planning models, plus embedded and public data sets.

S4 - Part 1 - Connections - Deep Dive45:40
Explore how live and import data connections power SAC models, compare account-based and measure-based analytic models, and review cloud connector setups for on-prem and cloud SAP landscapes.
S4 - Part 2 - Model Types - Account-based vs Measure-based41:42
Compare analytic and planning models in SAP S/4HANA, distinguishing old account-based from new measure-based models, and learn why a measure-based hybrid with an account dimension enables hierarchies and migration.

S5 - Part 1 - Dataset Conversions12:54
discover how embedded data sets convert to public data sets or models, why public data sets cannot convert to a model, and how ode and cd support these conversions.
S5 - Part 2 - Dimension types - Public vs Private46:40
Explore dimension types in SAC, comparing public versus private dimensions and master data versus transaction data; public dimensions are reusable across models and loaded via separate import jobs.

S6 - Part 1 - Dimension Properties28:16
Explore public vs private dimensions in SAC planning, focusing on organization, generic, and account types, and how system or user managed properties shape currency and access.
S6 - Part 2 - Dimensions and Import job - Hands On35:34
Create a Google Drive–based import data model in SAC, connect to cloud sources, configure date dimensions, and schedule automatic daily imports for planning and reporting.
S6 - Part 3 - Private to Public dimension conversion - Hands On30:39
convert a private to a public dimension in SAC, generate its public table, add to the model, and ensure referential integrity by loading master data before transactions.

S7 - Part 1 - Hierarchies in SAC - Theory - Part A52:27
Explore hierarchies in SAC, focusing on account dimension roles and level-based and parent-child structures. Learn about properties, default hierarchies, and how these hierarchies are created and used.
S7 - Part 2 - Hierarchies in SAC - Theory - Part B28:01
Master level-based and parent-child hierarchies in SAC, including fixed levels, properties, and orphan handling. Learn about loading hierarchies from flat files or sources and using not in hierarchy options.
S7 - Part 3 - Hierarchies in SAC - Hands On24:28
Learn to build level hierarchies for a product id dimension in SAC, map properties, schedule daily loads, and visualize hierarchies in a story with category and type levels.

S8 - Part 1 - Hierarchies in SAC - Deep Dive - Theory1:06:05
Explore SAC hierarchies: level-based versus parent-child, how public dimensions and data sets handle them, and derive product class with smart transformations for clean loading from google drive.
S8 - Part 2 - Hierarchies in SAC - Deep Dive - Hands On40:52
Explore hierarchies in SAC planning & reporting with a hands-on deep dive into loading attributes, descriptions, and parent-child versus level-based hierarchies, with dependencies.

S9 - Part 1 - Account Dim hierarchies & Calc Accounts - Part A1:08:23
Examine level-based and parent-child account hierarchies, orphan handling, and multiple account dimension hierarchies for financial statements; learn to build classic and mixed SAC models with public dimensions using Excel data.
S9 - Part 2 - Account Dim hierarchies & Calc Accounts - Part B56:40
Build an account dimension with multiple hierarchies, load master data from Google Sheets, define parent-child structures, map in data management, and create calculated accounts for planning.

Requirements

No programming skills or functional knowledge required. You will learn from the very basics step-by-step

Description

SAC Planning & Reporting - Complete Hands-On Training based on real customer scenario of P&L (income statement) planning

This course will take you from zero to hero with a detailed hands-on scenario in SAC planning using one of the most frequently used planning scenarios - P&L (Profit & Loss, a.k.a Income Statement) planning.

This is not a theoretical PPT-only driven training, but rather an end-to-end customer scenario-driven, completely hands-on course.

After attending this training, you will also be able to take your certification with confidence and crack interviews.

This training covers, in detail (hands-on) all the important SAC modeling, reporting & planning concepts:

SAC tool - look and feel
SAC connectivity with SAP and Non-SAP sources.
SAC Modelling Fundamentals - Public dimension, Private dimension, Hierarchies, Properties and much more.
Datasets in SAC and their usage.
Types of models in SAC (Analytic, Planning, Classic vs New measure-based) and the creation of each of these models from scratch.
Migration of classic models to new measure-based models.
Designing SAC stories using the GDrive flat files.
Basic and Advanced reporting functionalities in SAC Stories, such as blending, input controls, Geo-maps, and R-script-based widgets.
Creating Composites in SAC.
Creating all types of calculated and restricted measures in SAC.
Connecting SAC to S4HANA via oData services generated out of SAP Stnd CDS Views.
End-to-end planning of the customer scenario of P&L planning.
Creating FSV and S4HANA and loading data into SAC public dimensions.
Loading hierarchies from S4HANA to SAC public dimensions.
Loading transaction data from S4 CDS Views (oData service) to SAC planning model.
Creating planning input templates.
Creating Planning versions (public and private) using Version Management.
Creating Data Upload triggers in SAC planning for easy upload of forecast data.
Creating Data Actions using the advanced formula for a complex scenario.
Debugging data actions using the Tracing functionality.
Creating Multi actions in SAC.
Creating Data Locking to safeguard planning versions from modifications.
Creating workspaces in SAC for better content and security management.
Creating rolling forecast layouts in SAC planning input templates and reports.
Creating Allocations in SAC planning.
Creating simple and complex currency conversions in SAC.
Creating VDTs (Value Driver Trees) in SAC.
Creating Calendar tasks and using the calendar automation feature in SAC.
Creating the final report in SAC and concluding the end-to-end planning application.
Creating transport routes in SAC using the content network.
Business Content installation in SAC.

Who this course is for:

All levels of BW developers.
All levels of SAC developers, including those who're just starting or have no idea about SAC
All levels of HANA modelers and developers
Anyone who's interested to learn SAC from scratch and have no technical background
All seasoned BW, HANA, SAC professionals who wants to expand their skills, especially in SAC Planning

SAC Planning & Reporting - Complete Hands-On Training

What you'll learn

Explore related topics

Course content

All Course Material4 lectures • 1min

Welcome & Introduction to SAC2 lectures • 1hr 51min

SAC Architecture and Connectivity3 lectures • 2hr 12min

BTP Introduction + Basics of SAC Modeling3 lectures • 2hr 16min

Modeling in SAC2 lectures • 1hr 27min

Dimension types in SAC (public vs private)2 lectures • 1hr

Dimension properties & Public Dimensions3 lectures • 1hr 34min

Hierarchies in SAC3 lectures • 1hr 45min

Hierarchies in SAC – Deep Dive2 lectures • 1hr 47min

Account Dim Multiple Hierarchies and Calculated Accounts2 lectures • 2hr 5min

Requirements

Description

Who this course is for: