fiscal_month_offset

Sets a fiscal calendar in Omni and enables adding fiscal time metrics to time dimension groups and filters in the UI.

Sets a fiscal calendar in Omni and enables adding fiscal time metrics to time dimension groups and filters in the UI.

fiscal_quarter and fiscal_year timeframes will not work without a fiscal_month_offset.

This parameter can be set dynamically using a user attribute, which is useful when different users or business units use different fiscal calendars.

Syntax

fiscal_month_offset: positive_or_negative_number

fiscal_month_offset · number

A positive or negative number used to set the fiscal calendar. A positive month offset will set the fiscal calendar in front of the Gregorian calendar date.

Can be set dynamically using user attributes. See the Examples section for an example.

Examples

Static values

Feb 1 start - FY Month 1 of 2025 = Feb 2024

fiscal_month_offset: 11

March 1 start

fiscal_month_offset: 10

Feb 1 start but FY Month 1 of 2024 = Feb 2024

fiscal_month_offset: -1

Dynamic value using user attributes

This example assumes your Omni instance has an existing user attribute called fiscal_offset and that users have been assigned appropriate numeric values, such as 11 for users in Region A, 10 for users in Region B, etc.

Set fiscal month offset based on user's region

fiscal_month_offset: {{ omni_attributes.fiscal_offset }}