Follow

Can I have more than one Calendar in Flow?

Yes you can!

At times, you may need to report in different time contexts.  For example, your production day may run from 6am to 6am, and the week from Monday to Monday.  But, when the bean counters are doing their cost accounting, they're interested in the week from Sunday to Sunday, and a day from midnight to midnight.

Flow understands that this is a common requirement, so to add a new calendar is relatively effortless.

Right-Click on Calendars > New > Calendar

Toolbox-MultipleCalendars-AddNew.png

Give your calendar a fitting name, e.g. Finance

Toolbox-MultipleCalendars-Named.png

While here, notice that one calendar has a bold typeface (e.g. the Production calendar in the previous image), while the others are normal.  The calendar in bold is called the "Default Calendar".  If you wish to make another calendar your default, right-click on a calendar that is not already a default, and select the option Set as Default

Toolbox-MultipleCalendars-SetAsDefault.png

Note: When you set a calendar as your Default Calendar, this only applies to your own Flow Config tool, and is not a property that is global to all users.  All measures created on your Flow Config tool will have the Default Calendar set as context.  Be careful that this is what you indeed want, or it will mean later adding the correct calendar and deleting the incorrect calendar from all the measures that you created while the incorrect calendar was set as Default.

In our case, our Finance calendar is not our default, so leave Production as the Default Calendar.

Double-click the Finance calendar to open its property editor window

Toolbox-MultipleCalendars-FinanceCalendarConfiguration.png

Now you can configure your additional calendar as required.  For all measures that you need to associate the Finance Calendar with (those that you need to report on according to both the Production and Finance calendars), you will need to open the measure editors and drag the Finance calendar into the Context tab. 

Note: You will first need to undeploy the measure before adding the new calendar, after which you should redeploy it.

Toolbox-MultipleCalendars-AddFinanceCalendarToMeasure.png

Once you've added the additional Calendar Context, the Data Engine will fetch data from the Backfill datetime and allocate the values into the time periods defined by the Finance calendar in addition to the previously defined time periods for the Production calendar.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments