Configure the Sequence dimension

Learn how to use the sequence dimension and how to configure it.

The sequence dimension is a special dimension type that is used to generically describe steps from a time value, e.g. years or months. It can roughly be understood as "additional time periods" after which something should happen. It can be used to model depreciation, or "growth curves", "efficiency models" and the like.

The default sequence dimension is generated from 0-9, which respects that most models use this on a yearly level. 

For some models the sequence dimension must be extended to support complex scenarios on monthly level. 

This can be done by an administrator in the "Feature Flag" section of the admin page by adjusting

featureFlags.sequenceDimensionAutoGeneratedMax

to the desired number. 

Notice that changing this value will only take effect after a re-upload of the data source that contains the "SEQ_DIM" table (most likely the first data source) and that this change may interfere with current usage of sequences, as the level values change. The sequence dimension uses fixed-width level entries and the width is dependent on the maximum configured value. If your system's maximum is 99 values, the first sequence value is "<space>0", if its configured for 999 the value is "<space><space>0". Entering such values in Excel is typically done with using single quotes, i.e. enter '<space><space>0. You may need to adjust the data of the TIMELAG() function in all models.

You can download an example file for a max value of 999 at the Depreciation Example page.