problem using measure based on DISTINCT COUNT

[Markus Stehle]

Hi all!

I`m using an OWC10 pivot table to display data from an OLAP cube. Within
that cube I have a calculated measure that uses the Distinct Count aggregate
function.

When displaying the data from the cube in the pivot table without setting
any filters, then everything is fine. But as soon as I set a filter (e.g. to
a specfic year) I get the following error:
Formula error - aggregations are not supported for the DISTINCT COUNT
measure "myMeasure" - in the Aggregate function

Instead of a number, the pivot table just displays #VALUE.

How can I solve this problem?


Thanks

Markus