# \#metricflow

**URL:** https://discourse.getdbt.com/tag/metricflow/100.md

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

---

## [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:** 1\
**Last updated:** [October 9, 2026, 12:05pm UTC](https://discourse.getdbt.com/t/metricflow-self-deployment/12671 "2026-10-09T12:05:29Z")

</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 …

---

## [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…

---

## [metrics - semantic model model missing](https://discourse.getdbt.com/t/metrics-semantic-model-model-missing/17651)

<div class="topic-metadata">

**Author:** [@sreenig](https://discourse.getdbt.com/u/sreenig)\
**Replies:** 8\
**Last updated:** [January 9, 2025, 8:04pm UTC](https://discourse.getdbt.com/t/metrics-semantic-model-model-missing/17651 "2025-01-09T20:04:12Z")

</div>

I modified the metrics,yml config file to the latest standards. Example snippet from the file, name: total\_sales description: “The total value of sales” type: simple label: “Total Sales” type\_params: measure: nam…

---

## [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 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” , …

---

## [Help using Metricflow with postgres](https://discourse.getdbt.com/t/help-using-metricflow-with-postgres/16899)

<div class="topic-metadata">

**Author:** [@mdlmarkham](https://discourse.getdbt.com/u/mdlmarkham)\
**Replies:** 0\
**Last updated:** [November 9, 2024, 2:24pm UTC](https://discourse.getdbt.com/t/help-using-metricflow-with-postgres/16899 "2024-11-09T14:24:30Z")

</div>

The problem I’m having I would like to use metricflow to define and manage metrics on a PostgreSQL database using dbt-core. I’ve been able to set up and use dbt-core by itself, but whenever I try to bring in metrics I s…

---

## [Can you use ephemeral materializations in MetricFlow semantic models?](https://discourse.getdbt.com/t/can-you-use-ephemeral-materializations-in-metricflow-semantic-models/15093)

<div class="topic-metadata">

**Author:** [@Henry-Pulver](https://discourse.getdbt.com/u/Henry-Pulver)\
**Replies:** 0\
**Last updated:** [August 22, 2024, 2:10pm UTC](https://discourse.getdbt.com/t/can-you-use-ephemeral-materializations-in-metricflow-semantic-models/15093 "2024-08-22T14:10:06Z")

</div>

I’m trying to define MetricFlow semantic models built on top of materialization: ephemeral dbt models. Getting this error from dbt parse command when using dbt Core CLI: node\_relation -\> relation\_name none is not an a…

---

## [dbt metricflow execution](https://discourse.getdbt.com/t/dbt-metricflow-execution/14238)

<div class="topic-metadata">

**Author:** [@GaneshSubramani](https://discourse.getdbt.com/u/GaneshSubramani)\
**Replies:** 1\
**Last updated:** [July 13, 2024, 7:56am UTC](https://discourse.getdbt.com/t/dbt-metricflow-execution/14238 "2024-07-13T07:56:07Z")

</div>

I am using dbt-core, version 1.8.3. I have defined semantic model and metric. Is it possible to refer the metric in the dbt model like it is supported in dbt 1.4.x using metrics.calculate method? Or metricflow allows j…

---

## [About dbt metric flow timeline](https://discourse.getdbt.com/t/about-dbt-metric-flow-timeline/13555)

<div class="topic-metadata">

**Author:** [@mohit199602](https://discourse.getdbt.com/u/mohit199602)\
**Replies:** 1\
**Last updated:** [June 8, 2024, 10:40am UTC](https://discourse.getdbt.com/t/about-dbt-metric-flow-timeline/13555 "2024-06-08T10:40:10Z")

</div>

Hi, i wanted to understand about the dbt MetricFlow time spine. I have few doubts regarding it. Why do I need metricflow time spine when i have a time dimension mapped to every metric and measure associated to it. What…

---

## [How to create measures in dimensional tables without time dimensions](https://discourse.getdbt.com/t/how-to-create-measures-in-dimensional-tables-without-time-dimensions/12773)

<div class="topic-metadata">

**Author:** [@pedromnasc](https://discourse.getdbt.com/u/pedromnasc)\
**Replies:** 1\
**Last updated:** [May 13, 2024, 1:47pm UTC](https://discourse.getdbt.com/t/how-to-create-measures-in-dimensional-tables-without-time-dimensions/12773 "2024-05-13T13:47:12Z")

</div>

Hi! How can I create measures in dimensional tables without time dimensions? It seems that having a primary time dimension is a requirement from metricflow when creating a data source with measures. However, I would l…

---

## [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…

---

## [Does metricflow not support having operations in sql? Is there a way to concatenate sql with having statements with mf?](https://discourse.getdbt.com/t/does-metricflow-not-support-having-operations-in-sql-is-there-a-way-to-concatenate-sql-with-having-statements-with-mf/11628)

<div class="topic-metadata">

**Author:** [@rourou](https://discourse.getdbt.com/u/rourou)\
**Replies:** 1\
**Last updated:** [January 23, 2024, 6:22pm UTC](https://discourse.getdbt.com/t/does-metricflow-not-support-having-operations-in-sql-is-there-a-way-to-concatenate-sql-with-having-statements-with-mf/11628 "2024-01-23T18:22:50Z")

</div>

The problem I’m having Does metricflow not support having operations in sql? Is there a way to concatenate sql with having statements with mf?

---

## [Handling missing data for time dimensions](https://discourse.getdbt.com/t/handling-missing-data-for-time-dimensions/11417)

<div class="topic-metadata">

**Author:** [@gowtham](https://discourse.getdbt.com/u/gowtham)\
**Replies:** 1\
**Last updated:** [January 5, 2024, 6:16pm UTC](https://discourse.getdbt.com/t/handling-missing-data-for-time-dimensions/11417 "2024-01-05T18:16:09Z")

</div>

I have a use-case where I want to see SalesQuota by month. In my database, I might not have rows for a particular month in which case I want to map it to a default value (like 0, for example). The SQL generated in Metri…

---

## [Is there an OOB support for Fiscal Year, quarter etc in MetricFlow?](https://discourse.getdbt.com/t/is-there-an-oob-support-for-fiscal-year-quarter-etc-in-metricflow/11418)

<div class="topic-metadata">

**Author:** [@gowtham](https://discourse.getdbt.com/u/gowtham)\
**Replies:** 0\
**Last updated:** [January 5, 2024, 8:49am UTC](https://discourse.getdbt.com/t/is-there-an-oob-support-for-fiscal-year-quarter-etc-in-metricflow/11418 "2024-01-05T08:49:43Z")

</div>

I have some tables which have a timestamp column, I would want to visualize them based on Fiscal year, quarter etc., I see that the MetricFlow directly displays the quarter in timestamp which is fine. But if I want to v…

---

## [Create customer calender in Metricflow](https://discourse.getdbt.com/t/create-customer-calender-in-metricflow/10133)

<div class="topic-metadata">

**Author:** [@dbt5](https://discourse.getdbt.com/u/dbt5)\
**Replies:** 0\
**Last updated:** [September 28, 2023, 11:56am UTC](https://discourse.getdbt.com/t/create-customer-calender-in-metricflow/10133 "2023-09-28T11:56:44Z")

</div>

The problem I’m having We just upgraded to a verion 1.6.2 and had to migrate from dbt-metrics to Metricflow. We have defined a customer calender with customer time grains, but we couldn’t make it work with Metricflow. I…

---

## [Not able to enable metric in dbt-cloud for Metric Store developement](https://discourse.getdbt.com/t/not-able-to-enable-metric-in-dbt-cloud-for-metric-store-developement/10117)

<div class="topic-metadata">

**Author:** [@badal.panda](https://discourse.getdbt.com/u/badal.panda)\
**Replies:** 0\
**Last updated:** [September 28, 2023, 3:09am UTC](https://discourse.getdbt.com/t/not-able-to-enable-metric-in-dbt-cloud-for-metric-store-developement/10117 "2023-09-28T03:09:00Z")

</div>

Hi , I am using the latest dbt-cloud and trying to build a project where I am creating a metricstore. But I am not able to define the Metric Config either in dbt\_project.yml or in a separate metric.yml. I am using the j…

---

## [MetricFlow with Tableau (and is Semantic Layer necessary)](https://discourse.getdbt.com/t/metricflow-with-tableau-and-is-semantic-layer-necessary/10012)

<div class="topic-metadata">

**Author:** [@hjv](https://discourse.getdbt.com/u/hjv)\
**Replies:** 0\
**Last updated:** [September 20, 2023, 5:54pm UTC](https://discourse.getdbt.com/t/metricflow-with-tableau-and-is-semantic-layer-necessary/10012 "2023-09-20T17:54:12Z")

</div>

Has anyone used the MetricFlow successfully yet? I know it’s newer to dbt, and I haven’t been able to find a lot of successful implementation stories online. I cannot tell from the documentation is the Semantic Layer …

---

## [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…