Databases Reference
In-Depth Information
Figure 5-5
4. On the dimension type selection page of the Dimension Wizard (see
Figure 5-6
) you see three options: Standard Dimension, Time Dimen-
sion, and Server Time Dimension. A Standard dimension can be
modified to become any sophisticated dimensional variant and
makes for a great generic starting point. A Time dimension, on the
other hand, is a unique type of dimension typically created from a
table that contains time information such as year, semester, quarter,
month, week, and date. A Time dimension is unique because its
members are fixed (a year always has 12 months in it) and typical
business analyses are performed over time. Due to the uniqueness
of the Time dimension and how it is used for business analysis, there
are special MDX functions that can be used along with time dimen-
sion. Furthermore, aggregation of data on a time dimension does not
have to be a garden variety aggregation like sum or count.
Search WWH ::
Custom Search