Defining and Configuring Fact Tables¶

Note

If you perform metric calculation by pass-through APIs in managing query mapping groups, you can skip the fact table definition and configuration steps.

A fact table is a table that records business process details or contains all facts, and each row of the fact table corresponds to a business event. You can define the structure of the fact table in managing fact table definitions and configure data for attributes in the fact table in managing fact table configurations. In addition, you can also map data tables in the database directly to dimension tables in quickly creating fact tables to improve the efficiency of creating fact tables.

The green one in the figure below is an example of a simple fact table. The first row of data represents an event in the fact table: “On June 1, 2022, at site A101, the generation of the wind turbine with the device ID AAAAA is 10000 kWh.” “Power generation” is the measurement in the fact table, “Time ID” is the foreign key connecting the fact table and the time dimension table, and “Site ID” is the foreign key connecting the fact table and the site dimension table.