Hierarchy flattener

The definition of a hierarchy in the TRIRIGA® Application Platform provides flexibility for implementations with multiple permutations of data hierarchies, for example, organizations. However, reporting tools prefer a more structured data summary to simplify reporting and maximize performance.

The purpose of the hierarchy flattener tool is for an administrator to define a set of named structures that are used by the TRIRIGA Metric Reporting engine to quickly process the hierarchical data within the system. The resulting structure is referred to as a flat hierarchy and these structures are used in a metric reports.

Administrators use the job scheduler, with the help from ETL job items, to run the hierarchy flattener process. System developers trigger the process by using a custom workflow task. In this case, the class name that is used to run the hierarchy flattener process is
com.tririga.platform.workflow.runtime.taskhandler.flathierarchy.
RebuildFlatHierarchies
Triggering the process by using a custom workflow task is discussed in Application Building for the IBM TRIRIGA Application Platform.
Important: Whenever a hierarchy in TRIRIGA is changed, the hierarchy tree is promptly updated. For example, suppose that you add a new triBuilding, then the Location hierarchy is updated. However, the corresponding flat hierarchy for triBuilding is not updated until you rebuild it with a Rebuild Hierarchy Job Item. Therefore, it is important to schedule rebuild hierarchy job items at the same time as when you plan to capture TRIRIGA Workplace Performance Management data through fact tables. Rebuild hierarchy job items ensure that you keep information current.