MeasureGroup
A logical container that organizes related measures within a physical cube, providing grouping for measures that share common characteristics, business context, or data sources. MeasureGroup serves as both an organizational and metadata management mechanism, enabling better structure for complex cubes with many measures. For example, a sales cube might have separate measure groups for 'Revenue Metrics' (containing sales amounts, discounts, taxes) and 'Volume Metrics' (containing quantities, units, counts). Each measure group belongs to exactly one physical cube and contains one or more measures that are processed and displayed together in OLAP clients and XMLA metadata. A MeasureGroup is typically based on a single fact table in the data warehouse, ensuring that all its measures share the same granularity and relationship to dimensions. This alignment simplifies processing, querying, and maintenance.
Extends
Attributes
| Name | Id | Type | Lower | Upper |
|---|---|---|---|---|
| name | false | EString | 0 | 1 |
| Display name for this measure group that appears in OLAP clients, cube browsers, and metadata discovery. The name should clearly indicate the business purpose or theme of the grouped measures, such as 'Sales Metrics', 'Financial KPIs', or 'Inventory Measures'. This name helps users understand the logical organization of measures and appears in XMLA metadata and client tool measure lists. | ||||
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| measures | BaseMeasure🔗 | 1 | ∞ | true |
| Collection of measures that belong to this measure group. Each measure represents a quantitative fact that can be analyzed and aggregated in OLAP queries, such as sales amounts, quantities, costs, or counts. The measures share common grouping characteristics and are often related by business context or data source. At least one measure is required per measure group, and all measures inherit the group's organizational and metadata properties. Measures can be of various types including sum, average, min, max, count, or custom aggregations. | ||||
| physicalCube | PhysicalCube🔗 | 1 | 1 | false |
| Reference to the physical cube that contains this measure group. This establishes the bidirectional relationship between the cube and its measure groups, enabling the cube to organize its measures into logical groups while allowing the measure group to access cube-level properties and configurations. Each measure group belongs to exactly one physical cube and contributes to that cube's analytical capabilities. | ||||