Syncing from 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 | semantic project |
| cube | model |
| dimension | dimension |
| measure | measure |
| join | join |
| view | view |
| 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 | ✅ |
| View features | |
| Explicit join_paths with included/excluded items | ✅ |
| Folders | ❌ |
| Other features | |
| Pre-aggregations | ❌ |
| Hierarchies | ❌ |
| Calculated measures that reference measures across models | ❌ |