Unique names and captions
Every list element has a unique name, for example,
[Region].[All Regions].[North America]
, and a caption,
for example
North America
. In most cases, users want to see the
captions. But Olap functions and lists operate with unique names. So, there is
often a need to translate unique names to captions.
Hyperblocks, list view objects and the MEMBERGET function each have a dual output: they can output the unique names or the captions of list elements. How you specify which is displayed depends on whether the list is displayed in a hyperblock, list view object, or is returned by the MEMBERGET function.
In hyperblocks and in the output of the MEMBERGET function, the @ and ~ number formats in the Format Cells dialog control the output format.
See Unique names and captions in hyperblocks.
In list view objects, the .Text and .Alias properties specify the output format.