MEMBER_CAPTION
A label or caption associated with the member. The caption is primarily for display purposes. If a caption does not exist, the query returns MEMBER_NAME.
Syntax
Member_Expression.MEMBER_CAPTION
Input Parameters
N/A
Return Value
Returns the value of the member caption as a String.
Example
If the product caption does not contain "Mountain" return 0 else 1.
IIF(InStr([Product Dimension].[Product Dimension].CurrentMember.MEMBER_CAPTION, "Mountain") = 0, 0, 1)