← Back to Learn
COMPOSITE PATTERN

As-Known Reporting

Reconstruct historical reports using only information that was available at the original reporting moment.

Prevent later corrections, backfills and restatements from silently changing previously published historical results.

Problem

Past reports can be rewritten by future knowledge.

A historical report can show either the corrected truth known today or the information that was known when the report was originally produced.

Both perspectives can be valid, but they answer different questions and must not be mixed accidentally.

Future knowledge leakageNon-reproducible reportsAudit disagreementIncorrect visible-time logic
Interactive example

A January report should not use a correction that arrived in March.

Compare corrected truth with the original January knowledge state.

Timeline
31 Jan
Originally reportedRetail
12 Mar
Correction arrivesPremium
Reporting perspective
January reproduced with the original knowledge cutoff
Customer segmentRetail

The March correction was not visible on 31 January, so the original report remains Retail.

Key idea

Corrected truth and as-known truth are both useful. The model must preserve enough temporal information to answer each one explicitly.

Core concepts

As-known reporting uses both a business date and a knowledge date.

Business-valid time describes when a value was true. Visible time describes when that value became available to the reporting system.

Reporting date
Selects the business period being reconstructed.
Knowledge date
Limits the query to versions visible at the original reporting moment.
Corrected truth
Uses the best information available today.
As-known truth
Uses only information available at the historical cutoff.
As-known query
select
  customer_id,
  segment
from customer_history
where :reporting_date >= valid_from
  and :reporting_date <  valid_to
  and :knowledge_date >= visible_from
  and :knowledge_date <  visible_to;
Why it happens

Business time and knowledge time are different.

A correction can be valid for January and still arrive in March. The business date and the knowledge date therefore describe different aspects of the same fact.

If a report rebuild ignores the knowledge cutoff, it can use information that did not exist when the original report was produced.

Late correctionsBackdated changesReloaded source historyBitemporal dimensionsPublished month-end reportsRestated master data
Common modeling approaches

Make the reporting perspective explicit.

Track visible time
Store visible_from and visible_to so the model knows when a version became available.
Query with two dates
Use both the reporting date and the knowledge date.
Preserve knowledge states
Do not overwrite previous known versions when corrections arrive.
Separate report modes
Distinguish corrected-truth reporting from as-known reporting.
When to use it

Use as-known reporting when historical knowledge must remain reproducible.

Published month-end reportingAudit and regulatory reconstructionLate-arriving correctionsRestated master dataHistorical source reloadsDisputes about previously known values
Validation checks

Verify that future knowledge does not leak into past reports.

Validate visible-time intervalsRebuild a known historical reportApply the original knowledge cutoffCompare against published outputTest retroactive correctionsSeparate corrected truth from as-known truth
Why it matters

As-known reporting gives historical correctness a precise meaning.

It lets engineers, business users and auditors distinguish between the best truth available today and the information that was available at an earlier point in time.

This distinction is one of the main reasons to use visible-time or bitemporal modeling.

RELATED TEMPORAL MODELS

How As-Known Reporting connects to other historical patterns

As-known reporting is the reporting behavior enabled by visible-time history, correction semantics and reproducible snapshot logic.

Bitemporal Modeling
Provides the valid-time and visible-time axes required for as-known reconstruction.
Historical Correction
Preserves corrected truth without erasing previously known versions.
Snapshot Reproducibility
Uses historical knowledge cutoffs to reproduce prior snapshot outputs.
Publication-Time Modeling
Separates what was known from what was officially published.
Related Patterns
Bitemporal ModelingHistorical CorrectionSnapshot ReproducibilityPublication-Time ModelingSnapshot Fact Modeling
Try it

Review an as-known reporting requirement.

Use the Historical Data Assistant to reason about reporting dates, knowledge cutoffs, corrections and reproducible historical outputs.

Open Historical Data Assistant →