Skip to main content

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:

  1. In Design Center, open a model and switch to the Canvas tab.

  2. Find the dimension you want to edit, click its context menu, and select Edit. The Edit Dimension panel opens.

  3. In the Hierarchies section, find the hierarchy you want to edit, click its context menu, and select Edit. The Edit Hierarchy panel opens.

  4. Edit the hierarchy properties as needed.

    FieldDescription
    Display nameThe display name to use for the hierarchy within AtScale.
    Unique nameThe unique name for the hierarchy. This value must be unique within the dimension.
    DescriptionA description for the hierarchy.
    Exclude values with no fact dataConfigures 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 expressionWhen 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.
    FolderDefines the folder in which this hierarchy appears in BI tools.
  5. Click Apply.