Microsoft SQL Server 2005 Analysis Services

FIGURE 11.25 Tuples outside of the boundaries the subcube can be used in MDX expres-

sions when the query executed in the context of the subcube.

Neither

CREATE SUBCUBE nor SubSelect changes a current coordinate. (We introduced the

concept of the current coordinate in Chapter 10.) For example, if we create a subcube that

contains only the member

1998 and we issue the following query containing the

[Time].[Time].currentmember expression, the query will return the member ALL as the

current member of the

Time dimension, even though that member 1998 has been used to

create a subcube. You can see the results of this query in Figure 11.26.

SELECT [Time].[Time].currentmember ...