|
Home > Archive > MS SQL Server OLAP > December 2005 > DistinctCount and PeriodsToDate
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DistinctCount and PeriodsToDate
|
|
|
| Does anybody have used PeriodsToDate and DistinctCount functions together?
I need do count different products through particular period starting from
the beginning of the year...
thanx in advance
| |
|
| with AS2000?
not possible. the dcount measure doesn't support the aggregate function.
you have to create a calculated dcount measure instead-of a dcount
aggregated measure.
anything like:
count(crossjoin(dime
nsion.level.members, {measures.simplecount}),
exclude_empty)
With AS2005 its possible.
"gNM" <gedukas99@hotmail.com> wrote in message
news:%23BmcjT8CGHA.3140@TK2MSFTNGP14.phx.gbl...
> Does anybody have used PeriodsToDate and DistinctCount functions together?
>
> I need do count different products through particular period starting from
> the beginning of the year...
>
> thanx in advance
>
|
|
|
|
|