Hi,

I'd like to know how to write a query that gives a result like the query
below:

select
crossjoin ( [Product].[Product Family].members, [Product].[Product
Name].members )
on columns
from sales

Can anyone help me?
Thanks


--
Alessandro Turroni
Gruppo Pro spa
Alessandro.Turroni (AT) gruppopro (DOT) it

Since a dim can't be crossjoined with itself, you would have to create a
separate dimension (perhaps virtual) based on one of the two levels.

tom @ the domain below
www.tomchester.net


"Alessandro Turroni" <alessandro.turroni (AT) gruppopro (DOT) it> wrote

Hi Alessandro,

I would like to thank Tom for his help. As I understand, we are not able
to crossjoin levels from the same dimension. If you want members from both
levels to be returned, then just ask for them both without the crossjoin
function.

For additional information regarding this issue, please refer to the
following article:

http://groups.google.com/groups?hl=e...readm=%23qXB88
1oBHA.2180%40tkmsftngp07&rnum=3&prev=/groups%3Fq%3D%2522duplicate%2Bdimensio
ns%2Bacross%2B(independent)%2Baxes%2522%2Band%2Bcr ossjoin%26hl%3Den%26lr%3D%
26ie%3DUTF-8%26oe%3DUTF-8%26selm%3D%2523qXB881oBHA.2180%2540tkmsftngp07%26 rn
um%3D3

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.