Hi,

Why does the following MDX take such a long time to return results in Mdx
Sample Application:

SELECT {[Measures].[Unit Sales]} ON 0, CrossJoin({[Gender].DefaultMember},
{[Customers].[Name].Members}) on 1 FROM sales

while the following MDX takes nearly no time at all:

SELECT {[Measures].[Unit Sales]} ON 0, {[Customers].[Name].Members}on 1 FROM
sales


Conceptually, they are pretty much the same...

Thanks in advance,

I would guess because the first query is hitting an aggregation, and the
second isn't.

Regards,

Chris
--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"E" wrote: