Define a Hierarchical Data Source

This applies to: Visual Data Discovery

Hierarchical fields are enabled by default at the server level. Work with Technical Support to disable.

Create or edit a data source to include a facts table and at least one lookup table to create your hierarchical data source.

To define a new hierarchical data source:

  1. Log in as a user with the Administer Sources or Create New Data Sources privilege.

  2. Select the Sources option from the main menu. The Sources page appears.

  3. On the Sources page, select the Add Source button. The Source Creation work area opens.

  4. Name your data source, then add the first data entity, including appropriate connection, schema, and entity options or Custom SQL.

    create your hierarchical data source using this work area

    The first data entity can be, but does not have to be, the facts table.

  5. Add the second data entity, your hierarchy lookup table, including appropriate connection, schema, and entity options or Custom SQL.

  6. Select Add in the Join Definition work area to connect the hierarchy lookup table to the facts table.

  7. If only one hierarchy is used, we recommend you use a left join from a hierarchy lookup table to a facts table. To configure multiple hierarchical tables on a single source, contact Technical Support.

    define your hierarchical joins

    • Select a left join to preserve the contents and structure of the hierarchical tree, regardless of the contents of the facts table.

    • If you select an inner join, the hierarchy is limited to data in the facts table. This may break your hierarchy structure, separating nested items from parents, making the nest items top-level items.

  8. Select Apply to create the join, then Save Source to save your source.

Next, define a hierarchy field for your data source.