> ## Documentation Index > Fetch the complete documentation index at: https://cubed3-feat-druid-driver-streaming.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Recipes Home > Step-by-step tutorials and best practices for getting the most out of Cube. Explore **38 recipes** across data modeling, calculations, analytics patterns, pre-aggregations, configuration, APIs, and AI. ## Data Modeling Best practices and conventions for structuring your Cube data models. Compare entity-first and metrics-first ways to structure views for BI tools, apps, and agents. Shape sparse EAV warehouse tables into queryable dimensions and joins. Layer Cube on dbt-built warehouse models, aligning documentation patterns with your semantic layer. Generate measures programmatically from changing reference data. Combine multiple database tables that relate to the same entity into a single cube. Define a custom sort order for categorical values like pipeline stages that don't sort alphabetically. ## Calculations & Metrics Model percentile-based metrics alongside averages for accurate representation of skewed distributions. Express aggregates-of-aggregates like a median of per-group sums using joined cubes and subquery dimensions. Model cross-cube filters so measures aggregate facts while respecting dimensions from related cubes. Compute each dimension member's contribution to the grand total or a fixed subtotal using multi-stage measures. Calculate week-over-week, month-over-month, and other period-over-period metric changes. Let users select filter values and use them in calculations without filtering the entire query. ## Time Series & Calendars Work around non-timestamp time columns by casting strings to proper time dimension types. Implement custom time dimension granularities like fiscal quarters or custom week definitions. Map fact tables to retail or fiscal calendars using dedicated calendar cubes and proxy dimensions. Build point-in-time snapshots from change-history data to report status as of any date. ## User & Event Analytics Measure customer engagement with daily, weekly, and monthly active user metrics. Turn raw clickstream events into session definitions and metrics for product analytics. Implement cohort-based retention analysis to track user engagement over time. ## Pre-Aggregations Accelerate averages, distinct counts, and similar non-additive measures with pre-aggregations. Rebuild only the time-bounded partitions you need instead of refreshing entire rollups. Conditionally disable pre-aggregations based on environment or deployment context. Materialize expensive SQL once with original\_sql, then reuse across rollup pre-aggregations. Partition-level refresh patterns for when dimension values change after initial load. Join data from different warehouses with cross-database rollup joins. Combine a slow-changing fact rollup with a frequently-refreshed lookup rollup using a rollup join. ## Configuration Reference deployment secrets and tunables from environment variables in your config. Enable TLS to upstream databases with custom CA bundles and client certificates. Reduce warehouse spend through pre-aggregation strategy and workload-aware settings. Route each tenant to its own database while reusing a single data model. Give each tenant a unique data model, from completely different to partially shared schemas. ## APIs & Frontend Power filter dropdowns by querying distinct dimension values from Cube's data APIs. Coerce REST (JSON) numeric strings into JavaScript numbers, with precision pitfalls and caveats. Sort query result sets by custom criteria beyond default ordering. Implement paged tables over Cube queries using limit, offset, and deterministic ordering. Configure drill members and fetch detail rows behind an aggregate value. Build live-updating dashboards using WebSocket transport and client subscriptions. ## AI Wrap the Cube Chat API as a LangChain tool so an orchestrating agent can query data on demand.