How to get unique name of a hierarchy member


1. Overview

This article demonstrates how to get the unique name of a hierarchy member. This is useful in cases such as setting row-level security using a security hierarchy or passing parameter values via query string.

You can display the unique name of the hierarchy member from different screens within Dundas BI. Wherever available, hover over the hierarchy member to display a tooltip with the hierarchy member's unique name. However, it is important to distinguish between two stages of the hierarchy that have different unique names:

  • When creating a hierarchy from the main menu or through a time dimension, the members have a shorter unique name we can call the 'design' unique name, because it is not yet used in a data cube or metric set. For example, the fourth item of the first level of the Product hierarchy may get the unique name 4.A.

  • When using one of these hierarchies in a data cube or metric set, the unique names may change and incorporate the name of the element that's using the hierarchy. For example, after promoting the ProductID column, the member above may get the unique name 4.A.ProductID.

In most cases, you will be working with the second case.

1.1. Customize the hierarchy unique name

When you are using a data cube to replace or promote a column to a hierarchy, you can customize the unique name for that hierarchy. This will be used together with the shorter unique name to generate the unique names for the members of the hierarchy.

Set the hierarchy unique name in the data cube
Set the hierarchy unique name in the data cube

2. Show the member unique name

When a filter is connected to the hierarchy and lists its members, you can access the unique names in a tooltip by hovering over them.

3. Show the design unique name

4. See also


Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri