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)