Utilize Datasets with Supported Relationships

To effectively create a HyperIntelligence dataset, your data needs to have attributes with either one-to-one relationships or many-to-one relationships.

A one-to-one relationship means each element in the parent attribute corresponds to only one element in the child attribute, and each child attribute corresponds to only one element in the parent attribute. A common example of a one-to-one relationship is citizen and taxpayer ID. A citizen can have only one taxpayer ID and a taxpayer ID can be assigned to only one citizen.

A many-to-one relationship means each element in the parent attribute corresponds to one and only one element in the child attribute, and each child attribute corresponds to one or more elements in the parent attribute. Many-to-one relationships are the same type of relationship as a one-to-many, but it is defined from a different perspective. For example, year is described above as having a one-to-many relationship to quarter. This means that quarter has a many-to-one relationship to year.

1. In Workstation, select the data to import and click Prepare Data.
2. Click the drop-down arrow for the table you want to modify and choose Define Relationships.

3. Click Add New and select the parent attribute from the Parent Attribute drop-down for the new relationship.

   The parent attribute is at a higher level than the child.

4. Select the child attribute from the Child Attribute drop-down.
5. Select a relationship type from the Relationship drop-down. The relationship is defined as one to many, by default.
6. Click Save.