Hi


When I use Aggregate function on a Distinct Count Measure "Members" and a
a Calculated Measure "Patient Percent of Members

Analysis services displays Error Message for both Distinct Count and Calculated Measur
I am struck

The following is the MDX Query

WITH Member [Episode].[NewMember] A
'aggregate
Filter
{[Episode].[Episode Key].Members},Val([Episode].CurrentMember.Properties("Episode Payment"))>5

)
SELECT {[Calendar Time].[Calendar Year].Members} ON ROWS
{[Measures].[Members],[Measures].[Patient Percent of Members]} ON COLUMN
FROM VCPerCal
WHERE [Episode].[NewMember

I am trying to filter "Calendar Time" members based on a members of "Episodes" dimension

regards.

You cannot use the Aggregate() function with distinct count aggregate types.
This is being addressed in the next release of Analysis Services. In the
meantime, there is a workaround that you can use. I'll post it over in the
http://groups.msn.com/OLAPServicesDevelopersForum


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

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