Export (0) Print
Expand All
Expand Minimize

UniqueName (MDX)

Returns the unique name of a specified dimension, hierarchy, level, or member.

Dimension expression syntaxDimension_Expression.UniqueName

Hierarchy expression syntaxHierarchy_Expression.UniqueName

Level expression syntaxLevel_Expression.UniqueName

Member expression syntaxMember_Expression.UniqueName

Dimension_Expression

A valid Multidimensional Expressions (MDX) expression that resolves to a dimension.

Hierarchy_Expression

A valid Multidimensional Expressions (MDX) expression that returns a hierarchy.

Level_Expression

A valid Multidimensional Expressions (MDX) expression that returns a level.

Member_Expression

A valid Multidimensional Expressions (MDX) expression that returns a member.

The UniqueName function returns the unique name of the object, not the name returned by the Name function. The returned name does not include the name of the cube. The results returned depend upon the server-side settings or the MDX Unique Name Style connection string property.

Example

The following example returns the unique name value for the Product dimension, the Product Categories hierarchy, the Subcategory level, and the Bike Racks member in the Adventure Works cube.

WITH MEMBER DimensionUniqueName 
   AS [Product].UniqueName
MEMBER HierarchyUniqueName 
   AS [Product].[Product Categories].UniqueName
MEMBER LevelUniqueName 
   AS [Product].[Product Categories].[Subcategory].UniqueName
MEMBER MemberUniqueName 
   AS [Product].[Product Categories].[Subcategory].[Bike Racks]
SELECT 
   {DimensionUniqueName
   , HierarchyUniqueName
   , LevelUniqueName
   , MemberUniqueName }
   ON 0
FROM [Adventure Works]

Community Additions

ADD
Show:
© 2014 Microsoft