Recipes
These recipes will show you the best practices of using Cube.
Analytics
- Calculating daily, weekly, monthly active users
- Implementing event analytics
- Implementing funnel analysis
- Implementing retention analysis & cohorts
Authentication & Authorization
Access control
- Enforcing role-based access
- Enforcing column-based access
- Enforcing mandatory filters
- Controlling access to cubes and views
Data sources
- Using multiple data sources
- Using SSL connections to a data source
- Joining data from multiple data sources
Data modeling
- Calculating average and percentiles
- Implementing data snapshots
- Implementing Entity-Attribute-Value model
- Using different data models for tenants
- Using dynamic measures
- Using dynamic union tables
Queries
Query acceleration
- Accelerating non-additive measures
- Using originalSql and rollup pre-aggregations effectively
- Incrementally building pre-aggregations for a date range
- Refreshing select partitions of a pre-aggregation