Export (0) Print
Expand All
Avg
IIf
Lag
Max
Min
Mtd
Qtd
Sum
Var
Wtd
Ytd
Expand Minimize

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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft