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