O The distinct number of Customers on 03 March 2008 is 51 Customers.Ĭreating the Distinct Number of Customers Calculationġ. In order to follow how this works, we will be using the Order date of 03 March 2008.the lowest level was the Date or OrderDateKey. NOTE : The thing to note is that you will always want to create your distinct calculation on your lowest granularity.O So this will enable us to get a distinct count based on any of the attributes from our Customer Dimension We are going to get the distinct number of Customers ( CustomerKey) from the.I used the AdventureWorksDW2012 Data File and AdventureWorks Multidimensional Models SQL Server 2012.In our example below we want to extract from the AdventureWorksDW2012 Analysis Services Database What I wanted to do is instead of using the Distinct Count Function which we can use within SQL Server Analysis Services (SSAS), (which as we know has some performance issues along with creating its own measure group), I wanted to find a way where I could use the SUM Function in our Measure group but still return the distinct count.Īnd then use this distinct count using a dimension to slice by Whilst completing my review on the Expert Cube Development with SSAS Multidimensional Models, I came across the Distinct Count Measure within SSAS and how this can affect query performance as well as processing performance.Īnd here is a link to the actual book that I am reviewing:
0 kommentar(er)
