Granularity

The first step in designing a fact table is to

determine the granularity of the fact table. By

granularity, we mean the lowest level of information

that will be stored in the fact table. This

constitutes two steps:

Determine which dimensions will be included.

Determine where along the hierarchy of each dimension

the information will be kept.

The determining factors usually goes back to the

requirements