Home      Functions     Common Solutions      Contact     

MDX Functions:
MDX Functions

Common Solutions

Common Solutions
Resource Links

MDX Books
MDX Related Software
MDX Related Blogs
Other Links

Contact Us
Microsoft SQL Server Analysis Services Function Page
Function Name: MemberValue
Category: Value
Description: The Member Value function returns the values for the supplied member.
Syntax: Ā«MemberĀ».MEMBERVALUE
Technet Link: MDX MemberValue Function

The query below returns the member value for the supplied member.
      MEMBER [Measures].[DateVal] AS
      [Date].[Calendar].[September 15, 2003].MemberValue
      {[Measures].[DateVal]} ON COLUMNS
      [Adventure Works]

The query below returns the member values for the Subcategory members for the Product Categories hierarchy in the Products dimension.
      MEMBER [Measures].[MemVal] AS
      [Product].[Product Categories].CurrentMember.MemberValue
      {[Measures].[MemVal]} ON COLUMNS,
      {[Product].[Product Categories].[Subcategory].Members} ON ROWS
      [Adventure Works]


Copyright 2008 by MDXpert.com.
Terms of Use                              Privacy Statement
Site Powered By - WinHost.Com