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: Value
Category: Value
Description: The Value function returns the value of the current member of the measures dimension for the supplied member in the context of the query.
Syntax: «Tuple».VALUE
Technet Link: MDX Value Function




The query below uses the Value function to return the default measure for the Specialty Bike Shop member of the Business Type level in the Reseller Type hierarchy in the Reseller dimension.
 
WITH
      MEMBER [Reseller].[Reseller Type].[MyVal] AS
      [Reseller].[Reseller Type].[Business Type].[Specialty Bike Shop].Value
SELECT
      {[Reseller].[Reseller Type].[MyVal]} ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
The default property that is returned for members is the value property. So you could re-write the above query in the following way and with the result of being the same as above.
 

SELECT
      {[Reseller].[Reseller Type].[Business Type].[Specialty Bike Shop]} ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
 

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