Business Intelligence: Measures (Definitions)

"A quantitative, numerical column in a fact table. Measures typically represent the values that are analyzed. See also dimension." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"A metric is a measurable or quantitative value." (Microsoft Corporation, "Microsoft SQL Server 7.0 Data Warehouse Training Kit", 2000)

"A measure is a dimensional modeling term that refers to values, usually numeric, that measure some aspect of the business. Measures reside in fact tables. The dimensional terms measure and attribute, taken together, are equivalent to the relational modeling use of the term attribute." (Claudia Imhoff et al, "Mastering Data Warehouse Design", 2003)

"(1) A mapping from empirical properties to quantities in a formal mathematical model called a measurement scale. (2) To obtain a measurement." (Richard D Stutzke, "Estimating Software-Intensive Systems: Projects, Products, and Processes", 2005)

"In Dimensional modeling, a specific data item that describes a fact or aggregation of facts. Measures are implemented as metric facts." (Sharon Allen & Evan Terry, "Beginning Relational Data Modeling" 2nd Ed., 2005)

"A summarizable numerical value used to monitor business activity; it is also known as a fact. " (Reed Jacobsen & Stacia Misner, "Microsoft SQL Server 2005 Analysis Services Step by Step", 2006)

"A column of quantifiable data mapped to a dimension within a cube. Measures are often used to provide access to aggregations of data (such as annual sales of a product or a store), while also giving the ability to drill down into the details (such as quarterly or monthly sales)." (Robert D. Schneider and Darril Gibson, "Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies", 2008)

[business measure:] "Business performance metric captured by an operational system and represented as a physical or computed fact in a dimensional model." (Ralph Kimball, "The Data Warehouse Lifecycle Toolkit", 2008)

"A set of usually numeric values from a fact table that is aggregated in a cube across all dimensions." (Jim Joseph et al, Microsoft® SQL Server 2008 Reporting Services Unleashed, 2009)

[business measures:] "The complete set of facts, base and derived, that are defined and made available for reporting and analysis." (Laura Reeves, "A Manager's Guide to Data Warehousing", 2009)

"A quantitative performance indicator or success factor that can be traced on an ongoing basis to determine successful operation and progress toward objectives and goals." (David Lyle & John G. Schmidt, "Lean Integration", 2010)

"1.Loosely used, a metric. 2.In data modeling, a quantified characteristic; the unit used to quantify the dimensions, capacity, or amount of something." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"Value assigned (noun) or the process of assigning a value (verb) to an object through calculation, appraisal, estimation, or some other method." (Leslie G Eldenburg & Susan K. Wolcott, "Cost Management" 2nd Ed., 2011)

"In a cube, a set of values that are usually numeric and are based on a column in the fact table of the cube. Measures are the central values that are aggregated and analyzed." (Microsoft, "SQL Server 2012 Glossary", 2012)

"The act of identifying what to measure as well as actually collecting the measures that would help an organization understand if the process is operating within acceptable limits." (Project Management Institute, "Organizational Project Management Maturity Model (OPM3®)" 3rd Ed., 2013)

"Metrics such as count, maximum, minimum, sum, or average that are used in a fact table. Measures can be calculated with an SQL expression or mapped directly to a numeric value in a column." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

"The number or category assigned to an attribute of an entity by making a measurement. (ISO 14598)