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.
See also
*
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 ...
*
Dimension (data warehouse)
A dimension is a structure that categorizes facts and measures in order to enable users to answer business questions. Commonly used dimensions are people, products, place and time. (Note: People and time sometimes are not modeled as dimensions.) ...
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