Skip to main content


Workday Adaptive Planning Knowledge Center

Set Up Model Dependent Time

Explains how to set up different sheets with different calendars.

Model dependent time is the ability to give different sheets in your model different time structures. 

For additional details on model dependent time behavior, see: 


Required permission:

  • Model Management Access > Model
  • Model Management Access > Time

New to time? See Concept: Flexible Time Modeling.


From the nav menu, select Modeling.

How Model Dependent Time Works

Watch this video: 1m 47s

Model Dependent Time

Example: Your base model could use Month as its leaf time stratum, while a few cube or modeled sheets in your model use Week.  You configure how much of your time structure is available to specific sheets on a per-sheet basis.

The instance has a time structure that rolls up Day > Week > Month > Quarter > Half Year > Year.

The Weekly Revenue Forecast modeled sheet uses Week as its time stratum. The Monthly Expenses modeled sheet and the rest of the model in the same instance uses Month for its time stratum.

Standard accounts (general ledger accounts, custom accounts, etc.) of lower stratum (month) cannot link to or have data entry from a cube or modeled sheet with a higher stratum (quarter).

When you create a new sheet, it first uses the default time stratum of your instance's configured time as indicated in Time Administration. See the Set Up Calendars topic for the full details on configuring time and setting your instance's default granularity.

Modeled and cube accounts inherit their time stratum from the sheets that own them. All standard accounts (metric, custom, assumption, and GL) assume their time stratum from the default of an instance.  Your can see the account time stratum for any account by selecting it and looking at its account details under Data Type.

Sheets and Model Dependent Time

Standard sheets can contain accounts of different time strata, but they display data at the highest time stratum of all of the accounts they contain. If there is a mix of week, month, and quarter accounts, then the sheet will display at quarter.

An individual modeled or cube sheet cannot contain accounts with different time strata. Their time pickers and time axis restrict time to the sheet's chosen time stratum.

Cube-entered GL accounts have the same time stratum as the cube sheet they link to.

Select the Time Stratum for a Cube or Modeled Sheet During Sheet Creation

  1. Select Level Assigned Sheets or User Assigned Sheets.
  2. Select Edit for a cube or modeled sheet.
  3. Select Sheet Properties in the toolbar.
  4. Select  the Settings tab in the Sheet Properties dialog.
  5. Use the dropdown at the bottom of the dialog to select the leaf time stratum for this sheet.
  6. Select OK.
  7. Save.

Change the Time Stratum of a Cube or Modeled Sheet

Changing the time stratum for an existing modeled or cube sheet requires erasing all of the data within it. Selecting the Erase all data button for a sheet deselects manual recalculation for the sheet.

  1. Select Level Assigned Sheets or User Assigned Sheets.
  2. Select Edit for the cube or modeled sheet you want to change.
  3. Select Sheet Properties in the toolbar
  4. Select the Settings tab in the Sheet Properties dialog.
  5. Use the dropdown at the bottom of the dialog to select the leaf time stratum for this sheet.
  6. Select OK.
  7. Save.

Modify Time Strata for Standard Sheets

Standard sheets show the highest time strata of the accounts they contain. For example, if a standard sheet contains only a modeled account of a daily time stratum, the sheet will show time strata of daily and higher (days, weeks, months, quarters, years). If an account of a weekly time stratum were added to the sheet, the sheet would then only allow weeks and higher (weeks, months, quarters, years).

As with cube or modeled sheets, standard accounts cannot have data in them when the default time stratum is changed. 

  1. Select Time.
  2. Select delete and select Erase standard data to clear all data from standard sheets. This will erase all standard data, cell notes and audits. It does not erase shared formulas, metric formulas or master formulas.
  3. At the bottom of the screen, select a different default time stratum from your configured time. If the dropdown is grayed out, you have not removed all of the data in your standard accounts. A tooltip will indicate which accounts still contain data when the dropdown is grayed out.
  4. Select Set.
  5. The default time stratum highlights orange to make it easy to identify at the bottom of the page.

Use Case: Incorporating a Weekly Cube Sheet Into a Calendar Configured for Monthly Data  

Your company uses the standard configured calendar of Month > Quarter > Year and has a large amount of monthly data. You now require a cube sheet containing weekly data but you do not want to erase your monthly data.

To successfully incorporate a Week cube sheet into your Month configured system:

  1. Export your existing calendar from within Time Administration.
  2. Update the exported spreadsheet and insert the required columns of Code, Label, and Shortname for Weeks to left of your Month columns.
  3. Import your edited spreadsheet using the Update option within Time Administration. By choosing Update, you will not erase your monthly data and your default time stratum will remain Month.

Do not use the Reload option in the import calendar dialog for this step as it will erase all data and all versions.

  1. Create a new cube sheet and select Week for its time stratum within the Settings tab of its Sheet Properties.
  • Was this article helpful?