Fiscal and custom granularity support

[igorlukanin]

Cube supports pre-aggregating data by a time dimension with respect to a chosen granularity. Currently, the following granularities are supported: second, minute, hour, day, week, month, quarter, and year.

We would like to make granularities configurable, including the support for such granularities like "fiscal quarter" (not necessarily aligned with the start of a year).

It's currently planned for October 2024.

Related issues:

• Alternate week granularity to allow for week starting either Sunday OR Monday and other granularities #177

[igorlukanin]

Documentation:

• Time dimensions in the data modeling concepts.
• granularities parameter in the data modeling reference.
• Using proxy dimensions with time dimension granularities.
• Implementing custom time dimension granularities recipe.

Announced in this blog post: https://cube.dev/blog/introducing-custom-time-dimension-granularities