[Core] Behavior change for cumulative type params

[DevonFulcher]

Link to the page(s) on docs.getdbt.com requiring updates

https://docs.getdbt.com/reference/global-configs/behavior-changes

Tell us more about this update

Cumulative metrics type params have changed so that they are nested under a cumulative_type_params field. See the change in docs from 1.8 to 1.9 here. So, a behavior change is needed to notify users of this deprecation. The behavior change is called require_nested_cumulative_type_params.

Reviewers/Stakeholders/SMEs

@courtneyholcomb, @Jstein77, @DevonFulcher, @MichelleArk.

Related GitHub issues

dbt-labs/dbt-core#10960

Additional information

No response