In a

data warehouse In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integra ...

, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made.

Example

For example, if a retail store sold a specific product, the quantity and prices of each item sold could be added or averaged to find the total number of items sold or the total or average price of the goods sold.

Use of ISO representation terms

When entering data into a metadata registry such as

ISO/IEC 11179 The ISO/IEC 11179 Metadata Registry (MDR) standard is an international ISO/IEC standard for representing metadata for an organization in a metadata registry. It documents the standardization and registration of metadata to make data understandab ...

representation term A representation term is a word, or a combination of words, that semantically represent the data type (value domain) of a data element. A representation term is commonly referred to as a ''class word'' by those familiar with data dictionaries. ISO ...

s such as number, value and measure are typically used as measures.

References

* Kimball, Ralph et al. (1998); ''The Data Warehouse Lifecycle Toolkit'', p17. Pub. Wiley. . * Kimball, Ralph (1996); ''The Data Warehouse Toolkit'', p100. Pub. Wiley. . {{Data warehouse Data warehousing Metadata

Example

Use of ISO representation terms

See also

References