| The query below shows the difference between the name and the UniqueName for a member. |
| |
WITH
MEMBER [MemName] AS
[Date].Fiscal.[December 2002].Name
MEMBER [MemUniqueName] AS
[Date].Fiscal.[December 2002].UniqueName
SELECT
{[MemName], [MemUniqueName]} ON COLUMNS
FROM
[Adventure Works] |
| |
| |
| |
|
| |
|
| The following query returns the name for a dimension, hierarchy, level, and member. |
| |
WITH
MEMBER [DimName] AS
[Date].Name
MEMBER [HierName] AS
[Date].Fiscal.Name
MEMBER [LevName] AS
[Date].Fiscal.Month.Name
MEMBER [MemName] AS
[Date].Fiscal.[December 2002].Name
SELECT
{[DimName], [HierName], [LevName], [MemName]} ON COLUMNS
FROM
[Adventure Works] |
| |
| |
| |
|
| |
|