Microsoft SQL Server 2005 Analysis Services

are overwritten with the member ALL. But after the attribute Year is implicitly overwritten,

its relating attribute,

Week, is not overwritten. Figure 11.14 demonstrates these rules.

CHAPTER 11 Advanced MDX

180

FIGURE 11.14 The rules of the strong relationships algorithm govern the overwriting of

attribute and members.

If we finally execute the MDX query that we started with at the beginning of this section

SELECT [Time].[Year].CurrentMember ON COLUMNS FROM [Warehouse and Sales]

WHERE [Time].[Time].[Quarter].&[Q1]&[1998]

we’ll get the result we expected—the value of the current member of the Year attribute is

1998, shown in Figure 11.15.

Year 1998

Date