Hierarchies

Created by: Guðrún Eydís Jónsdóttir

In this article, you are going to learn about hierarchies in exMon DM and how you can create them. Hierarchies are created on top of tables and can be useful in organising exMonDM. There are two ways of creating hierarchies:

  1. Create a hierarchy on an already existing table.
  2. Importing a hierarchy which creates both the base table and a hierarchy on top of it.

Where can I find Hierarchies in exMon DM?

In exMon DM, you can find Hierarchies in the navigation bar, under the table they are associated with. Additionally, you can also use the search above the navigation bar to locate it.


 

Once created, your hierarchy will look similar to this: 



Columns marked like this:  belong to the hierarchy, not the table, and are called hierarchy attributes

Use Add Root/Add child to add branches to the hierarchy. These will belong to the hierarchy and data rows can be grouped together under them. Hierarchy attributes are only applied to branches while the table columns are applied to the data rows. To move nodes between branches use drag and drop.

Making a hierarchy in exMon DM


  1. To create a hierarchy open the Table Designer in an already open exMon DM project.
  2. Click Edit Hierarchies

  3. A popup window will open to allow you to create hierarchies for your table.

  4. On the left, you have a list of the hierarchies associated with your table. Use Add and Remove to create and remove them.
    1. Hierarchy Name: The name of the hierarchy.

    2. Max Height: In the range of 1-6, the default is 6. The max height indicates how deep the hierarchy can be.

  5. Hierarchy attributes work similarly to table columns. Attributes are displayed as columns in the table view, and the data from the table is grouped by these attributes. Each hierarchy must have at least one attribute.

Importing Hierarchy

Importing a hierarchy is similar to importing a table. However, there is an extra step to map columns to hierarchy attributes.

A table that looks like this:

 

Can be mapped like this: 

 

All distinct values in the column that is mapped as Level 1 Hierarchy Attribute will be created as a branch with the corresponding value as its text. Adding more levels will create a deeper hierarchy.

Guðrún is the author of this solution article.