How to get Year & Quarter title in MDX?

#1

What is the right way in MDX to get a double title of the Years and the
Quarters?
When I'm trying the following syntax I receive an error message:
CROSSJOIN([Time].[Year].Members,[Time].[Quarter].Members) ON COLUMNS

#2

Use the Generate Function combined with the Descendants function.

{ Generate( { [Time].[Year].Members}, Descendants( [Time].CurrentMember,
[Time].Quarter, SELF_AND_BEFORE)) } ON COLUMNS

"Geri Reshef" <GeriReshef (AT) Tapuz (DOT) co.il> wrote

Quote:

What is the right way in MDX to get a double title of the Years and the
Quarters?
When I'm trying the following syntax I receive an error message:
CROSSJOIN([Time].[Year].Members,[Time].[Quarter].Members) ON COLUMNS

#3

I get one line header: 1997,Q1,Q2,Q3,Q4,1998,Q1,Q2,Q3,Q4
While I need a two line Header:

Quote:

1997 | 1998 |
Q1|Q2|Q3|Q4|Q1|Q2|Q3|Q4|
Thnak you anyway!

"Martin Mason" <martin.mason (AT) earthlink (DOT) net> wrote

Quote:

Use the Generate Function combined with the Descendants function.

{ Generate( { [Time].[Year].Members}, Descendants( [Time].CurrentMember,
[Time].Quarter, SELF_AND_BEFORE)) } ON COLUMNS

"Geri Reshef" <GeriReshef (AT) Tapuz (DOT) co.il> wrote in message
news:eb4VvV4SEHA.3608 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
What is the right way in MDX to get a double title of the Years and the
Quarters?
When I'm trying the following syntax I receive an error message:
CROSSJOIN([Time].[Year].Members,[Time].[Quarter].Members) ON COLUMNS

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

How to get Year & Quarter title in MDX?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

How to get Year & Quarter title in MDX? - 06-06-2004 , 01:15 AM

Re: How to get Year & Quarter title in MDX? - 06-07-2004 , 09:22 PM

Ufortunately I still get one line header.. - 06-08-2004 , 02:07 AM