Hello,

I have one problem in writing an MDX Query. When I use the Aggregate
function with a DISTINCT COUNT Measure, get the following error.
--------------------------------------
Unable to open cellset

Formula error - aggregations are not supported for the DISTINCT COUNT
measure "Invoice Number" - in the Aggregate function
-------------------------
My Query is given below:
With
Member [Geography].[Filter] As 'Aggregate({[Geography].[USA],
[Geography].[India]})'
Select
{[Measures].[Invoice No]} On Columns,
{[Customer].[Customer Name].Members} On Rows
From
Sales
Where ([Geography].[Filter])

Please help in resolving this problem.

Thanks in advance.

Manoj

the aggregate function cannot be used against a Distinct count measure
(standard measure)
you have to create a calculated distinct count to do this.


"Manoj" <Manoj (AT) discussions (DOT) microsoft.com> wrote

Just wanted to mention, that it is possible in Yukon.

--
==================================================
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.
==================================================

"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote