Fact tables can only be created from a Stage table. The Ajilius workflow loads data, transforms that data through staging tables until it matches your desired fact, then updates the fact from that stage.
To create a fact table from a stage table, select the Create Fact option from the stage table context menu:
You will then be displayed a Fact edit form to set the table details:
|Source Table||Table from which this fact table will be created. This will be the FROM table in the query.|
|Table Name||Name which will be used when creating the new fact table in the data warehouse. Must be lower-case with no embedded spaces.|
|Business Name||Name which describes the business role of this table. This name will be surfaced through metadata in BI tools.|
The transformation to be used when creating the fact table from the stage.
|User and Technical Documentation||Separate support for user documentation and technical documentation.|