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
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 SACplanning 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 SACmodeling, reporting &planning concepts:
SAC tool - look and feel
SACconnectivity with SAP and Non-SAPsources.
SACModelling Fundamentals - Public dimension, Private dimension, Hierarchies, Properties and much more.
Datasets in SACand 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 SACstories using the GDrive flat files.
Basic and Advanced reporting functionalities in SACStories, 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 SAPStnd CDSViews.
End-to-end planning of the customer scenario of P&Lplanning.
Creating FSV and S4HANA and loading data into SAC public dimensions.
Loading hierarchies fromS4HANA to SACpublic dimensions.
Loading transaction data from S4 CDSViews (oData service) to SACplanning model.
Creating planning input templates.
Creating Planning versions (public and private) using Version Management.
Creating Data Upload triggers in SACplanning 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 SACusing the content network.
Business Content installation in SAC.
