BaseMeasure
Abstract base class for all measure types in the OLAP model, representing quantitative facts that can be analyzed and aggregated in multidimensional queries. BaseMeasure extends Member to leverage the OLAP member infrastructure while adding measure-specific capabilities like data type specification, formatting rules, and aggregation behavior. All concrete measure implementations (SumMeasure, CountMeasure, etc.) inherit from this class, ensuring consistent measure behavior and enabling polymorphic measure handling throughout the OLAP framework. Measures are special members that belong to the [Measures] dimension and provide the numeric values for analytical operations.
Extends
- Member 🔗
Attributes
| Name | Id | Type | Lower | Upper |
|---|---|---|---|---|
| backColor | false | EString | 0 | 1 |
| Background color specification for this measure when displayed in OLAP clients and reporting tools. The color value should follow standard color notation (e.g., hex colors like '#FF0000', RGB values, or color names). This visual formatting helps users quickly identify and differentiate measures in pivot tables, charts, and other analytical displays, particularly useful for highlighting important KPIs or categorizing related measures. | ||||
| dataType | false | ColumnInternalDataType🔗 | 0 | 1 |
| Data type specification for this measure that determines how values are processed, stored, and displayed. The data type affects aggregation behavior, formatting options, and client tool integration. Common types include INTEGER for counts, NUMERIC for monetary amounts, DECIMAL for precise calculations, and DOUBLE for statistical measures. This information is used by the OLAP engine for type validation, optimization, and proper value handling across different database systems. | ||||
| formatter | false | EString | 0 | 1 |
| Formatter specification that controls how this measure's values are displayed in client applications. The formatter can reference predefined format patterns, custom formatting functions, or specific formatting rules. This ensures consistent presentation of measure values across different analytical tools and reports, handling aspects like decimal places, currency symbols, percentage notation, and locale-specific formatting. | ||||
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| measureGroup | MeasureGroup🔗 | 1 | 1 | false |
| Reference to the measure group that contains and organizes this measure. Every measure must belong to exactly one measure group, which provides logical organization, metadata management, and context for the measure within its cube. The measure group relationship enables proper measure categorization, shared properties, and structured navigation in OLAP client tools. | ||||