SQLExpressionBaseMeasure
Advanced measure implementation that enables sophisticated analytical calculations through custom SQL expressions, providing powerful capabilities for implementing complex business logic, mathematical computations, and data transformations that cannot be achieved through standard column-based measures or simple aggregation functions.
Extends
- BaseMeasure 🔗
Attributes
| Name | Id | Type | Lower | Upper |
|---|
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| column | SQLExpressionColumn🔗 | 1 | 1 | false |
| Reference to the SQLExpressionColumn that defines the custom SQL expression logic for this advanced measure implementation. The SQLExpressionColumn contains the sophisticated SQL formula, mathematical computations, conditional logic, and data transformations that enable complex analytical calculations beyond the capabilities of standard column-based aggregation functions. This relationship establishes the connection between the measure definition and its custom SQL implementation, enabling powerful analytical scenarios such as weighted averages with multiple factors, conditional aggregations based on dimensional context, statistical calculations requiring advanced mathematical functions, financial formulas implementing specific industry regulations, and composite metrics that combine multiple data sources with complex business rules. | ||||