On 10 Sep, 23:53, "Al" <n...@no.com> wrote:
> Is there a way with MDX to discover the hierarchy of a dimension. In other
> words a calendar dimension would have year - quarter - month - week. I want
> to create a MDX query that would return [Calendar].[month] instead of
> "January 2007" for a month or [Calendar].[Quarter] instead of "First
> Quarter2007" for a quarter. Is this possible?
>
> Thanks,
>
> Al

Hi Al,

Yes, try:

WITH MEMBER [Test] AS [Dimension].[Hierarchy].UNIQUENAME

SELECT
{
[Test]
} ON 0
FROM [Cube]

Good luck!
J