Hello,
I've a problem wirting a MDX statement. The statement should sum up the
turnover for a customer only if the order contains at least two items
with different promotion types.
In SQL, this statement is rather easy. Using the Adventure Works DW database the SQL statement would be something like
select f1.customerkey, sum(extendedamount)
from factinternetsales f1
where exists (
select *
from factinternetsales f2
where f1.salesordernumber = f2.salesordernumber
and f1.promotionkey <> f2.promotionkey
)
group by f1.customerkey
But how to tanslate the exists statement in MDX using the Adventure Works cube Please let me know any suggestions.
thanks

Equivalent SQL exitsts translation in MDX
Nicky Chen
see
http://groups.google.com/group/microsoft.public.sqlserver.olap/browse_thread/thread/126a03d6ae280361/0214abce8cfd7d94 lnk=st&q=mdx+equivalent+exists&rnum=2#0214abce8cfd7d94
- christian