Hi Martin,

What I am trying to do is get a distinct count of the number of Clients in a
system. The Client Id is an alphanumeric field, a text datatype.

I tried the suggestion below:

1) created new dimension dimClientId from the ClientTable with 1 level
Client Id
2) create calculated Member Distinct Clients (Parent Dimension is Measures)
Count(DISTINCT({[dimClientId].[Client Id].Members}),excludeempty)

but when I browse the data the cells for the calculated member show #ERR.

The message I get when I double click it is:
"Infinite recursion detected during execution of calculated member Distinct
Clients."

I cut and past the query used in the build process and it worked fine.

Any ideas?


Thanks in Advance

Fred

"Martin" <martin.kihl (AT) scania (DOT) com> wrote

I found a way to make this work.


I created a calculate member as:
Count(CrossJoin({[Clients]}, [dimClientId].[Client Id].Members),
ExcludeEmpty)

This appears to give me what I want.

Fred

"Fred K" <fkilby (AT) co (DOT) marin.ca.us> wrote