Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Aggregate for count distinct metric

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Aggregate for count distinct metric Empty Aggregate for count distinct metric

Post  anarc_iph Wed Oct 16, 2013 2:56 pm

Hi,

Is there a technique to create aggregates for a metric that uses count(distinct(col)) ?

Ana

anarc_iph

Posts : 1
Join date : 2013-10-16

Back to top Go down

Aggregate for count distinct metric Empty Re: Aggregate for count distinct metric

Post  ngalemmo Wed Oct 16, 2013 3:12 pm

If you mean a user wants to do a count distinct based on some varying number of dimensions or filters, then yes. The technique is to not create an aggregate.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

 
Permissions in this forum:
You cannot reply to topics in this forum