Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Alternate Calendars

Alternate Calendars

With this release, you can now use alternate calendars, enabling you to provide rollup structures for times that differ from your primary calendar.
Watch the video:
 7m 58s

Import Alternate Calendars

Release: 2022-09-10
We now enable you to import up to 3 alternate calendars in the Time area of Modeling. You can now use the TimeStructure spreadsheet to:
  • Add columns for the alternate calendars that map to the leaf strata from the default calendar.
  • Add rows below your default calendar for each alternate calendar.
  • Choose at least 1 common time strata to share with the default calendar. At minimum, the alternate calendars must share the smallest strata with the default calendar.
  • Choose a fork strata for each alternate calendar. The last strata shared with default calendar is the fork strata.
We also provide a new Calendar prompt in the Time area of Modeling, which is separate from the Time Period prompt. The new Calendar prompt enables you to select different calendars so that you can review the alternate time structures and the Strata Rollup section.

Change Calendar Names

Release: 2022-09-10
We provide a new Rename Calendar button in the Time area of Modeling, enabling you to change the names of your imported calendars. We also update the Delete prompt so that you can delete imported calendars.

Improved Visuals in Strata Rollup

Release: 2022-09-10
For added clarity, we now automatically update the Strata Rollup section when you select a calendar in the Calendar prompt in the Time area of Modeling.
We also remove the color indicators and instead display new icons and text as visual indicators, helping you better identify the Default and Fork strata of the calendar you select.

View Alternate Calendars on Reports

Release: 2022-09-10
We now enable you to use alternate calendars to report using time granularities that don’t exist in the default calendar structure. For both OfficeConnect and matrix web reports, we display the default and alternate calendars in the Elements tab in Time.
Report builders can apply different time elements from alternate and default calendars to your reports. Report users can view the data rolled up differently from the default calendar.

View Rollups of Alternate Calendars on Dashboard

Release: 2022-09-10
We now support alternate calendars in dashboards. You can select between the default and alternate time calendars for chart time settings and time filters. We also now support alternate calendars and time rollups on dashboards.

Alternate Calendar Support for APIs

Release: 2022-09-10
To support alternate calendars, we:
  • Deliver a new exportCalendar API that you can use to export default and alternate calendar information, and calendarIds.
  • Update the exportTime API to enable you to export your time configuration by calendarId. We export the default calendar if you don't specify a calendarId.
To use this functionality, you must use v33 or higher in the API requests.

Alternate Calendar Support for Integrations

Release: 2022-09-10
We now enable alternate calendars in Adaptive Planning Integrations. You can select an aggregation stratum from any of your calendars within the Planning Data Source for:
  • Cube sheet sources.
  • Custom sources.

View Alternate Calendars on Sheets

Release: 2022-09-10
Workday now supports alternate calendars on sheets. We add a new Calendar prompt in the display options, enabling you to select up to 3 alternate calendars to display.
To maintain data integrity when you view your sheet using alternate calendars, we prevent you from:
  • Adding a row.
  • Copying a cell value and pasting.
  • Copying a row and pasting.
  • Drilling into transactions.
  • Using Cell Explorer.
You can still save your alternate time selection as your user view state.
We don't support alternate calendars with Excel Interface for Planning.