February 12, 2013 at 7:39 am
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.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy