| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | ms.custom |
|---|---|---|---|---|---|---|---|---|---|
Value (MDX) |
Value (MDX) |
kfollis |
kfollis |
kfollis |
02/17/2022 |
sql |
analysis-services |
reference |
mdx |
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).
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]
MemberValue (MDX)
Properties (MDX)
Name (MDX)
UniqueName (MDX)
MDX Function Reference (MDX)