newbie query help

#1

select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]} on Rows
from [Consumer]

This query works fine, but I want 2 time periods.
With this query I get

time | subs | unsub
2003 5 1

but I want
2003 | 5 | 1|
2002 | 6 | 2|
2001 | 4 | 3|

I tried CrossJoin({[Time].[2003]},{[Time].[2002]},{[Time].[2001]})
I tried it without the set

I also tried

select {[Subs Count], [Unsub Count]} on Columns from [Consumer] where
[Time].[2003] or [Time].[2002]
but that didn't like it.

#2

or is it possible to do a
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]} on Rows
from [Consumer]
union all
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2002]} on Rows
from [Consumer]

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote

Quote:

select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]} on Rows
from [Consumer]

This query works fine, but I want 2 time periods.
With this query I get

time | subs | unsub
2003 5 1

but I want
2003 | 5 | 1|
2002 | 6 | 2|
2001 | 4 | 3|

I tried CrossJoin({[Time].[2003]},{[Time].[2002]},{[Time].[2001]})
I tried it without the set

I also tried

select {[Subs Count], [Unsub Count]} on Columns from [Consumer] where
[Time].[2003] or [Time].[2002]
but that didn't like it.

#3

No, I don't want all the members, just 2003, 2002, and 2001 for example

"Sanka" <Sanka (AT) discussions (DOT) microsoft.com> wrote

Quote:

try

select {[Subs Count], [Unsub Count]} on Columns, {[Time].[Year].members}
on Rows from [Consumer]

Cheers,
Sanka

"Cindy Lee" wrote:

or is it possible to do a
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]} on
Rows
from [Consumer]
union all
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2002]} on
Rows
from [Consumer]

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote in message
news:uoa9T5PaEHA.1656 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]} on
Rows
from [Consumer]

This query works fine, but I want 2 time periods.
With this query I get

time | subs | unsub
2003 5 1

but I want
2003 | 5 | 1|
2002 | 6 | 2|
2001 | 4 | 3|

I tried CrossJoin({[Time].[2003]},{[Time].[2002]},{[Time].[2001]})
I tried it without the set

I also tried

select {[Subs Count], [Unsub Count]} on Columns from [Consumer]
where
[Time].[2003] or [Time].[2002]
but that didn't like it.

#4

Try this

select {[Subs Count], [Unsub Count]} on Columns,
{[Time].[Year].[2003], [Time].[Year].[2002], [Time].[Year].[2001]}on
Rows
from [Consumer]

--
Michael

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote

Quote:

No, I don't want all the members, just 2003, 2002, and 2001 for example

"Sanka" <Sanka (AT) discussions (DOT) microsoft.com> wrote in message
news:A372E628-F7CE-4E27-9F6F-05A97EDEDC1D (AT) microsoft (DOT) com...

try

select {[Subs Count], [Unsub Count]} on Columns, {[Time].[Year].members}
on Rows from [Consumer]

Cheers,
Sanka

"Cindy Lee" wrote:

or is it possible to do a
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]} on
Rows
from [Consumer]
union all
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2002]} on
Rows
from [Consumer]

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote in message
news:uoa9T5PaEHA.1656 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]} on
Rows
from [Consumer]

This query works fine, but I want 2 time periods.
With this query I get

time | subs | unsub
2003 5 1

but I want
2003 | 5 | 1|
2002 | 6 | 2|
2001 | 4 | 3|

I tried CrossJoin({[Time].[2003]},{[Time].[2002]},{[Time].[2001]})
I tried it without the set

I also tried

select {[Subs Count], [Unsub Count]} on Columns from [Consumer]
where
[Time].[2003] or [Time].[2002]
but that didn't like it.

#5

yeah, thanks that worked.
"Michael Barrett Jensen" <pwuh1ml02@|DeleteThis|sneakemail.com> wrote in
message news:uKjmD3RaEHA.3524 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Quote:

Try this

select {[Subs Count], [Unsub Count]} on Columns,
{[Time].[Year].[2003], [Time].[Year].[2002], [Time].[Year].[2001]}on
Rows
from [Consumer]

--
Michael

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote in message
news:%23b9GKwQaEHA.712 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
No, I don't want all the members, just 2003, 2002, and 2001 for example

"Sanka" <Sanka (AT) discussions (DOT) microsoft.com> wrote in message
news:A372E628-F7CE-4E27-9F6F-05A97EDEDC1D (AT) microsoft (DOT) com...

try

select {[Subs Count], [Unsub Count]} on Columns,
{[Time].[Year].members}
on Rows from [Consumer]

Cheers,
Sanka

"Cindy Lee" wrote:

or is it possible to do a
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]} on
Rows
from [Consumer]
union all
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2002]} on
Rows
from [Consumer]

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote in message
news:uoa9T5PaEHA.1656 (AT) TK2MSFTNGP09 (DOT) phx.gbl...
select {[Subs Count], [Unsub Count]} on Columns, {[Time].[2003]}
on
Rows
from [Consumer]

This query works fine, but I want 2 time periods.
With this query I get

time | subs | unsub
2003 5 1

but I want
2003 | 5 | 1|
2002 | 6 | 2|
2001 | 4 | 3|

I tried CrossJoin({[Time].[2003]},{[Time].[2002]},{[Time].[2001]})
I tried it without the set

I also tried

select {[Subs Count], [Unsub Count]} on Columns from [Consumer]
where
[Time].[2003] or [Time].[2002]
but that didn't like it.

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

newbie query help

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

newbie query help - 07-13-2004 , 12:24 PM

Re: newbie query help - 07-13-2004 , 12:54 PM

Re: newbie query help - 07-13-2004 , 02:02 PM

Re: newbie query help - 07-13-2004 , 04:10 PM

Re: newbie query help - 07-13-2004 , 04:58 PM