Managing Fact Table Definitions¶

You can create a new fact table definition in the Fact Table Definition tab on the fact table page, and edit and publish the fact table definition.

Prerequisites¶

Before you start, ensure the following:

The current account has been assigned a menu group containing Fact Tables. If not assigned, contact the application administrator.
The configuration of data source has been completed in Data Source Registration.

Creating a Fact Table Definition¶

Select Fact Tables in the left navigation bar, which goes to the Fact Table Definition tab by default.
Select New to go to the New Fact Table page.
Enter the following Basic Information:
- Fact Table ID: Enter an ID for the fact table that is unique under the current OU.
- Fact Table Name: Enter a name for the fact table.
- Data Connection Type: Select a data connection type. Currently only Data Source Registration is supported.
- Select Data Source: Select a registered database as the storage location of the fact table and its data source.
- Description: Enter a description for the fact table.
Enter the following Fact Table Logic Information:

Fact tables generally include three types of fields: foreign key fields associated with dimension tables, other fact fields, and fields that can be measured.
- Associated Dimension: Select Add to add one or more foreign key fields associated with the dimension table. For example, the Site ID.
  - Attribute ID: Enter the attribute ID as the name of the attribute associated with the dimension table. Must start with a lowercase letter.
  - Description: Enter a description for the attribute.
  - Data Type: Select the data type corresponding to the attribute.
  - Associated Dimension: Select a primary key attribute in the dimension table that has been defined, configured, and published, and then associate it with a fact table attribute.
- Fact Attribute: Select Add to add one or more additional attributes of the fact table. Attributes here generally refer to the time-related attributes that exist independently in the fact table. For example, the timestamp.
  - Attribute ID: Enter the attribute ID as the field in the fact table representing time.
  - Description: Enter a description for the attribute.
  - Data Type: Select the data type corresponding to the attribute.
  - Not Null: Select whether the attribute value is allowed to be empty.
    
    Note
    
    If there are multiple primary keys in the associated dimension table, you must add multiple attributes as foreign keys of the fact table to associate with all primary keys in the dimension table.
- Measurement: Select Add to add one or more fields that can be aggregated.
  - Attribute ID: Enter the attribute ID, which is the column name of the measurement column in the fact table. For example, the active generation and the temperature. Must start with a lowercase letter.
  - Description: Enter a description for the attribute.
  - Data Type: Select the data type corresponding to the measurement. Measurements are generally numeric data.
  - Not Null: Select whether the attribute value is allowed to be empty.
Select Publish to save and publish the fact table definition.

If you don’t want to publish the fact table definition for the moment, you can Save it as a draft. To publish it later, see Publishing a Fact Table Definition.

After saving or publishing the fact table definition for the current fact table, you can view it in the list on the Fact Table Definition tab.

Editing a Fact Table Definition¶

Select Fact Tables in the left navigation bar, which goes to the Fact Table Definition tab by default.
Select Edit at the end of the row in the target fact table, and then save or publish the changes.

Deleting a Fact Table Definition¶

To delete a fact table definition, ensure that the fact table configuration associated with the fact table definition is deleted in advance. For more information, see Deleting a Fact Table Configuration.

Select Fact Tables in the left navigation bar, which goes to the Fact Table Definition tab by default.
Select Delete after hovering over the ellipsis (…) at the end of the target fact table row.

Publishing a Fact Table Definition¶

Select Fact Tables in the left navigation bar, which goes to the Fact Table Definition tab by default.
A fact table definition with a status of Updated for Publish or Draft can be published in the following two ways:
- Select Publish at the end of the target fact table row.
- Check multiple fact tables to publish and select Publish at the top of the page to publish fact table definitions in batches.

After the fact table definition is published, the fact table can be configured on the Fact Table Configuration page.

Unpublishing a Fact Table Definition¶

To unpublish a fact table definition, ensure that the fact table configuration associated with the fact table definition has been deleted in advance. For more information, see Deleting a Fact Table Configuration.

Select Fact Tables in the left navigation bar, which goes to the Fact Table Definition tab by default.
At the end of the target fact table row with the status of Published, select Unpublish to unpublish the fact table definition.

Viewing an Online Version of a Fact Table Definition¶

Select Fact Tables in the left navigation bar, which goes to the Fact Table Definition tab by default.
Hover the mouse over the ellipsis (…) at the end of the target fact table row with the Updated for Publish status, and then click View Online Version to view the fact table configuration in its most recently modified version.

Reverting a Fact Table Definition to an Online Version¶

Select Fact Tables in the left navigation bar, which goes to the Fact Table Definition tab by default.
Hover the mouse over the ellipsis (…) at the end of a fact table for which the status is Updated for Publish, and then select Revert to Online Version to republish the previous fact table configuration.