Domains

A domain contains all values that are relevant to it. First and foremost, of course, these are the values defined correctly for this domain and within the company.

In a domain, however, you can also define values that are considered synonyms for other values. For example, the value “Germany” can be a valid value, additionally, the value “DE” can be defined as its synonym. In this case, the value “Germany” is also referred to as the master.

You can also define values as invalid, within a domain.

When data is validated via the validation API, the API returns the validation status of the defined value. For a synonym, the master is also returned as a valid value.

Domains can also be set to “Closed Domain” within HEDDA.IO Domain editing menu. The corresponding Domains are displayed in the Explorer with a small lock in the corner of their respective icon, and within the Excel Add-in with a yellow header. If a domain is marked as closed, it can no longer be edited. An import of data from the stage is no longer possible for a closed domain. Validation against this Domain is still possible, however, the values that are not found in the Domain are automatically returned as invalid. You can mark the Domain as open again at any time, by unchecking the “Closed Domain” box.

In order to create a Domain, click on the corresponding button in the “Build & Manage” group of the HEDDA.IO ribbon. The “Create New Domain” dialog will open, where you will need to select a Knowledge Base for the Domain, a Name, the Length of the data (for example 50 characters) and the Algorithm that should be used.

Just like with the Knowledge Base, the arrow under the “Domain” button can be used to edit or delete existing Domains.

You can now open the newly created Domain and start filling in the cells in the “Member” column with data and link it to a “Master”, if required.

By doing so, the data in the “Member” column will be changed to its corresponding “Master” during the execution of the SSIS (SQL Server Integration Services) component of HEDDA.IO, later on.

The easiest way to add Members or change the Master of one or more Members, is with the appropriate buttons in the “Data Tools” options group.

Deleting Members is only possible using the “Delete” button.

Any changes done can be saved with the “Save” button in the HEDDA.IO ribbon and with the “Refresh” button the chart will order itself anew according to the provided data

If no further data is expected to be added to the Domain, you can close the Domain, in order to protect it against any changes.

To do so, navigate to the arrow beneath the Domain button in the HEDDA.IO ribbon, edit the Domain intended to be closed and tag the checkbox “Closed Domain”.

Status and ValidationStatus

Each Member you add to a domain always consists of two validation values, the Status and the ValidationStatus. The status is set if you import members into a domain or copy members using the Excel Add-in and have not yet selected a ValidationStatus. If you change the ValidationStatus of a member, the Status is automatically set to Valid. 

The ValidationStatus of a member, however, can have 5 different values, of which only 3 can be set actively via the drop-down menu in the cell. These values are Unknown, Valid, and Invalid. 

Unknown automatically means that a member has the status New. If you set the ValidationStatus to Unknown, the status is reset to New. With Invalid, you define members that can occur but are invalid. Valid members are marked with the ValidationStatus Valid. 

The two values that cannot be assigned manually are synonym and error. If you assign a master to a member, the validation status is automatically set to synonym. If a member violates an existing business rule, it is flagged as an error. Members with the status Error are excluded from validation by the API. If you have defined business rules, you should not store members in a domain that has the status error.