Strategy One

Configure ISO-8601 and Custom Calendars

Starting in Strategy One (June 2026), you can create calendars to support calendar based reporting in a project. In addition to Gregorian calendars, you can also create ISO-8601 and custom calendars.

Calendars can be used by models, project schemas, time attributes, and time functions. The selected calendar determines how calendar-based time values, such as weeks and periods, are evaluated.

Create a Calendar

  1. Open the Workstation window.

  2. In the Navigation pane, click Environments.

  3. Right-click an environment and choose Properties.

  4. In the left pane, click Internationalization.

  5. Click New Calendar.

  6. Type a Display Name.

  7. Expand the Base Calendar drop-down list and choose one of the following calendar types:

    • Gregorian Calendar: Creates a standard Gregorian calendar.

    • ISO-8601 Calendar: Creates an ISO-8601 calendar using a selected week grouping pattern.

    • Custom Calendar: Creates a calendar from a provided CSV file.

  8. Complete the required fields for your selected calendar type.

  9. Click Create.

Create an ISO-8601 Calendar

Use an ISO-8601 calendar when your reporting requires ISO-based week and period calculations.

  1. In the New Calendar dialog, type a Display Name.

  2. Expand the Base Calendar drop-down list and choose ISO-8601 Calendar.

  3. Expand the Calendar Begins and Calendar Ends drop-down lists and choose an option.

    If you choose a dynamic date, for example, last year or 5 years later, the Strategy Data Engine will repopulate the Calendar tables automatically when the Intelligence Server machine year changes.

  4. Expand the Week Grouping drop-down list and choose one of the following options:

    • 4-4-5: Groups weeks in a 4-week, 4-week, and 5-week pattern.

    • 4-5-4: Groups weeks in a 4-week, 5-week, and 4-week pattern.

    • 5-4-4: Groups weeks in a 5-week, 4-week, and 4-week pattern.

  5. In Table Prefix, optionally control where in your database the Calendar tables are created. You can assign a dedicated namespace to keep Calendar tables separate from your data.

    This setting can be overridden for each data source under Advanced Properties.

  6. Click Create.

Create a Custom Calendar

Use a custom calendar when your organization needs to define specific calendar structures using a CSV file.

  1. In the New Calendar dialog, type a Display Name.

  2. Expand the Base Calendar drop-down list and choose Custom Calendar.

  3. In CSV File, click Download template (.csv) and complete the CSV template.

  4. In CSV File, click Select a File and upload the completed template.

    The CSV file is required to create a custom calendar.

  5. In Table Prefix, optionally control where in your database the Calendar tables are created. You can assign a dedicated namespace to keep Calendar tables separate from your data.

    This setting can be overridden for each data source under Advanced Properties.

  6. Click Create.

Set the Calendar for a Mosaic Model

Mosaic model linking is only available if the linked models are set to the same calendar setting in each model.

  1. Set up a custom calendar. For more information, see Configure ISO-8601 and Custom Calendars.

  2. Open Mosaic Studio and edit your Mosaic model.

  3. Click Settings.

  4. In the left pane, click Others.

  5. In Time and Calendar, expand the Calendar drop-down list and choose your custom calendar.

Configure Time Attributes for Date and DateTime Attributes

For Date and DateTime based attributes, you can create time attributes for different time intervals. For more information on creating time attributes, see Create a Time Enrichment Attributes and Time Transformation Metrics.

Calendar Behavior

Calendar based reporting uses the calendar selected for the Mosaic schema.

Area Behavior
Time functions

Time functions follow the selected calendar.
Mosaic linking Linked models must use the same calendar setting.
Project schema ISO-8601 calendars, custom calendars, and the Week time attribute are available in the project schema as an extension of the existing Gregorian calendar support.
Date and DateTime attributes Date and DateTime based attributes can use the Week time attribute along with existing time intervals such as Day, Month, Quarter, and Year.

Notes

  • The general requirements for creating and using calendars remain the same as Gregorian calendars.

  • ISO-8601 calendars require a Week Grouping value.

  • Custom calendars require a completed CSV file.

  • If a model uses calendar based reporting, ensure related models use the same calendar setting before linking them.

  • Time functions use the selected calendar when calculating calendar-based values.