SqlView
Represents a virtual table defined by SQL query expressions rather than physical database tables. SqlView enables complex data transformations, joins, and calculations to be encapsulated as table sources for OLAP dimensions and measures.
Extends
- Table 🔗
Attributes
| Name | Id | Type | Lower | Upper |
|---|
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| sqlStatements | SqlStatement🔗 | 1 | ∞ | true |
| Collection of SQL statements that define this view's query logic. Multiple statements support database-specific implementations, with the OLAP engine selecting the appropriate statement based on the target database dialect. | ||||
Used by
- SqlSelectQuery🔗 → sql