Going in Production - Expert Cube Development with SSAS Multidimensional Models - page 293

If we run the package to create partitions up to June 2004, this is the result:

The package has added a lot of new partitions:

• Yearly partitions for the years 2001, 2002, and 2003. Note that the 2003

partition does not contain a whole year but only the months from January to
June. Other months are covered by monthly partitions.

• Monthly partitions for the last 12 months up to June 2004.

The Sales partition, that is, the template partition, is still there and still empty.

In this simple implementation, we use only a single template partition.
A more complex implementation could use two different template
partitions: one for monthly partitions and one for yearly partitions,
perhaps with different aggregation designs associated to them.