cube-js/cube

Default TimeDimensions when Select Dimensions

Open

#5279 opened on Sep 12, 2022

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Rust (19,563 stars) (1,965 forks)batch import
help wanted

Description

Problem

I'm wondering if we can given a default timeDimensions when only selecting dimensions in one query. I mean, it look like cube won't offer a timeDimensions automatically if I firstly choose dimensions. However, if I select measures at the beginning, it will automatically give the first timeDimensions which is defined in backend Schema.

Below are two example, we can clearly see timeDimensions differed from each other.

Firstly choose measures

query  {"measures":["AlarmCodeHistory.count"],"dimensions":[],"segments":[],"timeDimensions":[{"dimension":"AlarmCodeHistory.startTime","dateRange":["2022-09-12T00:00:00.000","2022-09-12T23:59:59.999"]}],"filters":[],"order":[{"id":"AlarmCodeHistory.count","desc":false}],"timezone":"Asia/Taipei"}

image

Firstly choose dimensions

query  {"measures":[],"dimensions":["AlarmCodeHistory.code"],"segments":[],"timeDimensions":[],"filters":[],"order":[{"id":"AlarmCodeHistory.code","desc":false}],"timezone":"Asia/Taipei"}

image

My concern is if we don't give a timeDimension automatically, the query might take much time.

Contributor guide

Tech stack
javascripttypescriptreactnodejs
Domain
frontendapi
Issue type
feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
fresh
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
clear
Prerequisites
Basic understanding of Cube.js query modelFamiliarity with JavaScript/TypeScript
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
50
Research direction
Examine the frontend query builder logic in the Cube.js client library (likely in packages/cubejs client core). Identify where timeDimensions are automatically added when measures are selected, and replicate similar logic for dimensions. The relevant code may be in query builder helpers or default query generation. Refer to the issue examples for expected behavior.