Adding a hierarchy to a dimension

Select Dashboards > Data Integrations > OLAP Modeling.

Select the model and dimension.

Click the Hierarchies tab.

Click Add.

Specify this information:

Name: Specify the name of the hierarchy. After you add the hierarchy to a dimension, you cannot edit the hierarchy name.
Default Caption: Specify the caption for the hierarchy.
Default Description: Optionally, specify the description for the hierarchy.

Optionally, select the Use as default hierarchy check box to make the hierarchy the default hierarchy.

Click Next.

In the Elements Table section, select one of these options:

Option	Description
Select Elements Table	Select the elements table name from the list.
Create Elements table	An elements table is created by the system.

If you select an elements table, ensure that it has these columns:

ID: Required.
ElementType: Optional, but recommended to support the full functionality.
OrderPosition: Optional, but recommended to support the full functionality.
DataSourceID: Optional, but recommended to support the full functionality.
ParentID: Optional, but recommended to support the full functionality. Used only if you do not use a separate table for relations.
Weight: Optional, but recommended to support the full functionality. Used only if you do not use a separate table for relations.

In the Relations Table section, select one of these options:

Option	Description
No Relations Table	No relations table is used.
Select Relations Table	Select the relations table name from the list.
Create Relations Table	A relations table is created by the system.

If you select a relations table, ensure that it has these columns:

Click Finish.