Reduced unique names

Reduced unique names provides the shortest unique XMLA name. This feature is activated by selecting the Reduced option under Database Settings in d/EPM Administration.

The reduced unique name starts with the dimension name in square brackets. For example, [Region]. It must end with the element name in square brackets. For example, [USA]. If the element is not unique within the dimension in between the dimension and the element name, the names of the element's ancestors will be added in square brackets until the name is unique.

This table describes the unique names:

Name Description Example
Native Name, XMLA Name, Name Name of the OLAP element Germany
XMLA Unique Name, Unique Name [Hierarchy].[Parent's Name]… [Parent's Name].[Name] [Countries].[Europe].[Germany]
Short Name [Hierarchy].[Name] [Countries].[Germany]
Short Unique Name [Hierarchy].[Name].[N] where N is a number [Countries].[Germany].[2]
Reduced Unique Name [Hierarchy].[KeyParents]...[Name]([Hierarchy].[Name].[KeyParents]…) [Countries].[Germany] or [Countries].[Europe].[Germany]
Reduced Short Unique Name [Hierarchy].[Name] or [Hierarchy].[Name].[N] depending on the number of the parents [Countries].[Germany] or [Countries].[Germany].[2]
Caption Multilingual name Germany or Deutschland

Example

Here are some examples of reduced unique names:

[Region].[USA]
[Region].[European Union].[Germany][Region].[Middle Region].[Germany]
[Months].[January]