[Bug] Compatibility Issue with dbt-core 1.9.0 and dbt-metricflow 0.7.1

[mercedes-wu-wandb]

Is this a new bug in metricflow?

• I believe this is a new bug in metricflow
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

I am not able to use cumulative_type_params in dbt-core 1.8.9 since it is a feature in dbt-core 1.9.0. However, when upgrading to 1.9.0 I am told that the latest version of dbt-metricflow (0.7.1) does not support it.

Expected Behavior

Compatibility between dbt-core 1.9.x and dbt-metricflow so newer paramters like cumulative_type_params are supported

Steps To Reproduce

1. In an environment with dbt-metricflow set to 0.7.1
2. Upgrade dbt-core to 1.9.0

Relevant log output

Because dbt-metricflow (0.7.1) depends on dbt-core (>=1.8.0,<1.9.0)
 and no versions of dbt-metricflow match >0.7.1,<0.8.0, dbt-metricflow (>=0.7.1,<0.8.0) requires dbt-core (>=1.8.0,<1.9.0).
So, because analytics depends on both dbt-metricflow (^0.7.1) and dbt-core (^1.9.1), version solving failed.

Environment

- OS: macOS Sonoma 14.7.2 (23H311)
- Python: Python 3.12.3
- dbt: 1.8.9 
- metricflow: 0.7.1

Which database are you using?

bigquery

Additional Context

No response