This documentation is archived and is not being maintained.

Value (MDX)

Updated: 17 July 2006

Returns the value of the current member of the Measures dimension that intersects with the current member of the attribute hierarchies in the context of the query.


Member_Expression[.Value] 

Member_Expression

A valid Multidimensional Expressions (MDX) expression that returns a member.

The Value function returns the value of the specified member as a string. The Value argument is optional because the value of a member is the default property of a member, and is value that is returned for a member if no other value is specified. For more information about properties of members, see Intrinsic Member Properties (MDX) and User-Defined Member Properties (MDX).

Examples

The following example returns the value of a member as well explicitly returning the name of the member.

WITH MEMBER [Date].[Calendar].NumericValue as [Date].[Calendar].[July 1, 2001].Value
MEMBER [Date].[Calendar].MemberName AS [Date].[Calendar].[July 1, 2001].Name

SELECT {[Date].[Calendar].NumericValue, [Date].[Calendar].MemberName} ON 0
from [Adventure Works]

The following example returns the value of a member, as the default value that is returned for a member on an axis.

SELECT {[Date].[Calendar].[July 1, 2001]} ON 0
from [Adventure Works]

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
Show: