Name attribute

String custom hierarchies and the OLAP Metadata Hierarchy have an attribute called Name. The Name attribute is specified and stored in the Name column of the Table of Names and Texts in the Hierarchy Designer.

See Creating custom hierarchies.

How you access the Name attribute depends on whether the custom hierarchy is in a hyperblock, or in another type of list object.
Name attribute in hyperblocks
There are two ways to access the Name attribute of a custom hierarchy in a hyperblock:
  • Select Attribute 1 (Name) as the value of the key output cell in the Object Properties dialog. In View mode, the name attributes of the elements are displayed.

    See Formatting list objects.

  • Specify an ROA, GETNAME, or GETOLAPNAME formula in the value cell of the hyperblock. In View mode, the elements of the custom hierarchy and their name attributes are displayed.
You can also reference the Name attribute from outside the hyperblock with:
=reportobjects.hyperblock_name.attribute1
This returns the Name attribute of the first element of the custom hierarchy.
Name attribute in list views
If a custom hierarchy is in a combo box, list box, or group of option buttons you can access the Name attribute by selecting Attribute in the Text format of the list field in the Object Properties dialog.
You can also use this syntax to reference the Name attribute from outside the list view: =reportobjects.listview_name.attribute
This returns the Name attribute of the first element of the custom hierarchy.
Related topics