MDX Syntax for Specifying Duplicate Member Names and Aliases

The following member specification rules apply to databases with duplicate member names enabled.

Note:

These rules are also applicable if you need to use MDX to explicitly reference shared member names in a unique member name outline (an outline with duplicate member names NOT enabled). See the “Shared Member Names Example” in this topic.

Qualified names must be used to specify duplicate member names. Qualified member or alias names can be specified using:

Duplicate Member Names Query Example

The following query uses both methods of referencing shortcut member names in MDX:

SELECT
 { Sales, Profit } 
ON COLUMNS,
 {[[Store]]@[6]]], StrToMbr("Product.SKU.1")}
ON ROWS
FROM MySample.Basic
WHERE ([[1998]].[Q1]].[1]]])

Note:

StrToMbr accepts any type of member-identifier strings: names, aliases or qualified names.

Shared Member Names Example

The following example applies to a unique member name outline that contains shared members.

In the Sample Basic database, the member [100-20] is an original member under parent [100], and has a shared member associated with it under parent [Diet]. The shared member [100-20] can be referred to explicitly, using the unique name [Diet].[100-20], as shown in the following query:

SELECT
 {Sales} 
ON COLUMNS,
 {[[Diet]].[100-20]]]} PROPERTIES MEMBER_UNIQUE_NAME
ON ROWS
FROM Sample.Basic;