I was wondering if there was a way to make a union of queries?


select {[RunningTotalSubs], [test1]} on Columns, CrossJoin([Age Group].[All
Age Group].children, TopCount( { [DMA].children}, 5, ([RunningTotalSubs])))
on Rows from [consumer_analysis] where [Zone Id].&[14]

result:
AGE RunningTotalSubs
20-30 1000
30-40 2000
40-50 1000

select {[RunningTotalSubs], [test1]} on Columns, CrossJoin([Gender].[All
Gender].children, TopCount( { [DMA].children}, 5, ([RunningTotalSubs]))) on
Rows from [consumer_analysis] where [Zone Id].&[14]

result:
GENDER RunningTotalSubs
M 1000
F 2000
U 1000


Is there a way to combine the queries so I can get a result set like:

AGE-GENDER Total
20-30 1000
30-40 2000
40-50 1000
M 1000
F 2000
U 1000

oops, ignor the test1
query should be like this:

select {[RunningTotalSubs]} on Columns, CrossJoin({[Age Group].[All
Age Group].children}, TopCount( { [DMA].children}, 5,
([RunningTotalSubs])))
on Rows from [consumer_analysis] where [Zone Id].&[14]


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