hi all,

I tried using distinct count Aggregation as one of
my measure in my cube, then tried to create an
offline cube out of it. But received an error -

OLE DB Provider for analysis services :
Formula Error - global cubes do not support distinct
count measures.

Aside from that, I also been receiving (#VALUE!) for total
values for the said measure.


You guys have any recommendations on using distinct count
aggregate?


Thanks in advance!






*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Distinct Count measures are not supported in the local cubes. The workaround
(which will cost you performance) is to use instead calculated measure with
DistinctCount() MDX function. If you create local cube by using
http://www.localcubetask.com product - I beleive it can do it automatically.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"May Ferrer" <anonymous (AT) devdex (DOT) com> wrote