I have a problem with multi-selection in excel xp and 2003...I have a excel
report in a pivot table and it has external data with source in a analysis
services cube. The Analysis Services cube has some dimensions and measures.
One of measures use the distinct count function (aggregate function) and the
others measures use the function sum.

In the pivot table in excel the values appear good when in everyone
pagefields (dimension in AS) don't have enable the check in multi-selection,
that is to say if I choose the measure with the distinct count appear the
correct values. ¡¡¡But if I enable the multi-selection in whatever pagefields
and I choose a filter for the analysis then the values that appear in the
distinct count measure is #¡VALOR!.

What is the problem??? Is it a problem with analysis services or excel???
...really i think is a problem with the distinct count measures ...How I solve
this problem???

thanks

When multiple members are selected, looks like that internally
Aggregate({mem1, mem2,...}) is used. Unfortunately Aggreagte() does not work
with distinct count. As I know, AS 2005 will support this.

Ohjoo Kwon


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