When you open a DataModel object on the Model Instance Editor screen, you can see existing instances of this object in the As Of Date list (see the following figure). These instances are distinguished by the date and instance of key parameters. The latest instance is selected by default.
Note: If the open DataModel object has no instances, the As Of Date box is unavailable.
You can switch between the DataModel instances to view or modify the associated data, create a new or delete an existing DataModel instance.
When a DataModel instance is selected the data associated with it (i.e. the DataSource instances on which this DataModel instance is based) is displayed in the table below. The records in this table correspond to nodes of the hierarchy that determines the DataSource objects on which the open DataModel object is based and the relationships between these DataSource objects. (This hierarchy must be created on the respective Data Model Setup screen before.)
The table consists of six columns, each of which corresponds to a certain property.
- Alias: the name of a corresponding hierarchy’s node.
- Source: The name of the DataSource object to which this node is mapped.
- Source Instance: a list of existing instances of this DataSource object (see the following figure). These instances are distinguished by the date and instance of key parameters. You can select any of them. If the Data Source Type parameter4 of the DataSource object is ‘PERMANENT’ then this list can contain only one item: ‘PERMANENT’.
- Table: the name of the table in which the selected DataSource instance is stored.
- Status: The state of a record. It can be either ‘<EMPTY>’ or ‘ACTIVE’ (see an example in the following figure).
# <EMPTY>: a DataSource instance has not been selected for this record yet or the selected DataSource instance has been lost (e.g. deleted).
# ACTIVE: a valid DataSource instance is selected for this record.
- Reset Outdated Instance: this column can contain Reset buttons, which are used to re-select DataSource instances in the Source Instance list automatically. Re-selecting is required when the open DataModel object is based on DataSource objects located in other soft branches and the condition (i.e. expression) to refer to these soft branches has been changed. (Such case is checked each time you open a DataModel object on the Model Instance Editor screen.) The Reset button is hidden if the re-selecting is not needed. For information about the soft branch functionality, see the “Soft Dependencies” document.
To create a new DataModel instance, click the Create new button (see the following figure), and then type the date and instance keys (if needed) in the open Create new instance dialog boxes.
Note: If the type of a DataModel object is ‘PERMANENT’5, this object can have only one instance. It is identified as ‘PERMANENT’ in the As Of Date list.
After a DataModel instance has been created or modified (e.g. one or more underlying DataSource instances have been re-selected), it should be saved.
The Status box next to the Create new button shows the state of a selected DataModel instance. It is unavailable for modifying and can be ‘<EMPTY>’, ‘ACTIVE’, or ‘INCOMPLETE’.
- <EMPTY>: the DataModel instance has just been created and not yet saved (i.e. it does not exist).
- ACTIVE: the statuses of all the records associated with this DataModel instance are ‘ACTIVE’.
- INCOMPLETE: at least one of the records associated with this DataModel instance has status ‘<EMPTY>’. In such a case, a DataModel instance cannot be saved.
The Populate missing source instances button selects DataSource instances in the Source Instance lists automatically to make the corresponding records ‘ACTIVE’. Certain Source Instance fields might be left unpopulated if two or more equivalent options exist (for example, there are two DataSource instances as of different dates, and the AsOfDate parameter of the created DataModel instance does not match either of these dates). In this case, you are asked to select a DataSource instance manually.