Hi,

trying to do some distinct count analysis in MDX, which
involves doing a count(crossjoin()), as described in
article

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnsql2k/html/distinct2.asp

and it is taking a long time. The article implies that
you can force a query onto the server:

"It is strongly recommended that all queries involving
DISTINCT COUNT measures be snapshot queries so they can
be relayed to the server."

How do you do this with a MOLAP cube? I can't see
anything about snapshots in the help files.

That quote is making reference to the query that is sent to your data warehouse during processing.
It is not anything to do with speeding up your MDX queries.

Sorry.

Regards
Jamie

"Tim Reeves" wrote: