Quickly Creating Fact Tables


In addition to defining fact table attributes and configuring data for these attributes on Fact Table Definition and Fact Table Configuration, Quick Create lets you map data tables in the database to fact tables without defining measurements, associated dimensions, and other fields of the fact table in advance. This can significantly improve efficiency when creating fact tables.

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.

  • To select a data table in the database as the data source for the fact table, make sure that you have configured the data source information and created the data table according to data source registration.

Procedure


  1. Select Fact Tables in the left navigation bar, which goes to the Fact Table Definition tab by default.

  2. Select Quick Create and enter the following information on the Basic Information page.

    • Select Data Source: Select the data source type and the name of the data source registered under this type according to data source registration.

    • Data Source Type: Select a type to retrieve data.

    • Table Name: If Import from Data Table is selected as Data Source Type,select a data table in the database as the data source for the fact table from the drop-down box.

    • SQL: If Custom SQL is selected as Data Source Type, enter a custom SQL statement to query a data table in the database as the data source for the fact table.

    • Target Table ID: Enter the unique ID for the fact table under the current OU.

    • Target Table Name: Enter a name for the fact table.

    • Source Table Data Preview: Preview data in the selected data table.

  3. Select Next.

  4. Enter the following configuration information on the Field Mapping page.

    • Data Type: The data type of the current Fact Table Source Field will be used by default. You can change the data type in the drop-down box if necessary.

    • Target Table Field: Enter a name for the fact table attribute, and the name of the current Fact Table Source Field will be used by default.

    • Description: Enter a description for the fact table attribute.

    • Field Category: Fact tables generally contain three types of fields: Foreign key fields associated with dimensions, other fact attributes, and measurement fields.

      • Measurement: To aggregate the fields, select Measurement as the field category.

      • Associated Dimension: To use the current field as a foreign key associated with the dimension table, select Associated Dimension as the field category, and then select the primary key attribute from the dimension table that has been defined, configured, and published in the drop-down box on the right.

      • Fact Attribute: If the current field exists independently in the fact table and is time dependent, select Fact Attribute as the field category.

  5. Select Publish to publish the fact table.


After a fact table is published, you can view the information of the fact table on Fact Table Definition and Fact Table Configuration.