Creating a Fact table from a Data Store or Normalised table

The recommended method of creating a Fact table is to create a Stage table and use this as the source for the fact table.

If you try to create a Fact table directly from a Data Store or Normalised table you may see a procedure compile error and the resulting code contains a line like:

FROM *** Enter source table ***

To work around this, rebuild the procedure and check the "Allow Where Clause Editing" box in the fact table procedure build and then type in the FROM clause referencing the Data Store or Normalised table - the procedure will then compile correctly.