Description attribute of OLAP Metadata Hierarchy

The database aliases, cubes, dimensions and elements referenced by the OLAP Metadata hierarchy can have a descriptive text, stored in the Description attribute.

How you access the Description attribute depends on whether the OLAP Metadata hierarchy is in a hyperblock, or in another type of list object.
Description attribute in hyperblocks
There are two ways to access the Description attribute of the OLAP Metadata hierarchy in a hyperblock:
  • Select Attribute 2 (Description) as the value of the key output cell in the Formatting list objectsdialog. In View mode, the descriptions of the elements are displayed.
  • Specify an ROA formula in the value cell of the hyperblock. In View mode, the elements of the custom hierarchy and their descriptions are displayed.
You can also reference the Description attribute from outside the hyperblock with:
=reportobjects.hyperblock_name.attribute2
This returns the Description attribute of the first element of the custom hierarchy.
Description attribute in listviews
If the OLAP Metadata hierarchy is in a combo box, list box, or group of option buttons you can reference the Description attribute from outside the list view with:
=reportobjects.listview_name.attribute2
This returns the Description attribute of the first element of the custom hierarchy.
Related topics