Hierarchy flattener

The definition of a hierarchy in IBM® Maximo® Real Estate and Facilities 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 Maximo Real Estate and Facilities 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 Maximo Real Estate and Facilities.
Important: Whenever a hierarchy in Maximo Real Estate and Facilities 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 Maximo Real Estate and Facilities Workplace Performance Management data through fact tables. Rebuild hierarchy job items ensure that you keep information current.