The common set of metadata includes file name, author, createdtime, and updated time; however, in some cases, the common metadata is not sufficient to describe the file properties.
The following steps will illustrate how to build a simple multi-fact model that incorporates a manually createdtime dimension based on a time dimension table found in the underlying database.