How to model workforce planning in SAP Analytics Cloud
Build an HR workforce plan in SAP Analytics Cloud: headcount and FTE, attrition, the hiring plan and payroll forecast — with the right dimensions, versions and aggregations.
· 2 min read
Blog
Tutorials & best practices for SAP Analytics Cloud
Practical guides, comparisons and lessons learned to get the most out of SAC Analytics and SAC Planning.
SAC aggregation exception on the time dimension: fixing wrong stock and balance totals
Why stock, cash and headcount totals come out wrong in SAP Analytics Cloud, and how the time-dimension aggregation exception (LAST) fixes them — step by step in the Modeler.
· 3 min read
IFRS 9 expected credit loss in SAP Analytics Cloud: staging, ECL and model structure
How to structure IFRS 9 expected credit loss (ECL) reporting in SAP Analytics Cloud: the three stages, PD/LGD/EAD, the ECL calculation and the right dimensions and aggregations.
· 2 min read
BCBS 239 in SAP Analytics Cloud: risk data aggregation and reporting principles
How SAP Analytics Cloud helps meet BCBS 239: the principles that touch reporting, data lineage and aggregation, accuracy and timeliness, and structuring risk reporting for supervisors.
· 2 min read
IFRS 17 in SAP Analytics Cloud: CSM, risk adjustment and the measurement models
How to structure IFRS 17 insurance reporting in SAP Analytics Cloud: GMM, PAA and VFA measurement models, the CSM roll-forward, risk adjustment, and the right dimensions and aggregations.
· 6 min read
Pillar 3 disclosures in SAP Analytics Cloud: structuring the regulatory templates
How to structure Basel Pillar 3 disclosures in SAP Analytics Cloud: the standardized templates, capital and RWA breakdowns, the right dimensions, and keeping disclosures consistent.
· 2 min read
CSRD double materiality in SAP Analytics Cloud: structuring ESRS datapoints
How to structure CSRD double materiality and ESRS datapoints in SAP Analytics Cloud: impact vs financial materiality, the datapoint dimension, and tracking disclosure coverage.
· 2 min read
SAC Data Actions: copy versions, allocate and spread in SAP Analytics Cloud
How SAC Planning Data Actions work: copy a version, allocate a top-down total, spread across periods and convert currencies — with setup steps and common pitfalls.
· 3 min read
How to model retail store performance in SAP Analytics Cloud
Build a retail store-performance model in SAP Analytics Cloud: revenue, average basket, footfall, conversion and like-for-like — with the right dimensions and aggregations.
· 2 min read
SAC vs Anaplan for enterprise planning: which platform fits
A practical comparison of SAP Analytics Cloud Planning and Anaplan: modeling approach, calculation engine, SAP integration, unified analytics and reporting, and total cost.
· 4 min read
SAC vs Power BI for financial and regulatory reporting: which to choose
A practical comparison of SAP Analytics Cloud and Power BI for financial and regulatory reporting: planning and data entry, versioning, governance, SAP integration and cost.
· 4 min read
Solvency II in SAC: structuring SCR, MCR and the solvency ratio
How to model Solvency II reporting in SAP Analytics Cloud: dimensions by risk module, SCR/MCR/own-funds measures, and the correct coverage-ratio calculation (without summing it by mistake).
· 7 min read
How to import a CSV file into SAP Analytics Cloud Modeler
Step-by-step guide to importing a CSV file into SAC Modeler: file preparation, mapping dimensions and measures, column typing and building your first Story.
· 3 min read
Basel III in SAC: modeling CET1, LCR and NSFR with the right aggregation
Guide to structuring Basel III bank regulatory reporting in SAP Analytics Cloud: RWA, CET1 ratio, LCR and NSFR, with the right aggregations so ratios stay correct at every level.
· 7 min read
SAC Analytics vs SAC Planning: 8 key differences to choose
SAC Analytics or SAC Planning? A detailed comparison of the two SAP Analytics Cloud modules: reporting, data entry, versions, workflows, and the simple rule to pick the right model from the start.
· 2 min read
SUM, AVERAGE, LAST, COUNT: choosing the right aggregation in SAC
The default SUM aggregation distorts your rates and stocks. This guide explains when to use AVERAGE, LAST or COUNT in SAP Analytics Cloud, and how to set the aggregation exception on the time dimension.
· 1 min read
How to model stock and supply chain in SAP Analytics Cloud
Build a stock and supply-chain model in SAP Analytics Cloud: inventory levels, days of cover, stockouts, service level and turnover — with the right aggregations for balances.
· 1 min read
The Version dimension in SAC Planning: Actual, Budget, Forecast
Understanding versions in SAP Analytics Cloud Planning: the difference between public and private versions, the Actual/Budget/Forecast categories, and best practices to compare and copy scenarios.
· 1 min read
How to build an annual budget and rolling forecast in SAP Analytics Cloud
Build an annual budget and a 12-month rolling forecast in SAP Analytics Cloud Planning: the Version dimension, Data Actions for seeding and spreading, and variance reporting.
· 2 min read
CSRD/ESG reporting in SAC: structuring Scopes 1, 2 and 3
How to build GHG Protocol-compliant carbon-emissions reporting in SAP Analytics Cloud: dimensions by scope and emission source, emission factors, and conversion to tCO2e.
· 7 min read
Importing a multi-sheet Excel workbook into SAP Analytics Cloud
Excel is still the most common source for SAC. This guide explains how to prepare a multi-sheet workbook, choose the right sheet to import, handle headers and avoid typing pitfalls on import.
· 4 min read