Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Codes for Calendars and Modeled Sheet Display Columns

Codes for Calendars and Modeled Sheet Display Columns

With the 2024R2 Release, we add editable codes for your calendars. We also make codes editable for display columns in modeled sheets.
Note
: This functionality is only available to Adaptive Planning Limited Preview customers at this time. We plan to deliver this to all customers on September 21, 2024.

Business Benefits

This feature brings consistency to your model. Codes enable you to identify your calendars and display columns uniquely.

Changes

For calendars, we now provide:
  • New
    Calendar Code
     fields when you rename your calendars.
  • New
    Calendar Code
     column in the import and export excel sheet for calendars. In the first tab of the import template, we updated the instructions. 
  • Unique codes for existing calendars that we automatically create. The codes match the current calendar names. You can change these codes in the
    Time
    area of
    Modeling
    .
For display columns in modeled sheets, we:
  • Enable you to edit the
    Code
    fields.
  • Automatically update codes for existing display columns to make them unique by appending an underscore and the column number.  You can change these codes in the sheets area of
    Modeling
    .
For the Modeled Sheet Definition API, we:
  • Change the purpose of the
    Code
    field. The
    Code
    field now corresponds to the code for the display column.
  • Add a new field, called
    accountCode
    , which
    is now the code for the account that's associated with the display column.