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 granularity recorded in the database. Facts are composed of dimension keys and 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

Other Languages

This article is also available in the following languages:

Brazilian Portuguese (pt-BR)