How do I configure my Calendar in Flow?

The foundation of Flow information is the time context against which Flow aggregates, calculates and stores data. In order to configure how Flow creates the underlying time period context you need to create Flow Calendars and Shift Patterns.

For example, your reporting day may start at 06:00 in the morning, your reporting week may start on a Monday, and/or your reporting year may start in March.

To cater for the above-mentioned scenario, you need to create a calendar in Flow with that configuration.  By default, your Flow instance is created with a calendar named Production

If you only need one calendar, then modify/configure the default Production calendar by double-clicking on Calendars > Production in the Toolbox.



General Configuration


The general configuration of a calendar consists of:

  • Description
Short description of the Calendar.
  • Management
By default Flow will manage a Calendar’s time period creation automatically based on the standard Gregorian calendar system, applying the applicable offsets where required.
  • Year starts In
Used to define the month in which the reporting year will start (e.g. financial year).
  • Week Starts On
Used to define the day on which the reporting week will start.
Note: The general calendar settings can only be modified when all Flow Engines are undeployed.


Default Refresh Offset


The Refresh Offset for a measure is the “delay” or offset from the “Period End” to the time the retrieval of a measure will be performed by the Flow Engines. For example, at the end of an hourly period, Flow will wait 60 seconds by default before querying any data sources for measure values.

Each calendar has a set of default refresh offsets that will be used when a calendar is first linked to a measure when that measure is created. The refresh offset for that measure can be edited independently of the Calendar setting if required.

Note: It is possible to create multiple calendars in Flow.  For example, you may need another calendar for Finance reporting, which might run from January to December instead of March to February. Or, the Finance day may begin and end at midnight, while the Production day begins and ends at 6am.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request