Technical steering — loss ratio
Steer your technical profitability: combined ratio, frequency and average cost of claims by product.
Combined ratioLoss ratioClaim frequency
Open template →
Insurance · SAP Analytics Cloud
SAP Analytics Cloud templates for Insurance
4 ready-to-use SAC and SAC Planning templates for Insurance — each with the KPIs, dimensions and realistic data your function actually tracks. Import in minutes, or generate a tailored one. No sign-up.
KPIs we cover for Insurance
Premiums writtenLoss ratioCombined ratioAverage claim costClaim frequencyLapse rateTechnical marginTechnical reserves
Analysis dimensions
Line (Motor/Home/Life)RegionCustomer segmentDistribution channelAge bandUnderwriting year
4 Insurance templates
Each opens with a live preview and a one-click download (.xlsx, .csv, .package).
Solvency — Solvency II
Monitor your capital requirement (SCR/MCR) and the composition of your eligible own funds.
Solvency ratio (SCR)MCREligible own funds
Open template →
Underwriting & new business
Measure your underwriting effectiveness: acceptance rate, average premium and new-business flow.
Acceptance rateAverage premiumNew business
Open template →
Claims management
Manage claims handling: settlement time, reserving ratio and open-claims backlog.
Average claim costSettlement timeReserving ratio
Open template →
How to model Insurance in SAP Analytics Cloud
A solid Insurance model starts with the right grain. Build your dimensions first (Line (Motor/Home/Life), Region, Customer segment), then add the measures that matter (Premiums written, Loss ratio, Combined ratio). The trap is aggregation: amounts and volumes sum, but rates and percentages must use AVERAGE, and stocks or balances must use a LAST exception on the time dimension — otherwise your yearly totals come out wrong.
Set those aggregations once in the Modeler, import your data, and build a Story from the KPIs above. For the full method, see our guides on importing a CSV into SAC and choosing the right aggregation.
Related reading for Insurance
Guides and analysis relevant to Insurance teams working in SAP Analytics Cloud.
Industry
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-fu…
Industry
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 mo…
Comparison
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: reporti…
Regulated reporting
Insurance compliance, kept current
Working on Solvency II and IFRS 17? The free templates get you started; the accelerators ship the published thresholds pre-filled and a step-by-step import guide.