PROPERTIES
Description:
This function is used to return a string, or a strongly-typed value, that contains a member property value.
Syntax:
Member_Expression.Properties(Property_Name [, TYPED])
Return type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Property_Name | It is a valid string expression of a member property name. |
Example:
WITH MEMBER [Measures].MemberRank AS
[Customer].[Geography].[Country].&[Australia].PROPERTIES("MEMBER_RANK")
SELECT {[Measures].MemberRank} ON 0
FROM [AdventureWorksMF]