faktatabellen
Faktatabellen, in data warehousing and business intelligence, stores the measurable, quantitative data used for analysis. Each row represents a single transaction or event at a defined grain, such as a sale, shipment, or service engagement. In many designs it is the central table in a star or snowflake schema. The term faktatabellen is used in some Scandinavian contexts to refer to this concept.
The faktatabellen is surrounded by dimension tables that describe attributes such as time, product, customer, and
Common types include transaction fact tables (one row per event), periodic snapshot fact tables (aggregates for
In practice, faktatabellen enable fast aggregations and drilling across multiple dimensions in BI tools, supporting OLAP-style