Create a Fact

A Model Object of type Fact can be created in the Silver Layer.

What is a Fact

In Dimensional modeling, a Fact contains measures and relationships to Entities (foreign keys). Fact data must not be identified by business keys. 

Creation steps

There are two possibilities to create a Fact Model Object:

• Create a Model Object with the Wizard:
  • Recommended possibility
  • Use the Wizard Create Fact from a Stage or a Core Composite that contains the following steps:
    • Create Model Object
    • Create Dataflow
    • Create Multiple Relations
    • Create Relations with Role
    • Map Foreign Key Terms
    • Map selected Terms
    • Add to View
• Create a Model Object manually:
  • Not recommended possibility

• • Create a Model Object of type Fact in the Silver Layer
  • Create a Dataflow Set 
  • Add a Model Object to the Dataflow Set: add the Stage Model Object
  • Add Relationships to Entities
  • Set a Missing BK Behavior for all Relationships
  • Auto-map the Source Terms: select the auto-map mode and auto-map all the Source Terms containing measures in the Source Model Object

Properties

A Fact Model Object can be configured through the following Properties: 

• Implementation Type

Default Terms

A Fact Model Object will include the following Default Terms:  

• BG_SourceSystem
• BG_LoadTimestamp
• BG_ErrorCount
• BG_ErrorDescription
• BG_EffectiveTimestamp
• BG_Cleanse_ID