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

MemberValue (MDX)

Updated: 17 July 2006

Returns the value of a member.


Member_Expression.MemberValue

Member_Expression

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

The member value returned contains the following information, listed in the order that this information appears in the return value:

  • The value binding, if it has been defined.
  • The key with the original data type if either there is no name binding, or the key and the caption are bound to the same column.
  • The caption of the member.

Example

The following example returns the value binding, the member key, and the caption for the first date in the Date dimension in the Adventure Works cube.

WITH MEMBER Measures.ValueColumn as [Date].[Calendar].[July 1, 2001].MemberValue
MEMBER Measures.KeyColumn as [Date].[Calendar].[July 1, 2001].Member_Key
MEMBER Measures.NameColumn as [Date].[Calendar].[July 1, 2001].Member_Name

SELECT {Measures.ValueColumn, Measures.KeyColumn, Measures.NameColumn}  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