| title | Value (MDX) | Microsoft Docs |
|---|---|
| ms.date | 06/04/2018 |
| ms.prod | sql |
| ms.technology | analysis-services |
| ms.custom | mdx |
| ms.topic | reference |
| ms.author | owend |
| ms.reviewer | owend |
| author | minewiskan |
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)