Advanced MDX - Microsoft SQL Server 2008 Analysis Services - page 171

Dimension

Dimension.Item(0)
When there is only one hierarchy in the dimansion

Dimension.Item(0)
When there is only one hierarchy in the dimension

Dimension.Item(0)

When there is only one hierarchy in the dimansion

Hierarchy

Hierarchy.Default1Member Hierarchy.Defaut1Member

Member

Tuple.Item(0)
When there is only one
member in the tuple

Tuple.Item(0)
When ther is only one

Tuple.Item(0)

(Member) When ther is only one

Member in the Tuple

Member in the Tuple

Tu p l e Level

Tuple.Value Tuple.Value {Tuple} {Tuple} Level.Members Level.Members

Scalar Set

FIGURE 11.14 Objects of certain types can be implicitly converted to other types.

each attribute: The default members are overwritten by the members of attributes specified
in the WHERE clause, and then those members are overwritten by members of attributes
from each axis. When we say overwritten , we mean that the member corresponding to the
attribute is changed. In reality, the process is a little more complicated. Let's take a look at
this complexity in the following query:

SELECT [Time].[Year].CurrentMember ON COLUMNS FROM [Warehouse and Sales]
WHERE [Time].[Time].[Quarter].&[Q1]&[1998]

Our cube has three members of the Year attribute: ALL , 1997 , and 1998 . Assume that you
wrote this query and, when you put a slice on the Quarter attribute, you meant Q1 of
1998. But, if Analysis Services blindly follows the rules defined in Chapter 10, you would
end up with this as the current coordinate:

(..., Time.Year.ALL, Time.Quarter.Q1, Time.Month.ALL,..)