Hierarchies are created on top of tables. 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.
Hierarchies are available in the navigation under the table they are associated with. You can also use the search above the navigation to locate it.
A hierarchy will look like 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.
1. Create Hierarchy
To create a hierarchy open the Table Designer and click Edit Hierarchies.
A popup window will open to allow you to create hierarchies for your table.
On the left you have a list of the hierarchies associated with your table. Use Add and Remove to create and remove them.
Hierarchy Name: The name of the hierarchy.
Max Height: In the range of 1-6, the default is 6. The max height indicates how deep the hierarchy can be.
Hierarchy attributes work similarily to table columns. Attributes are displayed as columns in the table view, the data from the table is grouped by these attributes. Each hierarchy must have at least one attribute.
2. Import Hierarchy
Importing 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 it's text. Adding more levels will create a deeper hierarchy.