Managing the properties of a hierarchy

Caution:

Changing the source tables (elements table and relations table) can affect the subset or attribute definitions, or both. Some manual adjustments can be required. Changing the source table can cause a data loss or lead to unexpected results after publishing. Those issues can occur if the source table lacks the elements that were previously used or if the relations table contains elements that are not present in the elements table. Before you publish any changes, ensure that you have a backup copy of your data. If you are not sure about the consequences of changing the source table, consult your administrator or contact the support team. If you disable the relations table, you can lose your data. This can happen if the relations table contains elements that are not present in the elements table.

Note: If a dimension has multiple hierarchies and multiple elements tables have a source column for the values of an attribute field, then the values are not automatically synched between those tables for base elements. Editing an attribute value in the elements editor of a hierarchy writes back only to the elements table on which the hierarchy is based. When you publish to OLAP, the attribute values from the elements table of the default hierarchy overwrite the values of the same element from other hierarchies.

Select Dashboards > Data Integrations > OLAP Modeling.
Select the model and hierarchy.
On the Properties tab, edit any of these properties:
- Default caption or language-specific captions. To edit language-specific captions, click the icon above the Default Caption field.
- Default description or language-specific descriptions. To edit language-specific descriptions, click the icon above the Default Description field.
- Default element
  Select the element that can be accessed by all users.
- Elements table
  Select the elements table from the list.
- Enable or disable the use of an existing relations table. To enable it, select the Relations Table check box and select the table from the list. To disable the use of a relations table, clear the Relations Table check box.
- Define meaningful names for the levels of the hierarchy. Click Configure Levels and specify default captions or language-specific captions, or both for each hierarchy level. This can help users when they explore data or design reports.
Click Save.