Only One Distinct Count Measure?

[ajc123]

Is there a work-arund for the limitation that only one measure in a cube can be a Count Distinct? I've got two!

Thanks for sharing!

 

[corilynn]

You can create "virtual cubes" (available as a right click) that contain each of your cubes with one distinct measure.

I have one cube for each distinct measure I need, then I've created a virtual cube combining all of the distinct cubes (as well as a few calculated measures) and all of the dimensions that my users need so that they only have to connect to one cube in order to do their research.

 

[ajc123]

Thanks Corilynn.

I discovered this. The trick is that the cubes need to use Shared Dimensions. Once I got that, it was smooth sailing!