like calculating a "Running Total"? In another word, can
we do DistinctCount(PeriodsToDate(....)) in the same way
as SUM(PeriodsToDate(...))?

Thanks


-ken

In SQL Server 2000 AS, measures with Distinct Count aggregation can't be
rolled up dynamically, but this will be possible with SQL Server 2005:

http://www.microsoft.com/technet/pro...aluate/dwsqlsy.
mspx
Distinct count measures are also much improved in “Yukon”. A distinct
count measure can now be defined on string data, and queries can be
defined that will perform a Distinct Count over an arbitrary set.
Analysis Services 2000 performed distinct counts only on the predefined
hierarchical structure.
...

- Deepak

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

Yes this is something that will be with Yukon.

But why is it, that everyone are trying to have distinct count.
This is not something that is meant to have in OLAP!
This is something you have in data mining.

And even when you can make a distinct count measure in OLAP it's a very slow
operation in has so many other restrictions.
With datamining this is something natural and takes a second to do it.

Just my opinion.

Peace,
Andrej


"MDX question" <kenxchen (AT) hotmail (DOT) com> wrote

It can be done in AS 2000, but it will be calculated at query time, and as
such, will not perform quickly on large sets of data. See
http://groups.msn.com/OLAPServicesDevelopersForum for a whitepaper on the
topic.


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Andrej Hudoklin" <andrej.hudoklin (AT) add (DOT) si> wrote