dbTalk Databases Forums  

DistinctCount and PeriodsToDate

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss DistinctCount and PeriodsToDate in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
gNM
 
Posts: n/a

Default DistinctCount and PeriodsToDate - 12-28-2005 , 09:39 AM






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



Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: DistinctCount and PeriodsToDate - 12-28-2005 , 09:50 AM






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(dimension.level.members, {measures.simplecount}),
exclude_empty)

With AS2005 its possible.

"gNM" <gedukas99 (AT) hotmail (DOT) com> wrote

Quote:
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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.