I am trying to write a query in MDXwhere i have to combine results of 2 MDX query into one
query goes like this


With Measure Measures.A as '.....'
select Measure.A on columns,
dimension.DIM_1 on rows
from MYCUBE

With Measure Measures.A as '.....'
select Measure.A on columns,
dimension.DIM_2 on rows
from MYCUBE

is there any way to combine the result of these 2 queries in to one

i tried using UNION but in tht it requires same dimesnion in both the queries (if m not wrong)

plz help me out in this

Mohammed Imtiaz