Databases Reference
In-Depth Information
Year
1998
Quarter
Quarter 1, 1998
Not
Overwritten
Week
Month
ALL
Date
ALL
FIGURE 11.15
The rules of the strong relationships algorithm.
we'll get the result we expected—the value of the current member of the
Year
attribute
is
1998
, shown in Figure 11.16. The
Year
attribute has been overwritten and now
appears as
1998
.
1998
98053
FIGURE 11.16
The Year attribute has been overwritten.
Sets in a
WHERE
Clause
So far, all our examples contained one tuple in a
WHERE
clause—we were slicing the cube in
only one layer. Starting from Analysis Services 2005, you can request data sliced by two or
more members. You can specify almost any set expression in the
WHERE
clause.
We'll start with a relatively simple example: Our slice contains an
OR
condition between
members of the same attribute. You need to analyze the units ordered by warehouses
located in different countries over a time period. You aren't interested in the total orders
of all possible products, just products in the Drink and Food categories. To accomplish
Search WWH ::
Custom Search