Facts
Observed financial values recorded at a defined grain, linking semantic dimensions to measurable events.
What are Facts?
Facts are implemented purely in SQL, with DuckDB as the reference engine, making them portable across different database providers.
Facts store what actually happened. They record observed financial values, such as amounts, counts, or quantities, at a clearly defined level of detail, always by referencing semantic layers like Periods, GL Accounts, Value Types, or Revenue Types.
Every fact table links one or more semantic dimensions and attaches measurable values, ensuring observations are consistently classified, comparable, and reusable across transformations and reporting.
Facts are the inputs to the transformation layer. They provide stable, auditable observations that transformations consume to produce analytical models, which are then exposed to reporting and BI without redefining classifications or business logic.