Time-series data can be linked from a database in a similar manner to that for model element defaults, with the caveat that the type of the time series must be inferred from the labels in the database. For example, if a Resource is being linked from a database and the Maximum Utilisation field is defined as a Floor & Multiplier, then this is represented in the database as follows:
Figure 1: Sample database query including Floor & Multiplier
Interpolated series
If the Maximum Utilisation is an Interpolated Series, then each separate value must be defined in a separate row of the query, using an additional ‘Year’ column (or the fourth column) to identify the corresponding year:
Figure 2: Sample database query including Interpolated Series
Note: The field labels must be repeated in each row so that the result is not dependent on the order in which the rows are returned by the query. This approach is quite different from the spreadsheet layout, where Interpolated Series values extend orthogonally from the main value column, exploiting the greater flexibility of a spreadsheet compared to a database.
Individual time series
If you want to link an individual time series from a database, through a formula on a button, the abbreviated labels in the database are as follows:
Figure 3: Sample database query for single Floor & Multiplier
Figure 4: Sample database query for single Interpolated Series