# \#semantic-layer

**URL:** https://discourse.getdbt.com/tag/semantic-layer/99.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [Aggregate Awareness in Semantic Layer](https://discourse.getdbt.com/t/aggregate-awareness-in-semantic-layer/18879)

<div class="topic-metadata">

**Author:** [@imsamant](https://discourse.getdbt.com/u/imsamant)\
**Replies:** 1\
**Last updated:** [December 2, 2025, 2:38am UTC](https://discourse.getdbt.com/t/aggregate-awareness-in-semantic-layer/18879 "2025-12-02T02:38:42Z")

</div>

It would be great if dbt had some way of supporting Aggregate Awareness. i.e. if there is a model in day level, and an aggregate model in week level, depending on whether the query is in day, week, or month level, if dbt…

---

## [Testing Strategies for dbt Semantic Layer](https://discourse.getdbt.com/t/testing-strategies-for-dbt-semantic-layer/19811)

<div class="topic-metadata">

**Author:** [@paishwarya](https://discourse.getdbt.com/u/paishwarya)\
**Replies:** 0\
**Last updated:** [July 9, 2025, 9:15am UTC](https://discourse.getdbt.com/t/testing-strategies-for-dbt-semantic-layer/19811 "2025-07-09T09:15:46Z")

</div>

Our organization is investing big time on the dbt Semantic Layer. The piece we could not find much documentation on was how to test the metrics in the dbt Semantic layer. The major questions in my mind are - How do you…

---

## [Self Service BI Tool with DBT Semantic Layer](https://discourse.getdbt.com/t/self-service-bi-tool-with-dbt-semantic-layer/19672)

<div class="topic-metadata">

**Author:** [@cassandrab](https://discourse.getdbt.com/u/cassandrab)\
**Replies:** 1\
**Last updated:** [June 18, 2025, 1:59pm UTC](https://discourse.getdbt.com/t/self-service-bi-tool-with-dbt-semantic-layer/19672 "2025-06-18T13:59:23Z")

</div>

Hi there, We are building out our dbt Semantic Layer but we are looking for a BI tool to use with it. The BI tool needs to be geared towards business user self service where they can easily create tables and chart from …

---

## [semantic layer sql](https://discourse.getdbt.com/t/semantic-layer-sql/18747)

<div class="topic-metadata">

**Author:** [@rpwils98](https://discourse.getdbt.com/u/rpwils98)\
**Replies:** 1\
**Last updated:** [May 17, 2025, 3:41am UTC](https://discourse.getdbt.com/t/semantic-layer-sql/18747 "2025-05-17T03:41:25Z")

</div>

Hi, I wanted to know if when using the api is it possible to get the sql that is generated by the semantic layer without running the sql.

---

## [Semantic Layer setup is resulting in invalid credentials when integrated with Excel](https://discourse.getdbt.com/t/semantic-layer-setup-is-resulting-in-invalid-credentials-when-integrated-with-excel/17959)

<div class="topic-metadata">

**Author:** [@gontisreejanya](https://discourse.getdbt.com/u/gontisreejanya)\
**Replies:** 0\
**Last updated:** [January 29, 2025, 3:21am UTC](https://discourse.getdbt.com/t/semantic-layer-setup-is-resulting-in-invalid-credentials-when-integrated-with-excel/17959 "2025-01-29T03:21:28Z")

</div>

I have followed the instructions from Set up the dbt Semantic Layer | dbt Developer Hub After I generate service token with snowflake credential, I tried to access metrics in MS Excel for which it is always resulting in…

---

## [Superset don't accept the ratio metric from dbt semantic layer](https://discourse.getdbt.com/t/superset-dont-accept-the-ratio-metric-from-dbt-semantic-layer/17240)

<div class="topic-metadata">

**Author:** [@anhphuwowng2k](https://discourse.getdbt.com/u/anhphuwowng2k)\
**Replies:** 1\
**Last updated:** [December 10, 2024, 2:28am UTC](https://discourse.getdbt.com/t/superset-dont-accept-the-ratio-metric-from-dbt-semantic-layer/17240 "2024-12-10T02:28:26Z")

</div>

I am trying to create the dbt semantic layer. Which provide schema for apache superset. Everything is oke, except that the superset can’t read the out put query, created by dbt metric flow. This is complied query: Some e…

---

## [How to join to an other table in the measure of dbt semantic layer ?](https://discourse.getdbt.com/t/how-to-join-to-an-other-table-in-the-measure-of-dbt-semantic-layer/16954)

<div class="topic-metadata">

**Author:** [@anhphuwowng2k](https://discourse.getdbt.com/u/anhphuwowng2k)\
**Replies:** 0\
**Last updated:** [November 13, 2024, 9:23am UTC](https://discourse.getdbt.com/t/how-to-join-to-an-other-table-in-the-measure-of-dbt-semantic-layer/16954 "2024-11-13T09:23:07Z")

</div>

I don’t know how to use the measure in the expr of an other measure. I am required to convert sql scripts to dbt semantic layer. This is origin sql: Select SUM( CASE WHEN …

---

## [how to use dimension in other dimension](https://discourse.getdbt.com/t/how-to-use-dimension-in-other-dimension/12944)

<div class="topic-metadata">

**Author:** [@mohit199602](https://discourse.getdbt.com/u/mohit199602)\
**Replies:** 1\
**Last updated:** [November 13, 2024, 9:28am UTC](https://discourse.getdbt.com/t/how-to-use-dimension-in-other-dimension/12944 "2024-11-13T09:28:13Z")

</div>

Hi everyone i was doing a POC in dbt cloud for building metrics i was trying to declare a dimension using another declared dimension but when querying the semantic model i was getting error “reason”: “invalidQuery” , …

---

## [DbT Semantic Layer: Average Monthly Value](https://discourse.getdbt.com/t/dbt-semantic-layer-average-monthly-value/15505)

<div class="topic-metadata">

**Author:** [@gbounce](https://discourse.getdbt.com/u/gbounce)\
**Replies:** 0\
**Last updated:** [September 18, 2024, 7:58pm UTC](https://discourse.getdbt.com/t/dbt-semantic-layer-average-monthly-value/15505 "2024-09-18T19:58:11Z")

</div>

Currently trying to create a metric in DbT which corresponds to the average monthly value for stores. With this in mind, I’m creating a derived metric which picks up the base measures and creates the corresponding ratio…

---

## [dbt cloud semantic layer and multi tenancy](https://discourse.getdbt.com/t/dbt-cloud-semantic-layer-and-multi-tenancy/12892)

<div class="topic-metadata">

**Author:** [@mohit1996](https://discourse.getdbt.com/u/mohit1996)\
**Replies:** 1\
**Last updated:** [April 16, 2024, 12:51pm UTC](https://discourse.getdbt.com/t/dbt-cloud-semantic-layer-and-multi-tenancy/12892 "2024-04-16T12:51:49Z")

</div>

Hi, I am unable to get any option for configure semantic layer in the projects section of dbt cloud i have fulfilled all the pre-requisites of semantic layer and i have seen this Use Snowflake, BigQuery, Databricks or Re…

---

## [metricflow self deployment](https://discourse.getdbt.com/t/metricflow-self-deployment/12671)

<div class="topic-metadata">

**Author:** [@adam.nowatkowski](https://discourse.getdbt.com/u/adam.nowatkowski)\
**Replies:** 0\
**Last updated:** [March 30, 2024, 2:08pm UTC](https://discourse.getdbt.com/t/metricflow-self-deployment/12671 "2024-03-30T14:08:28Z")

</div>

SelfDeployment option To this moment i have not found proper instruction for self deployment of semantic model from dbt core - dbt CLI. Due to fact that our main flow is in AirFlow on GCP. We started using dbt CLI with …

---

## [Creating semantic model for customers Recency Frequency and Monetary metrics](https://discourse.getdbt.com/t/creating-semantic-model-for-customers-recency-frequency-and-monetary-metrics/12537)

<div class="topic-metadata">

**Author:** [@advendiodesandros1](https://discourse.getdbt.com/u/advendiodesandros1)\
**Replies:** 0\
**Last updated:** [March 19, 2024, 8:50pm UTC](https://discourse.getdbt.com/t/creating-semantic-model-for-customers-recency-frequency-and-monetary-metrics/12537 "2024-03-19T20:50:59Z")

</div>

Hi guys, I am new to dbt semantic layer and metricflow. I am currently creating a project to leverage the usage of dbt semantic layer in dbt core, to calculate the Recency, Frequency, and Monetary metrics of the customer…

---

## [Issues with saved\_queries and exports in semantic model configuration](https://discourse.getdbt.com/t/issues-with-saved-queries-and-exports-in-semantic-model-configuration/12084)

<div class="topic-metadata">

**Author:** [@mpowell](https://discourse.getdbt.com/u/mpowell)\
**Replies:** 0\
**Last updated:** [February 16, 2024, 9:29am UTC](https://discourse.getdbt.com/t/issues-with-saved-queries-and-exports-in-semantic-model-configuration/12084 "2024-02-16T09:29:42Z")

</div>

The problem I’m having I am trying to create saved\_query items with exports using the latest doc I keep my semantic models and metrics in the same yml named the same as the model its based on. I tried adding a new row a…

---

## [Time zones in the Semantic Layer](https://discourse.getdbt.com/t/time-zones-in-the-semantic-layer/10622)

<div class="topic-metadata">

**Author:** [@jeff.huth](https://discourse.getdbt.com/u/jeff.huth)\
**Replies:** 1\
**Last updated:** [November 4, 2023, 12:29am UTC](https://discourse.getdbt.com/t/time-zones-in-the-semantic-layer/10622 "2023-11-04T00:29:52Z")

</div>

This article is from 2018. What is dbt’s perspective on time zones (and roll-up aggregates to dates or months) with the dbt semantic/metrics layer?

---

## [can Semantic metrics join with normal dim table](https://discourse.getdbt.com/t/can-semantic-metrics-join-with-normal-dim-table/10359)

<div class="topic-metadata">

**Author:** [@xuzheng](https://discourse.getdbt.com/u/xuzheng)\
**Replies:** 0\
**Last updated:** [October 16, 2023, 6:51pm UTC](https://discourse.getdbt.com/t/can-semantic-metrics-join-with-normal-dim-table/10359 "2023-10-16T18:51:06Z")

</div>

Hi All, have some question regarding to the semantic fetures: 1.i have several metrics and want to join them to normal dim table and get dimension attributions for the metrics. wondering what would be the approach. 2.…

---

## [how to add time\_grants to metrics yml files](https://discourse.getdbt.com/t/how-to-add-time-grants-to-metrics-yml-files/10303)

<div class="topic-metadata">

**Author:** [@xuzheng](https://discourse.getdbt.com/u/xuzheng)\
**Replies:** 0\
**Last updated:** [October 11, 2023, 8:10pm UTC](https://discourse.getdbt.com/t/how-to-add-time-grants-to-metrics-yml-files/10303 "2023-10-11T20:10:55Z")

</div>

Hi All, currently is researching dbt sematic feature, but saw below two format to create the metrics. but seems second one always returns errors. wondering , is second version format is out of date? when use first typ…

---

## [dbt + MetricFlow Semantic Layer Best Practices](https://discourse.getdbt.com/t/dbt-metricflow-semantic-layer-best-practices/9463)

<div class="topic-metadata">

**Author:** [@gwenwindflower](https://discourse.getdbt.com/u/gwenwindflower)\
**Replies:** 0\
**Last updated:** [August 8, 2023, 12:13pm UTC](https://discourse.getdbt.com/t/dbt-metricflow-semantic-layer-best-practices/9463 "2023-08-08T12:13:49Z")

</div>

Hi there! This is a long-lived discussion to refine community best practices on building with dbt + MetricFlow for the Semantic Layer. These new superpowers come with some significant impacts on the way we model, and th…