Facts Dimensions and Grain

A fact table is a table in which each row records one measurement of a business process, such as one line of one sale, with keys for everything the measurement involves. A dimension table holds one row for each thing those keys point to, such as a store, with the names reports group by. Analytics Tables and Application Tables built one fact table and two dimension tables for a pharmacy chain.