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
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: Friday, June 20, 2014 4:00 AM
Points: 49, Visits: 84
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