Multi-site clinical trials
Track recruitment, site activation and protocol milestone adherence across all your ongoing trials.
Patients enrolledTrial retention rateCost per patient
Open template →
Pharma · SAP Analytics Cloud
SAP Analytics Cloud templates for Pharma
4 ready-to-use SAC and SAC Planning templates for Pharma — 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 Pharma
Patients enrolledTrial retention rateCost per patientTime to marketMarket shareSales by moleculeR&D costSerious adverse eventScript conversion
Analysis dimensions
Clinical phaseTherapeutic areaCountryInvestigator siteMoleculeRegionChannelPhysician specialty
4 Pharma templates
Each opens with a live preview and a one-click download (.xlsx, .csv, .package).
Product sales & market share
Monitor sales performance by molecule, geography and competitor — with a volume × price breakdown.
RevenueMarket shareSales by molecule
Open template →
Pharmacovigilance & safety signals
Detect pharmacovigilance signals, track adverse-event reports and regulatory deadlines.
Serious adverse eventsSignals detectedReporting lead time
Open template →
R&D pipeline — phases I to III
Visualize your molecule portfolio by study phase, R&D cost committed and probability of success through to launch.
Molecules in phase I/II/IIIR&D costPhase success rate
Open template →
How to model Pharma in SAP Analytics Cloud
A solid Pharma model starts with the right grain. Build your dimensions first (Clinical phase, Therapeutic area, Country), then add the measures that matter (Patients enrolled, Trial retention rate, Cost per patient). 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.