Edit a Hierarchy

Once a dimension is created, you can edit its hierarchies to change their names and other properties.

Procedure

To edit a hierarchy:

In Design Center, open a model and switch to the Canvas tab.
Find the dimension you want to edit, click its context menu, and select Edit. The Edit Dimension panel opens.
In the Hierarchies section, find the hierarchy you want to edit, click its context menu, and select Edit. The Edit Hierarchy panel opens.

Edit the hierarchy properties as needed.

Field Description
Display name The display name to use for the hierarchy within AtScale.
Unique name The unique name for the hierarchy. This value must be unique within the dimension.
Description A description for the hierarchy.
Exclude values with no fact data Configures the join behavior for the hierarchy, which determines how empty values are handled in client BI tools.

When enabled, query results in BI tools only include members that join to the fact dataset (inner join behavior). Members with no matching entries in the fact dataset are still included if the client BI tool requests them.

When disabled, query results include all members of the dimension, even those that have no matching entries in the fact dataset (outer join behavior). This occurs unless the client BI tool specifically requests to have these values filtered out.
Use default member literal expression When enabled, defines a member of the hierarchy to use as the default filter for MDX queries on the hierarchy. Enter an MDX expression in the text box. For more information, see About Default Hierarchical Members.
Folder Defines the folder in which this hierarchy appears in BI tools.

Click Apply.

Field	Description
Display name	The display name to use for the hierarchy within AtScale.
Unique name	The unique name for the hierarchy. This value must be unique within the dimension.
Description	A description for the hierarchy.
Exclude values with no fact data	Configures the join behavior for the hierarchy, which determines how empty values are handled in client BI tools. When enabled, query results in BI tools only include members that join to the fact dataset (inner join behavior). Members with no matching entries in the fact dataset are still included if the client BI tool requests them. When disabled, query results include all members of the dimension, even those that have no matching entries in the fact dataset (outer join behavior). This occurs unless the client BI tool specifically requests to have these values filtered out.
Use default member literal expression	When enabled, defines a member of the hierarchy to use as the default filter for MDX queries on the hierarchy. Enter an MDX expression in the text box. For more information, see About Default Hierarchical Members.
Folder	Defines the folder in which this hierarchy appears in BI tools.