Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Date Dimension

The purpose of the date dimension is not just for showing the date value.

The main purpose is about summarizing the data.

Data available at the date level can be rolled up by periods, by weeks, by quarters, by years.

Date hierarchy is typically implemented with the rollup dimensions.

These roll up dimension tables can be used for holding the foreign key from the aggregated facts.

The definition of Gregorian calendar is consistent and common.  Typically the ETL process for populating the gregorian calendar does not need to use data from the OLTP source system.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s