Hi Masters:

I have a calculated measure with a distinctcount function over a Customer
Dimension in my Cube... (i am using AS 2000)

DistinctCount({[Customer].members})

The problem is that i have a "profit unit" parent-child dimension too, and
that dimension have some "custom" members with unary operators over a field
of the profit unit dimension table.... for that custom members, my
distinctcount measure simply don't work ...(it show zero value)

Any idea?

Thanks
Rodrigo

Hi Jeje:

Thanks for the answer... but what do you mean with "{measures.simplecount}"?
it is a calculated measure?

Thanks

Rodrigo

"Jéjé" wrote:

no, its a simple count measure, not calculated one.
generally an hidden measure used only for the dount calculated measure and
should be on a dedicated cube because the aggregation design is different
from other cubes.

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

Ok. so should be a field with value 1 in the cube's fact table...no?

Thanks

Rodrigo

"Jéjé" wrote:

should be everything you want. so you can count any key in the table like
"CustomerID" or any other column.

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