Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 7 of 7

Service levels and metrics

16 min

Listen to this lesson

0:00 / 6:29

A service without measures is a promise nobody can check. The data and environment services need a small set of service levels that requesters can plan around, and metrics that show whether the services are getting better. They also feed the TCoE scorecard and the value reporting covered in sap-tcoe-406.

The measures

MeasureDefinitionContoso baselineTarget after 12 months
Time to test-ready after refreshWorking days from copy complete to readiness check passed6 days2 days
Environment availability in test windowsTest-ready hours ÷ booked hours, per environmentNot measured95% or better
Refreshes on scheduleRefreshes completed in their calendar slot ÷ refreshes planned1 of 2All
Data request lead timeWorking days from request to test-ready data, by request type (median and 85th percentile)About 4 days, all requests bespokeGolden: immediate; recipe: 2 days; bespoke: 5 days
Data-caused failuresFailed tests whose root cause is data ÷ all failed testsAbout 30%Under 10%
Blocked hours from data and environmentsTagged blocked or repeated hours ÷ execution hours per release event22%8%
Masked before accessRefreshed copies masked and checked before testers logged on ÷ all refreshes50%100%, with no exceptions unapproved

Contoso's data and environment service measures. Baselines come from lesson 1; targets are agreed with Basis, integration and security.

Two of these deserve care. Lead time should be reported as a median and a high percentile, not an average, because a few bespoke requests can make the average meaningless; the 85th percentile tells requesters what they can count on. Data-caused failures need the root-cause tag on every failed test, which is also what separates real defects from noise in the regression report.

The records behind the measures. If any of these is not captured, the matching measure cannot be calculated.
The Sign-Off Table · thesignofftable.com/academy/sap-tcoe-405

Readiness reports as evidence

ISO/IEC/IEEE 29119-3 pairs requirements with readiness reports: test environment requirements with a test environment readiness report, and test data requirements with a test data readiness report. They are useful formats for the TCoE. Before each release regression, Priya issues one short readiness note per environment: the refresh date and source, the transport level, masking log reference, connected systems status, data recipes run and golden data checked, and any conditions. That note becomes part of the test basis statement in the evidence pack (sap-tst-307), so results always say what they were obtained on.

  1. Day −15Refresh completeCopy, runbook and masking log filed
  2. Day −13Readiness check passedSmoke tests per value stream; connected systems proven
  3. Day −10Data readyRecipes run; golden data checked and reserved
  4. Day −8Stack in CMRFeature pack stack imported; technical checks
  5. Day 0Readiness note issuedEnvironment and data readiness for regression, with conditions
  6. Day 0 to 10Regression windowBlocked hours tagged by cause; daily status
The readiness milestones before a stack regression in CMR. Days are counted back from the start of the window.
The Sign-Off Table · thesignofftable.com/academy/sap-tcoe-405

Reporting and improving

Report the measures monthly in the TCoE service review with Sam, Theo and Nadia, and quarterly to the quality council as part of the TCoE scorecard. Use them to decide investments: if data-caused failures stay high in one value stream, that is where the next recipes go; if time to test-ready is stuck, the runbook needs automation or the contract with SAP needs a different post-copy split. Publish the numbers to requesters too. A project that can see the data service meets its two-day level 90% of the time plans around it instead of creating its own data on the side.

What would you do?

The data service meets its two-day level for recipes 95% of the time, but data-caused failures in procure to pay are still 25%. What does this tell Priya?

Key points
  • Measure time to test-ready, availability, refreshes on schedule, data lead time, data-caused failures, blocked hours and masking before access.
  • Report lead times as a median and a high percentile; tag every failed test with a root cause.
  • Issue an environment and data readiness note before each regression, after the readiness reports in ISO/IEC/IEEE 29119-3.
  • Pair speed measures with quality measures, and use the numbers to direct the next investment.

Check your understanding · not graded

Lesson check

  1. 1. Why report data request lead time as a median and an 85th percentile?

  2. 2. What does the environment and data readiness note add to the evidence pack?

  3. 3. Recipes are delivered on time but procure-to-pay tests keep failing on data. Which pairing revealed this?

  4. 4. Time to test-ready after a CMR refresh is stuck at four working days, mostly waiting for manual steps. What should the TCoE do with that measure?