Using Member Expressions

A member expression contains a member identifier, a member function, or an expression that can be converted to a member.

A member identifier is made up of at least two identifiers: the dimension name, and the member name or member key. A member identifier appears in the following format:

      Dimension_Name
      .[Hierarchy_Name.] [[{Member_Name | &Member_Key}.]... ] {Member_Name | &Member_Key} 

Note

For more information about member names and member keys, see Working with Members, Tuples, and Sets (MDX).

If the path to the member involves a hierarchy other than the default hierarchy of the dimension, you can specify the hierarchy name. If the member appears in any level other than the topmost level of the hierarchy, you can specify one or more parent members.

See Also

Concepts

Expressions (MDX)

Help and Information

Getting SQL Server 2005 Assistance