SEO

#1 (**permalink**) 02-27-2008, 07:09 PM

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

#2 (**permalink**) 02-27-2008, 07:09 PM

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

#3 (**permalink**) 02-27-2008, 07:09 PM

try:
[Calendar].[January 2007].level.uniquename

works only if the dimension has some options setup correctly; member name
must be unique

filter([Calendar].allmembers, instr(Calendar.currentmember.caption, "January
2007")>=0).item(0)

"Al" <no@no.com> wrote in message
news:OD3T01$8HHA.1484@TK2MSFTNGP06.phx.gbl...
> 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
>
>

#4 (**permalink**) 02-27-2008, 07:09 PM

Thanks for the answers. I will have to give them a try.

"Al" <no@no.com> wrote in message
news:OD3T01$8HHA.1484@TK2MSFTNGP06.phx.gbl...
> 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
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Discover hierarchy