OLAP Cube¶
A multidimensional analytical model that organizes measures by dimension members and supports valid aggregate views.
Core Idea¶
An OLAP cube is an analytical model that organizes a measure by combinations of dimension members and defines valid ways to summarize it. A value answers which quantity, for which members and level, under which aggregation rule. Selecting another context produces a related view without changing the model's underlying meaning. A cube need not have exactly three axes or store every possible total in a dense physical array; coordinate and aggregation semantics identify it.[ref-c6e2c48bf5a2][ref-8a4fa7aef0fb]
Scope of Application¶
The literal setting is multidimensional analysis of measures across selectable member contexts and aggregate levels.
- Automobile sales: Gray and colleagues work a Model, Year and Color cube with Units and ALL subtotals; it is a research example, not observed retail data.[^ref-c6e2c48bf5a2]
- Service incidents: Microsoft documents an Excel view of SystemCenterWorkItemsCube using Incidents Opened and ComputerDim/DisplayName; it is a product workflow, not a customer result.[^ref-625e31fdf0f7]
Clarity¶
State the measure, what one contributing fact means, the selected dimension members, the requested level and the valid combining rule. A subtotal marked ALL means a grouped context, not another ordinary member.[^ref-c6e2c48bf5a2] Microsoft's field label Incidents Opened and nearby prose about currently open incidents do not alone establish the same population; its measure definition controls that question.[^ref-625e31fdf0f7] A star schema may supply data for a cube but does not by itself specify its analytical views.
Manages Complexity¶
Dimension-member coordinates give related reports one question grammar. An analyst can vary filters, groupings or levels while keeping the measure definition visible. This avoids redefining each subtotal and helps locate errors: a wrong population differs from an invalid aggregation formula. Sparse storage and selective pre-aggregation can realize the logical model without fully materializing every view. Materializing common summaries can reduce repeated query work but increases stored and maintained state; that is an implementation choice, not the cube's identity.[ref-c6e2c48bf5a2][ref-c14808f3532d]
Abstract Reasoning¶
Begin with an event grain and measure, then select member coordinates and ask which observations contribute to a requested view. Counts, amounts and balances require declared aggregation rules; balances need not be additive across time.[^ref-8a4fa7aef0fb] Collapse a dimension only through an operation valid for that measure and level. Summing additive sales units over a declared subset may preserve meaning; summing successive account balances over days may not.[ref-c6e2c48bf5a2][ref-8a4fa7aef0fb] The visual shape of a cross-tab cannot decide whether its total is sound. Test the calculation against the quantity's definition before treating the displayed value as an answer.
Knowledge Transfer¶
The five roles travel literally from automobile units to incident counts: dimensions, coordinates, measure, aggregation semantics and view selection. Their labels and quantities change, so one source's field group or subtotal rule should not be copied unexamined into the other. Data Model is the direct genus: it declares data roles, constraints and valid operations. Representation is inherited through it; Aggregation describes the combining operation inside selected views. An arbitrary multidimensional array or a metaphorical “cube” lacks this complete measure-by-dimension analytical relation. Transfer it only where that relation is actually defined.
Relationships to Other Abstractions¶
Current abstraction OLAP Cube Domain-specific
Parents (1) — more general patterns this builds on
-
OLAP Cube is a kind of Data Model Domain-specific
An OLAP cube is a logical data model specialized by dimension-member measure coordinates and valid selectable aggregate views.
Hierarchy path (1) — routes to 1 parentless root
- OLAP Cube → Data Model → Representation → Abstraction
Neighborhood in Abstraction Space¶
OLAP Cube sits in a sparse region of the domain-specific corpus (64th percentile for distinctiveness): few abstractions share its structure, so a faithful description tends to retrieve it precisely.
Family — Faceted Classification & Metadata (15 abstractions)
Nearest neighbors
- Measurement Scale — 0.86
- Dimensionless Quantity — 0.85
- Topic Facet — 0.84
- Dubins–Spanier Theorems — 0.83
- Categorical Variable — 0.83
Computed from structural-signature embeddings · 2026-10-17
References¶
[^ref-c6e2c48bf5a2]: Jim Gray, Adam Bosworth, Andrew Layman, and Hamid Pirahesh, “Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals,” Microsoft Research Technical Report MSR-TR-95-22 (1995 revision), printed Data Cube pp. 3–5, Tables 4–5, Figure 2 and §3 for the worked model and operator, plus §5, printed p. 9, for sparse-cube storage; PDF zero-based pages 4–6 and 9, https://www.microsoft.com/en-us/research/wp-content/uploads/2016/02/tr-95-22.pdf. This is the four-author report, distinct from the later expanded journal article. [^ref-625e31fdf0f7]: Microsoft, “Analyze Service Manager OLAP cube data with Excel,” Microsoft Learn (2024), updated November 1; documentation view sc-sm-2025, “View and analyze” steps 2–3, https://learn.microsoft.com/en-us/system-center/scsm/olap-cube-excel?view=sc-sm-2025. Official product example; the field label does not independently define its population. [^ref-c14808f3532d]: Microsoft, “Overview of Service Manager OLAP cubes for advanced analytics,” Microsoft Learn (2026), updated September 21; documentation view sc-sm-2025, “About Service Manager OLAP cubes,” “Dimensions,” “Aggregations” and “Data source view,” https://learn.microsoft.com/en-us/system-center/scsm/olap-cubes-overview?view=sc-sm-2025. [^ref-8a4fa7aef0fb]: Microsoft, “Measures and Measure Groups,” Microsoft Learn (2024), updated February 5; Analysis Services documentation, opening definition, “Measures,” “Define Semiadditive Behavior” and measure-group configuration, https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/measures-and-measure-groups?view=sql-analysis-services-2025.