Metrics structure

The TRIRIGA Workplace Performance Management functionality focuses on capturing metric facts and enabling metric reporting.

Most TRIRIGA® metrics are multidimensional, where the same metric provides a high-level summary view (for example, the Total Operating Cost/Area for the entire organization and portfolio) and, by drill down through various dimensions or filters, a role-specific view (for example, Total Operating Cost/Area for North American Operations for the facilities that are managed by North American operations).

Metrics measure process performance that is capable of identifying actionable results. Typically, the measures are ratios, percentages, or scores. Metrics have targets, thresholds, action conditions, accountability, and action task functionality.

TRIRIGA Workplace Performance Management includes the following types of metrics, which are the Scorecard categories in the Key Metrics portal section:
Customer Metrics
Measure customer satisfaction
Financial Metrics
Measure financial performance
Portfolio Metrics
Measure operational utilization and asset life cycle health
Process Metrics
Measure process efficiency and effectiveness
Reporting and Analysis Metrics
Analyze a specific performance metric
Additionally, TRIRIGA Real Estate Environmental Sustainability includes the following types of metrics:
Environmental
Measure performance of environmental initiatives
Building meters
Measure characteristics of a building as reported by meters and sensors

The following high-level process diagram depicts how metrics are defined, captured, and presented to the user:

Definition, Capture, and Presentation of Metrics

The TRIRIGA database is the primary source of data for gathering operational data to be loaded into fact tables. Optionally, you can extract data from other sources to be loaded into fact tables.

Each fact table contains the lowest level of aggregated data (such as Building level) for each metric category. For efficiency reasons, a fact table is a de-normalized (flattened) table containing data elements from multiple TRIRIGA tables.

The dimension table contains dimensions for each metric. Dimensions are stored in a separate table for efficiency. The fact table contains a key (Spec ID) for each dimension. The dimension table can be either a flat hierarchy table or an TRIRIGA business object table.

The Metric Processing Engine (Analytic/Reporting Tool) generates metrics using data stored in fact tables along with metric setup data and dimension data.

Metric data, along with notifications, actions, and alerts, are presented to users in a role-based portal in various forms (including reports, queries, and graphs) as defined in the metric setup table. A user can drill down into a specific object or drill path to further analyze the metric data presented to them.

Metric reporting is dependent on metric fact tables. These fact tables are implemented using the Data Modeler but are identified with a unique object type that signifies that it is a metric object. Metric objects are populated using an ETL development environment, which is different from all other object types that are updated through the metadata layer. The scheduling of the ETL process is controlled from within the TRIRIGA system using the Job Scheduler.