Create an External Hierarchy for Drill-Down

Select a Semantic Usage of Hierarchy to indicate that your entity contains parent-child relationships for members in a dimension.

Procedure

  1. Open the table or view containing the hierarchy information and set the following properties:

    Property

    Description

    Business Name

    Enter a descriptive name to help users identify the object. This name can be changed at any time.

    Technical Name

    Displays the name used in scripts and code, synchronized by default with the Business Name.

    Semantic Usage

    Choose Hierarchy.

    Parent Column / Child Column

    Select the parent and child columns that represent the hierarchy. The child column must be a key column and the parent and child columns must have the same data type.

    If your dimension has more than one key column, then you should click (Add) to add an additional line for each key column.
  2. Specify your attributes (see Specify Attributes as Keys, Units, and Other Characteristics).
  3. Set attributes as keys to indicate that the data they contain can uniquely identify records.

    To set an attribute as a key column, select the checkbox in the Key column or hover over the attribute in the side panel and click (Menu)Start of the navigation path Next navigation step Set as KeyEnd of the navigation path.

  4. Click (Save)Start of the navigation path Next navigation step SaveEnd of the navigation path to save your entity or click (Deploy) to save and deploy it immediately.
    For more information, see Saving and Deploying Objects.