Is there a way to get around having more than one distinct count measure?

With AS 2000, you can have multiple cubes, each with 1 distinct count,
combined in a virtual cube. With AS 2005, you should be able to create a
separate measure group for each distinct count.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

I had it all in one cube. I'll divide the data up in separate cubes.

"Deepak Puri" wrote:

the other option is to create calculated dcount measures
(slower then aggregated dcount measures but don't required to process more
cubes or measure group)

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Deepak, advice...
Is it ok to use the same fact table for each cube with the different measure
that I want to have a distinct count for?

"Deepak Puri" wrote:

I tried that but when I created the calculated member to perform the distinct
count, the numbers were not changing when filtering against a certain
dimension.

"Jéjé" wrote:

You should be able to use the same fact table in multiple AS 2000 cubes
- each cube would have a distinct count measure based on a different
field in the fact table. Of course, shared dimensions should be used
across the cubes, so that they can be included in the virtual cube.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***