Re: Distinct Count
- From: Deepak Puri <deepak_puri@xxxxxxxxxxxxxxx>
- Date: Wed, 27 Apr 2005 13:59:28 -0700
This is a well-known issue with the Distinct Count aggregate in AS 2000.
You can either try AS 2005 (Yukon) or apply alternate techniques, as in
MSDN paper below.
http://groups-beta.google.com/group/microsoft.public.sqlserver.olap/msg/
cab6a5f8a03e8de1?hl=en
>>
Newsgroups: microsoft.public.sqlserver.olap
From: "Mosha Pasumansky [MS]"
Date: Wed, 30 Mar 2005 10:22:55 -0800
Subject: Re: Distinct Count in Visualtotals function
DistinctCount is non-additive, and functions such as Aggregate,
VisualTotals
etc cannot compute it over arbitrary set in AS2K. In Yukon, however,
such
functionality is implemented.
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
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.
==================================================
>>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k
/html/distinct2.asp
>>
Analysis Services: DISTINCT COUNT, Basket Analysis, and Solving the
Multiple Selection of Members Problem
Amir Netz
Microsoft Corporation
Updated May 18, 2004
Applies to:
Microsoft SQL Server 2000
Microsoft SQL Server 2000 Analysis Services
Summary: This article discusses ways to meet information demands and
take full advantage of Analysis Services 2000 by illustrating the use of
calculated members and multidimensional expressions (MDX).
...
>>
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
.
- References:
- Distinct Count
- From: sevenhills
- Distinct Count
- Prev by Date: MDX with OPENQUERY returning bad results
- Next by Date: Any news on Microsoft's front end plans for the future ?
- Previous by thread: Distinct Count
- Next by thread: Memeber Name & Member Key in a single MDX Statement?
- Index(es):
Relevant Pages
|
