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

Properties (MDX)

Updated: 12 December 2006

Returns a string, or a strongly-typed value, that contains a member property value.


Member_Expression.Properties(Property_Name [, TYPED])

Member_Expression

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

Property_Name

A valid string expression of a member property name.

The Properties function returns the value of the specified member for the specified member property. The member property can be any of the intrinsic member properties, such as NAME, ID, KEY, MEMBER_VALUE, or CAPTION, or it can be a user-defined member property. For more information, see Intrinsic Member Properties (MDX) and User-Defined Member Properties (MDX).

By default, the value is coerced to be a string. If TYPED is specified, the return value is strongly typed.

  • If the property type is intrinsic, the function returns the original type of the member.
  • If the property type is user defined, the type of the return value is the same as the type of the return value of the MemberValue function.
ms144821.note(en-US,SQL.90).gifNote:
Properties ('Key') returns the same result as Key0, except for composite keys. Properties ('Key') will return null for composite keys. Use the Keyx syntax for composite keys, as illustrated in the example. Properties ('Key0'), Properties('Key1'), Properties('Key2'), and so on, collectively form the composite key.

Examples

The following example returns both intrinsic and user-defined member properties, utilizing the TYPED argument to return the strongly typed value for the Day Name member property.

WITH MEMBER Measures.MemberName AS 
   [Date].[Calendar].[July 1, 2003].Properties('Name')
MEMBER Measures.MemberVal AS 
   [Date].[Calendar].[July 1, 2003].Properties('Member_Value')
MEMBER Measures.MemberKey AS 
   [Date].[Calendar].[July 1, 2003].Properties('Key')
MEMBER Measures.MemberID AS 
   [Date].[Calendar].[July 1, 2003].Properties('ID')
MEMBER Measures.MemberCaption AS 
   [Date].[Calendar].[July 1, 2003].Properties('Caption')
MEMBER Measures.DayName AS 
   [Date].[Calendar].[July 1, 2003].Properties('Day Name', TYPED)
MEMBER Measures.DayNameTyped AS 
   [Date].[Calendar].[July 1, 2003].Properties('Day Name')
MEMBER Measures.DayofWeek AS 
   [Date].[Calendar].[July 1, 2003].Properties('Day of Week')
MEMBER Measures.DayofMonth AS 
   [Date].[Calendar].[July 1, 2003].Properties('Day of Month')
MEMBER Measures.DayofYear AS 
   [Date].[Calendar].[July 1, 2003].Properties('Day of Year')

SELECT {Measures.MemberName
   , Measures.MemberVal
   , Measures.MemberKey
   , Measures.MemberID
   , Measures.MemberCaption
   , Measures.DayName
   , Measures.DayNameTyped
   , Measures.DayofWeek
   , Measures.DayofMonth
   , Measures.DayofYear
   }  ON 0
FROM [Adventure Works]

The following example shows the use of the KEYx property.

WITH 
MEMBER Measures.MemberKey AS 
   [Customer].[Customer Geography].[State-Province].&[QLD]&[AU].Properties('Key')
MEMBER Measures.MemberKey0 AS 
   [Customer].[Customer Geography].[State-Province].&[QLD]&[AU].Properties('Key0')
MEMBER Measures.MemberKey1 AS 
   [Customer].[Customer Geography].[State-Province].&[QLD]&[AU].Properties('Key1')
 
SELECT {Measures.MemberKey
   , Measures.MemberKey0
   , Measures.MemberKey1   
   }  ON 0
FROM [Adventure Works]

Release History

12 December 2006

Changed content:
  • Updated content related to composite keys and the KEYx property.
  • Added updated example.

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