INTERSECT function have different dimensionality??

hi there,

i trying implement union/intersect in mdx, 1 have tried:

select [measures].[canon number of openings] on columns
(
select intersect({[job location].[hierarchy-county].[state].&[al]&[6].children},
       {[job location].[hierarchy-county].[county].&[houston, al]&[al]&[6]}) on columns
[licube_demo])
[calendar].[month].&[2011]&[7]

this works fine same if try facing issue,

select [measures].[canon number of openings] on columns from
(select
intersect({[msa].[msa name].&[metropolitan division]},
{[job location].[hierarchy-county].[state].&[oh]&[6]})
 on columns [licube_demo])

error getting :

query (3, 1) 2 sets specified in intersect function have different dimensionality.
 is there other way can done?can please me out?

thanks,

aish

i think add each member both sets:

intersect({[msa].[msa name].&[metropolitan division], [job location].[hierarchy-county].[state].currentmember},

                 {[msa].[msa name].currentmember, [job location].[hierarchy-county].[state].&[oh]&[6]})

hope helps!

 

cheers!

---

ryan - please mark answers , useful posts!

SQL Server  >  SQL Server Analysis Services