Modeling with Cube
Cube is an open-source semantic model that can be used to centralize business logic across your data stack and accelerate query performance. For more information, see the documentation.
Concepts
To effectively leverage your Cube models within Hex, check how key concepts translate between the two platforms.
| Cube | Hex |
|---|---|
| data model | model |
| cube | dataset |
| dimension | dimension |
| measure | measure |
| join | join |
| view | n/a |
| segment | n/a |
Supported Features
Not all Cube features translate directly in Hex; check the following table to see what is supported.
| Feature | Supported |
|---|---|
| Dimension features | |
| Time, String, Number, Boolean | ✅ |
| Dimensions with case, sub_query | ❌ |
| Measure features | |
| Count, Count distinct, Sum, Average, Min, Max, String, Time, Boolean | ✅ |
| Approximate count distinct, | ❌ |
| Granularities | ❌ |
| propagate_filters_to_sub_query | ❌ |
| Measure filters | ✅ |
| drill_members | ❌ |
| Rolling window | ❌ |
| Join features | |
| many_to_one, one_to_many, one_to_one | ✅ |
| Other features | |
| Pre-aggregations | ❌ |
| Hierarchies | ❌ |
| Calculated measures that reference measures across datasets | ❌ |