Managing Fact Table Configurations¶
You can configure data for the defined fact table in the Fact Table Configuration tab on the fact table page, and edit and publish the fact table configuration.
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.
Fact table definitions that need to be configured with data have been published.
If the Data Source Type of the fact table is set as Import from data table, ensure that a data table has been created in the database.
Creating a Fact Table Configuration¶
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
Select New to enter the New Fact Table Configuration page.
Select the fact table in Basic Information and configure the data source for it.
Fact Table ID: Select a fact table with a published definition.
Fact Table Name: The name will be automatically generated based on the selected Fact Table ID.
Data Source Type
Select Import from Data Table: Import fields from the data table of the data source configured in the fact table definition.
Select Custom SQL: Enter an SQL statement to query a data table in the database to import fields.
Table Name: Select a data table created under the data source.
Select Next to establish the mapping relationship between the fields in the data table and the attributes in the fact table in Field Mappings. The same data table field can map to different fact table attributes.
The Fact Table Field column displays Associated Dimension, Fact Attribute, and Measurement defined in the fact table in advance.
Select an existing field in the data table in Mapping Fields (Source Table).
Select Next to confirm the fact table configuration on the Preview page.
Select Publish to save and publish the fact table configuration.
If you don’t want to publish for the moment, you can Save it as a draft. To publish later, see Publishing a Fact Table Configuration.
After publishing the fact table configuration, the current fact table will be generated in the database configured in the fact table definition.
Editing a Fact Table Configuration¶
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
After selecting the ellipsis (…) at the end of the target fact table row, select Edit
, and then save or publish the changes.
Deleting a Fact Table Configuration¶
To delete a fact table configuration, ensure that the query mapping group associated with the fact table has been deleted in advance. For more information, see Deleting a Query Mapping Group.
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
Select Delete
after hovering over the ellipsis (…) at the end of the target fact table row.
Publishing a Fact Table Configuration¶
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
Fact table configurations with the status 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, then select Publish
at the top of the page to publish fact table configurations in batches.
After the fact table configuration is published, the current fact table can be selected as the data source of the metrics on the Query Mapping tab.
Unpublishing a Fact Table Configuration¶
To unpublish a fact table configuration, ensure that the query mapping group associated with the fact table has been deleted in advance. For more information, see Deleting a Query Mapping Group.
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
At the end of the row of the target fact table with a Published status, select Unpublish
to unpublish the fact table configuration.
Previewing a Fact Table Configuration¶
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
Select Data Preview
at the end of the target fact table row to view the published fact table configuration.
Viewing an Online Version of a Fact Table Configuration¶
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
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 Configuration to an Online Version¶
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
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.
Exporting/Importing Fact Table Configurations¶
Export/import operations are available to share and migrate fact table configurations between different OUs.
Select Fact Tables from the left navigation bar, then select the Fact Table Configuration tab.
Check the published fact tables, select Export, and export a file in JSON format as a template.
Select Import to import a local fact table configuration file.