Compile check and metric tests | ATX AnalyticsTable Docs

Compile check and metric testsBefore a definition is certified, the compile check proves it runs on its database without reading a row; metric tests assert that its NUMBERS are right — six test types with examples, running and scheduling them, the badge, and the switches that make either block certification. Two safeguards live in the Checks & tests panel of every semantic object. The CHECK proves a definition compiles: every query it takes part in is parsed, bound and type-checked by its own database, without reading data. A METRIC TEST proves a number: revenue for 2025 is 4.2 million within 0.5 %, or the orders table was loaded today. The check runs automatically when certification is requested or granted; tests run when you ask, on a schedule, and optionally at certification.

Where to find it

Settings → Settings → Set / Restore → Semantic objects → Checks & tests

What this page covers

The compile check
Metric tests
Results and the badge
Scheduling and blocking certification (administrator)
Limits
In the in-app manual

Settings and controls documented

Measure, calculated member
Dimension
Dataset
Join
Filter
Parameter, metric test
Expected value
Range
Not null
Reconciliation
Row count
Freshness
ANALYTICS_SEMANTIC_CERTIFY_REQUIRES_CHECK
ANALYTICS_SEMANTIC_CERTIFY_REQUIRES_TESTS
ANALYTICS_SEMANTIC_TESTS_EVERY_HOURS
ANALYTICS_SEMANTIC_TESTS_PROJECT

Full page

The full page — procedures and the explanation of every setting — is available to signed-in users.

ATX Institute on LinkedIn

This site needs JavaScript for the full experience. Every page above is reachable without it.