Configure the Sequence Dimension

The Sequence dimension is a special system dimension used to describe abstract steps or “periods after time.” It’s commonly used in models where events unfold relative to a time value — such as depreciation models, efficiency curves, or growth timelines.

Rather than using calendar-based time (like years or months), the Sequence dimension allows you to model concepts like “Year 0”, “Year 1”, … “Year 9” — representing steps from a starting point.

Default Behavior

By default, the system generates a Sequence dimension with values ranging from 0 to 9, which fits most use cases on a yearly level.

However, for more complex models — especially those working on a monthly basis or requiring longer timelines — this range may not be sufficient. In those cases, the maximum number of sequence values must be extended.

How to Extend the Sequence Dimension FOR ADMINS-ONLY

To extend the number of generated Sequence dimension values, follow the steps below.

1. Click the ⚙️ cog icon in the left-hand side navigation bar to open the Admin UI
2. In the Admin UI, go to Projects
3. Select the desired project from the list on the left
4. Below the project’s information on the right, click the Settings button
5. Scroll to or search for the Dimensions section
6. Locate the field: featureFlags.sequenceDimensionAutoGeneratedMax
7. Enter the new maximum number of steps (e.g., 120 for 10 years of monthly steps)

When the Change Takes Effect

The change to the Sequence dimension only takes effect after a re-upload of the data source that contains the SEQ_DIMtable. This is usually the first data source in your project.

After upload, the sequence values will regenerate according to the new maximum.

Important Considerations

• Changing the max value affects how sequence level values are formatted. The Sequence dimension uses fixed-width level values, and the number of leading spaces depends on the maximum.

  For example:

  • Max = 99 → first value = "<space>0"
  • Max = 999 → first value = "<space><space>0"

• Entering sequence values manually in Excel: Use single quotes to preserve leading spaces (e.g. ‘<space><space>0)

• Existing models may need adjustments: If models use the TIMELAG() function or reference specific sequence values, these may need to be updated to reflect the new value format.