6.4.1 Create an Extend Fact Entity

To create an Extend Fact Entity for an Action, do the following:

1. Go to the Inbox by clicking the Inbox Button on the Home Page. The Inbox Page is displayed.
2. To create a Extend Fact Entity for an Action, do the following:
   1. Select the required Action for which you need to Extend Fact Entity. The Action Details Page is displayed.
   2. On the Extension Tab, click Extend Fact. The Extend Fact Entity Page is displayed.
   3. On the Definition Tab, set the following values.

      Table 6-7 Extend Fact Field Names and Description on the Definition Tab

      Field Name	Description
      Grain/Grain Group	Select one of the following categories for the Entity: Customer Account Transactions Accounting Entries Customer Account Others Select the appropriate grain for the entities to be extended
      Include Entities	Select an Entity from the list of available entities. Note: The list of unsupported entities for extension are Dimension, Stage Master and Stage Hierarchy Tables.
      Add Entity	Click this button to add this Entity in the Entities List.
      Remove Entity	Select the entity, and click this button to remove an entity from the added list of Entities.
      Available Business Terms	Select one or more Business Terms to the Fact Entity: Nullable: If a Business Term has Null value or not Default Value: The Default value for the Business Term Reference Entity: The list of dimensions for which Business Terms is a Business Key. Note: If you disable the Nullable option for an added Business term, then it is mandatory to add a default value for the same business term. Verify the Business Terms that are not already part of the entity(s) to be extended. Mark the business terms as not null only when absolutely necessary. In case of a BT marked as not null, system mandates to provide a default value as per the data type and data length of BT definition. Avoid adding alphanumeric business terms to fact entity(s) which does not have an associated dimension. The system populates the dimension list referenced by a Business Term and allows you to select the referenced dimension entity in case of multiple references. In case of single reference entity, the reference entity is auto-populated.
      Add Attribute	Click this button to add this Attribute in the Business Terms List.
      Remove Attribute	Click this button to remove an attribute from the added list of Business Terms.

   4. Click Save. A confirmation message is displayed. Click OK. On the Extension Tab, in the Entity Extensions Section, the new Fact Entity is listed.

      You must select the appropriate grain or group for the entities to be extended and verify if the Business Terms are not already part of the entity(s) to be extended. The Best practice is to add a referenced dimension before adding an alphanumeric Business Terms to the fact entities.

      You must limit the number of extensions to 50 Business Terms for each Fact Entity.

      You can create the Data Quality pipeline for the extension generated Data Quality checks for the extended entity.

      Note:

      Once a Fact Extension has been Approved it cannot be modified or removed from the Extension.
3. If you want to update a draft Extend Fact Entity for an Action, do the following:
   1. Click the required Action for which you need to update an Extend Fact Entity. The Action Details Page is displayed.
   2. On the Extension Tab, click the Extend Fact Entity that you need to update.
   3. The Entity Details Page is displayed. You can update any Field.
   4. Click Save. A confirmation message is displayed. Click OK. On the Extension Tab, in the Entity Extensions Section, the new Extend Fact Entities are listed. Click outside the Action Details Page to close it.