If you can't find the product or version you're looking for, visit support.ataccama.com/downloads

Hierarchies

Hierarchies allow users of the web application to view data based on parent-child relationships between tables. To learn more, see Data Tab Overview, section Hierarchies. Hierarchies are defined in the RDM Logical Model > Hierarchies node.

Create a hierarchy

Right-click Hierarchies > New hierarchy.
Fill in the attributes on all hierarchy levels.
Select OK to save changes.

Make sure that all tables used in the defined hierarchy have at least one column with Display mode set to label. See Tables for instructions.

Expanded tables display values of these columns when you browse hierarchies in the RDM web application. If no column has Display mode set to label, hierarchy tables expand with empty values.

Hierarchy attributes

Hierarchies have the following attributes:

Field

Required

Description

Enable

N/A

Easily enables or disables the hierarchy without losing the configuration.

Hierarchy name

Name of the hierarchy to be used in the configuration process.

Hierarchy label

Name of the hierarchy shown in the web application.

Root table

Name of the table that will be the top level node of the hierarchy.

Order by

Values are ordered by the column specified here.

If this column and the label column (see the previous note) are the same, the displayed values are sorted alphabetically.

Child tables

Allows adding child tables into the hierarchy:

Name - Name of a child table.
Label - (Optional) Name of the child table as shown in the web application.
Relationship - Name of the relationship between the parent and the child table.
Order by - Values are ordered based on the column specified here (works the same way as in the root table).
Child tables - Allows defining other levels of child tables.

Hierarchy views

Allows adding an already defined view to the hierarchy. The view should be placed at a level of the hierarchy where the view base table corresponds to either a child table or the parent table on that hierarchy level.

Hierarchy example

The following image shows all levels of a hierarchy, with the last level having no more child tables.

Was this page useful?