caption

Returns the caption values of "level", "member", or "set_expression". The caption is the string display name for an element and does not necessarily match the unique identifier used to generate the business key or member unique name (MUN) for the element. The caption is not necessarily unique; for example, the caption for a month may return the month name without further year details to make the value unique.

Syntax

caption ( level|member|set_expression )

Example 1

caption ( [TrailChef Water Bag] )

Result

TrailChef Water Bag

Example 2

caption ( [great_outdoors_company].[Products].[Products].[Product 
line] )

Result

Returns the caption values of the Product line set.

Result data

Camping Equipment
Mountaineering Equipment
Personal Accessories
Outdoor Protection
Golf Equipment