Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Distinct count Expand / Collapse
Author
Message
Posted Tuesday, February 12, 2013 7:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Sunday, November 17, 2013 2:32 AM
Points: 36, Visits: 67
I want to calculate a distinct count of customers in a cube of analysis services.
I have a field=CustomerKey in the fact table.


1. I put AggregationFunction=DistinctCount for CustomerKey, but I have this measure in the same measure group with the other measures of the same fact table.Is it a way to move the distinct count in a separate measure group after I had created it?

2 I would like to use an MDX query.What's the easiest way to do this?
ex: count(distinct(set), excludeempty)......What I have to put in the set.....?!?

What't the best way for the performance?


Thank you everybody.



Post #1418969
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse