Build your first cube

Choose dimensions, choose measures, and let the first pre-aggregation run.

Choosing dimensions

Pick the columns you'd want to slice by if you were writing the SQL yourself — region, channel, plan, device. Every dimension you add increases build time and cube size, so start with the ones you already reach for.

Choosing grain

Grain is the finest level the cube can answer at — daily is the common default. Asking a question at a finer grain than the cube was built at triggers a scan instead of a lookup.

Running the build

whyse cube build \
  --source     orders \
  --dimensions region,channel,plan \
  --measures   revenue,orders \
  --grain      day

First builds usually finish within a day. Refreshes after that are incremental.