Value (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.
Syntax
Member_Expression[.Value]
Arguments
Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.
Remarks
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]
See Also
MemberValue (MDX)
Properties (MDX)
Name (MDX)
UniqueName (MDX)
MDX Function Reference (MDX)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Uskoro: tokom 2024. postepeno ćemo ukidati probleme s uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zamijeniti ga novim sistemom povratnih informacija. Za više informacija, pogledajtePošalјite i prikažite povratne informacije za