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

• Authenticate requests to Cube with Auth0
• Authenticate requests to Cube with AWS Cognito

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

• Getting unique values for a field
• Implementing pagination
• Passing dynamic parameters in a query

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

Code reusability

• Implementing schema generation

Upgrading Cube

• Migrating from Redis to Cube Store (opens in a new tab)
• Migrating from Express to Docker