cube-js / cube-js/cube

Metabase sql query

Open
#8,256 6 comments 0 reactions 0 assignees View on GitHub
api:sql pre-aggregations question tool:metabase
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

Hi! It seems that the cube doesn't utilize any pre-aggregations with 2 or more time dimensions

```
dimensions: [
......
CUBE.user_first_touch_date,
.......
],
time_dimension: CUBE.date,
```

```
EXPLAIN
SELECT
CAST("public"."analytics_analysis_view"."date" AS date) AS "date",

DATE_TRUNC('year', "public"."analytics_analysis_view"."user_first_touch_date") AS "user_first_touch_date",

count(DISTINCT "public"."analytics_analysis_view"."distinct_user_count") AS "User Count"
FROM
"public"."analytics_analysis_view"
WHERE ("public"."analytics_analysis_view"."app_name" = 'xxxx')

AND("public"."analytics_analysis_view"."date" >= CAST((NOW() + INTERVAL '-160 day') AS date))
AND("public"."analytics_analysis_view"."date" < CAST(NOW() AS date))
AND("public"."analytics_analysis_view"."user_dimensions_country_code" = 'US')

GROUP BY
CAST("public"."analytics_analysis_view"."date" AS date),
DATE_TRUNC('year', "public"."analytics_analysis_view"."user_first_touch_date")

ORDER BY
CAST("public"."analytics_analysis_view"."date" AS date) ASC,
DATE_TRUNC('year', "public"."analytics_analysis_view"."user_first_touch_date") ASC
```

```

CubeScan: request={
"measures": [
"analytics_analysis_view.distinct_user_count"
],
"dimensions": [],
"segments": [],
"timeDimensions": [
{
"dimension": "analytics_analysis_view.date",
"granularity": "day",
"dateRange": [
"2023-12-05T00:00:00.000Z",
"2024-05-12T23:59:59.999Z"
]
},
{
"dimension": "analytics_analysis_view.user_first_touch_date",
"granularity": "year"
}
],
"filters": [
{
"member": "analytics_analysis_view.app_name",
"operator": "equals",
"values": [
"xxxx"
]
},
{
"member": "analytics_analysis_view.user_dimensions_country_code",
"operator": "equals",
"values": [
"US"
]
}
]
}
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.