Hierarchy

The hierarchy contains a list of relationships and defines how attributes roll up. For example, a single Month contains multiple days, establishing a "one-to-many" relationship.

Relationship Properties

Field	Type	Description	Example
`parent`	Object	The higher-level attribute in the relationship.	`{ objectId: "...", name: "Month (2)" }`
`child`	Object	The lower-level attribute in the relationship.	`{ objectId: "...", name: "Day Date (2)" }`
`relationshipTable`	Object	The logical table providing the relationship link.	`{ objectId: "...", name: "lu_day" }`
`relationshipType`	String	Cardinality	`"one_to_many"`

Example

See the following hierarchy file example:

Copy

hierarchy:
  relationships:
  - parent:
      objectId: "D64E2F3746694665BA41851239C168A1"
      subType: "attribute"
      name: "Month (2)"
    child:
      objectId: "5B17B8A3FEA64831878D042B5276C9FB"
      subType: "attribute"
      name: "Day Date (2)"
    relationshipTable:
      objectId: "A2C871BF7FB24D609E9213296EE1B8C7"
      subType: "logical_table"
      name: "lu_day"
    relationshipType: "one_to_many"
  - parent:
      objectId: "BA8E2A784EAA4A2AF3C7A6B17080DADF"
      subType: "attribute"
      name: "Year (2)"
    child:
      objectId: "5B17B8A3FEA64831878D042B5276C9FB"
      subType: "attribute"
      name: "Day Date (2)"
    relationshipTable:
      objectId: "A2C871BF7FB24D609E9213296EE1B8C7"
      subType: "logical_table"
      name: "lu_day"
    relationshipType: "one_to_many"