Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Model Dependent Time

Describes Model Dependent Time and how sheets can be configured for its use.

The time structure and default time stratum for your instance are configured in the Time Administration screen. However, It is possible to give different areas of your model access to different time strata from your configured time. This ability is known as Model Dependent Time.

Watch this video: 1m 47s

Model Dependent Time
 

As an example, your base model could use Month as its leaf time stratum, while only 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 diagram below shows the configured time 1 for an instance with a time structure that rolls up Day > Week > Month > Quarter > Half Year > Year.

Model Dependent Time Diagram

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

Standard accounts (GL 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 Time Administration 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.

Sheet and Report Behavior of Model Dependent Time

For additional details on model dependent time behavior, see: 

Create a Sheet: Selecting the Time Stratum for a Cube or Modeled Sheet During Sheet Creation

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

Modify a Sheet: Changing the Time Stratum of an Existing Cube or Modeled Sheet

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

  1. Clear all of the data within the cube or modeled sheet you want to change.
  2. Navigate to Modeling > Model Management.
  3. Select Level Assigned Sheets or User Assigned Sheets.
  4. Click Edit for the cube or modeled sheet you want to change.
  5. Click Sheet Properties in the toolbar
  6. Click the Settings tab in the Sheet Properties dialog.
  7. Use the dropdown at the bottom of the dialog to select the leaf time stratum for this sheet.
  8. Click OK.
  9. Click Save.

Modify a Standard Sheet: 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. Navigate to Modeling > Model Management.
  2. Click on Time.
  3. Click 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.
  4. 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.
  5. Click Set.
  6. 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?