Skip to main content
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

​
Properties

​
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
March 1 start
Feb 1 start but FY Month 1 of 2024 = Feb 2024

​
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