The query below returns the July 1, 2002 member from the Fiscal hierarchy in the Date dimension.
|
|
WITH MEMBER [Measures].[UniqName] AS LINKMEMBER([Date].[July 1, 2002], [Date].[Fiscal]).UniqueName
SELECT {[Measures].[UniqName]} ON COLUMNS
FROM [Adventure Works]
|
|
|
|
|
|
|
The query below returns the July 1, 2002 member from the Calendar hierarchy in the Date dimension.
|
|
WITH MEMBER [Measures].[UniqName] AS LINKMEMBER([Date].[July 1, 2002], [Date].[Calendar]).UniqueName
SELECT {[Measures].[UniqName]} ON COLUMNS
FROM [Adventure Works]
|
|
|
|
|
|
|