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: Properties
Category: Navigation
Description: The Properties function returns either a string or a stongly-typed value for a member property.
Syntax: «Member».PROPERTIES( «String Expression»[, TYPED] )
Technet Link: MDX Properties Function




The query below returns several member properties for the Customer Cedric Wang.
 
WITH
      MEMBER Measures.MemName AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Name')
      MEMBER Measures.MemUniqName AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Unique_Name')
      MEMBER Measures.MemVal AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Member_Value')
      MEMBER Measures.MemKey AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Key')
      MEMBER Measures.MemID AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('ID')
      MEMBER Measures.MemCaption AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Caption')
      MEMBER Measures.MemAddress AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Address')
      MEMBER Measures.MemPostCode AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Postal Code')
      MEMBER Measures.MemPhone AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Phone')
      MEMBER Measures.MemFirstPurch AS
      [Customer].[Customer Geography].[Customer].[Cedric Wang].Properties('Date of First Purchase')
SELECT
      {Measures.MemName, Measures.MemUniqName, Measures.MemVal, Measures.MemKey, Measures.MemID, Measures.MemCaption, Measures.MemAddress, Measures.MemPostCode, Measures.MemPhone, Measures.MemFirstPurch } ON COLUMNS
     
FROM
      [Adventure Works]
 
 

 
The query below returns the Internet Order Count for all Customers that have a Postal Code property of 91940.
 

SELECT
      {[Measures].[Internet Order Count]} ON COLUMNS,
      FILTER([Customer].[Customer Geography].[Customer].Members, [Customer].[Customer Geography].CurrentMember.Properties('Postal Code') = '91940') ON ROWS
FROM
      [Adventure Works]
 
 

 
 

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