Query
Abstract base class for all data source queries in the OLAP mapping system, providing the foundation for accessing and combining data from various sources including physical database tables, custom SQL views, in-memory data sets, and complex multi-table joins. Queries serve as the data access layer that bridges the logical OLAP model with physical data storage, enabling the OLAP engine to generate appropriate SQL statements for different database systems while maintaining abstraction from specific storage implementations. The Query hierarchy supports composable patterns where simple queries can be combined into complex data access structures through joins, enabling sophisticated dimensional modeling over normalized database schemas and custom data integration scenarios.
Extends
- DocumentedElement 🔗
Attributes
| Name | Id | Type | Lower | Upper |
|---|---|---|---|---|
| id | true | EString | 1 | 1 |
| Unique identifier for this query within the catalog scope, used for referencing the query from other OLAP model elements such as cube definitions, hierarchy specifications, and level mappings. The ID enables query reuse across multiple dimensional contexts and supports modular data access design patterns where complex queries can be defined once and referenced multiple times throughout the analytical model. | ||||
References
| Name | Type | Lower | Upper | Containment |
|---|---|---|---|---|
| documentation | Documentation🔗 | 0 | 1 | true |
| Documentation element that provides descriptive information about this SQL expression column. Contains text explaining the purpose and behavior of the SQL expression, helping developers understand complex calculated columns. | ||||