Fact (OLAP)
Overview
In SQL Server Analysis Services (SSAS) data warehousing and OLAP/UDM solutions, a fact is a single record, usually representing a business transaction, at the lowest level of [[articles:Grain (OLAP)|granularity]] recorded in the database. Facts are composed of [[articles:Dimension|dimension]] keys and [[articles:Measure Group|measures]]; the dimension keys reference specific members from dimensions involved in the transaction recorded by the fact, and the measures assign values to the fact. For example, in a data warehouse of sales transactions, a fact record would have dimension keys for the customer, seller, product, time, and location of the transaction, and measures for the number of products sold, and the amount of money paid.
See Also
- SQL Server Analysis Services (SSAS)
- Unified Dimensional Model
- [[articles:Star Schema]]
- [[articles:Snowflake Schema]]
- SQL Server Overview
Other Languages
This article is also available in the following languages: