Dependent ETLs

Some ETLs depend on other ETLs to assist with the loading process.

The following table shows the ETLs that depend on other ETLs:
Table 1. Dependent ETLs
Fact table name Fact table business object
Building Cost Fact Load ETL This ETL depends on the availability of data in the Financial Summary Table. The Financial Summary Table can be loaded either by backend integration with your financial system or by using the Offline Financial Summary Excel process. To Facilitate the Offline Financial Summary Excel process, there is a special ETL to push the data from the Excel/Offline process to the Financial Summary Table. In the as-delivered TRIRIGA® Workplace Performance Management, the special ETLs are named Load Financial Summary From Offline Staging and Clear Financial Summary From Offline Staging. If you are importing financial summary data with the Offline Financial Summary Excel process, you must first run the Load Financial Summary From Offline Staging ETL. You must then run the Building Cost Fact Load ETL.
Building Fact Load ETL This ETL depends on the availability of data in the Financial Summary Table. The Financial Summary Table can be loaded either by backend integration with your financial system or by using the Offline Financial Summary Excel process. To Facilitate the Offline Financial Summary Excel process, there is a special ETL to push the data from the Excel/Offline process to the Financial Summary Table. In the as-delivered TRIRIGA Workplace Performance Management, the special ETLs are named Load Financial Summary From Offline Staging and Clear Financial Summary From Offline Staging. If you are importing financial summary data with the Offline Financial Summary Excel process, you must first run the Load Financial Summary From Offline Staging ETL. You must then run the Building Fact Load ETL.
Resource Fact Load ETL Dependent on Standard Hours Load ETL.
Standard Hours Load ETL Dependent on Standard Hours Details Load ETL.
Asset Daily Fact ETL

Asset Hourly Fact ETL

Asset Monthly Fact ETL
These ETLs depend on the availability of data in a staging table. The staging table types must be generic. The staging table must include specific fields. The staging table can be loaded by back-end integration with the building management system. The staging table can also be loaded by using an ETL to bring the data in from an external database.
See the Integrated Service Management Library for more details including, sample staging tables and sample ETLs.