Databases Reference
In-Depth Information
The “highest pass wins” rule is applied when calculating a cell using only cube calcula-
tions—cell assignment operators and calculated members. (For more information about
the “highest pass wins” rule, see Chapter 12.) However, when at least one dimension
calculation covers the cell, a different rule applies: This time, the rule is the “closest wins.”
FIGURE 13.8
The results of the query show data for all accounts for 1997.
A cell is covered by a dimension calculation when the cell or one of its descendants is
associated with either a semi-additive measure or a member has a nontrivial unary opera-
tor (anything other than the
+
operator), or has not-
NULL
custom member formula.
The Closest Wins
With the “closest wins” rule, the order of execution of calculations depends on the
distance between the current cell and the cell for which you created the calculation.
We will examine the “closest wins” rule on the same simple cube we have been working
with in previous chapters. It has just one dimension—the
Time
dimension, which has two
attributes:
Year
and
Quarter
. Each attribute has the members shown in Figure 13.9. In this
cube, values are aggregated, starting with members of granularity attribute (at the fact
level)
Quarter
to members on the
Year
attribute, and eventually to the member
ALL
.
All
1
1997
1998
2
Q1
Q2
Q3
Q4
Q1
Q2
Q3
Q4
FIGURE 13.9
The distance between member ALL and Q1 is 2, and between member ALL and
1998 is 1.
Search WWH ::
Custom Search