MEMBERVALUE
1. MEMBERVALUE (Syntax: Member_Expression.MemberValue )
Description:
This function is used to return the value of a member.
Syntax:
Member_Expression.MemberValue
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
WITH MEMBER
Measures.ValueColumn as [Customer].[Geography].[Country].&[Australia].MemberValue
SELECT {Measures.ValueColumn} ON 0
from [AdventureWorksMF] 2. MEMBERVALUE (Syntax: Member_Expression.properties(membervalue))
Description:
This function returns the display value or the name of the given member.
Syntax:
Member_Expression.properties(membervalue)
Return Type:
SCALAR
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
WITH MEMBER [Measures].[Result] AS MEMBER_VALUE([Dimensions].[Hierarchy].CURRENTMEMBER.properties(membervalue)) SELECT [Measures].[Result] ON 0 FROM [CubeName]