Hello everybody,

Does the Except function works with sets resulting from a crossjoin ?
Let me explain myself...

I have two sets. Each one have been constructed with a crossjoin function

Set 1 = {(1635,119),(1635,107),(1635,123),(1635,150)}
Set 2 = {(1635,123),(1635,150)}

I would like to obtain this result :
Set Result = {(1635,119),(1635,107)}

I thought I could use the Except function but it doesn't seem to work.
Does anybody have an idea to help me ?

Thanks

Can you say what dimension members/tuples are involved in cross-joins -
numbers don't provide the whole picture?


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Yes, it is supposed to work. I just tried the following query with Foodmart,
and it worked fine:

select Except({(usa, [Unit Sales]), (wa, [Unit Sales]), (usa, [Store
Sales])}, {(usa, [Unit Sales]), (usa, [Store Sales])}) on 0 from sales

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Lauraine" <lrittano (AT) free (DOT) fr> wrote