Every model needs a fact table, which is the center of the star schema. The fact table is composed of one or more relational tables that contain facts, such as units sold or cost of goods, and foreign keys that link the fact table to each dimension table. In this lesson, the fact table will also be used as the Accounts dimension. The Accounts dimension contains numeric data that you want to analyze and track over time, such as sales or inventory; this data is also called variable measures data and enables accounting intelligence during online analytical processing.
To select the fact table: