1213
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
53
FIGURE 53-9
Analysis Services dimension usage tab.The Cube Designer creates default relationships based on the data source view relation-
ships, which are accurate in most cases; although, any linked objects require special review
because they are not derived from the data source view. Click the ellipsis in any table cell
to launch the Defi ne Relationship dialog, and choose the relationship type.■ (^) No Relationship: Use this when a dimension does not relate to a fact table. This is
common with more than one fact table present.
■ (^) Regular: This type appears when there is a direct relationship between the dimen-
sion and the fact table, for instance, a customer key in a dimension to a customer
key column in a sales fact table.
■ Fact: Fact dimensions are derived from fact tables, contain both fact and dimension
data, and have a direct relationship to the fact table.
■ Referenced: Used when a table connects to the fact table through another table
with a regular relationship. This is useful for reusing a dimension, for instance, a
geography dimension that relates to both the customer and store dimensions.
■ (^) Many-to-Many: All previous relationships are one-to-many; however, many-to-
many would be authors to books, for instance. One author can write many books,
and each book can have many authors. This relationship requires an intermediate
fact table to list each pair of regular and many-to-many relationships.
Calculations
The Calculations tab, as shown in Figure 53-10, enables the defi nition of calculated mea-
sures, sets of dimension members, and dynamic control over cube properties. Although the
Calculations tab offers forms to view many of the objects defi ned here, the underlying lan-
guage is Multidimensional Expressions (MDX).
c53.indd 1213c53.indd 1213 7/31/2012 10:30:24 AM7/31/2012 10:30:24 AM
http://www.it-ebooks.info