Creating and managing hierarchies

Note: Changes to your hierarchy are saved automatically after each change you make.
  1. From Modeler Relate, click the Hierarchies icon.


  2. Click + Create.
  3. Specify a Name for the hierarchy, and then click Confirm.
  4. To assign level keys, use the Search field and select the hierarchy level.
    A level key, also called a level key column, is one or more columns of a single dimension in a dimensional hierarchy that uniquely identifies records at that dimension, at that level of the hierarchy.


    Note: We recommend setting the level's cardinality as an estimate for the number of records the level key(s) represent. This does not need to be an exact number. It can be a rough estimate of the order of magnitude for the number of records. This allows the Birst analysis engine to determine the lowest cost way to satisfy a request. When multiple options to satisfy a query are available, Birst always uses the table with lower cardinality.
  5. Select Slowly Changing Dimension for data that changes over time instead of changing entirely at one time.
    When a hierarchy is set to Slowly Changing Dimension, Birst automatically creates two new attributes: Start Date and End Date. The attributes are automatically available in the Subject Area for that hierarchy.
  6. To create duplicate versions of the attributes tied to this hierarchy with a prefix of Current, select Generate current values version of the dimension table.
  7. Click Done.

  8. From this menu, dimension.

To make changes to your hierarchy:

  1. Navigate to the Edit Hierarchies page.
  2. Click More Options for the existing hierarchy. The More Options menu is displayed.
  3. You can Rename, Delete, and enable Show All Snapshots for the hierarchy. When enabled, Show All Snapshots runs the query on all the snapshots for the desired