[Feature] Support cumulative_type_params in semantic manifest

[courtneyholcomb]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

DSI has recently moved fields related to cumulative metrics from the type_params field to type_params.cumulative_type_params. This creates better organization in the metric spec, and also includes a new field called type_params.cumulative_type_params.period_agg which is used to re-aggregate cumulative metrics for non-default granularities. Add support for this field in core.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response