April 2012 - Posts

• Last minute update #ssas #tabular community event in Amsterdam on April 16

  We finally have the registration website for the community event about Tabular in Analysis Services in Amsterdam on April 16 evening that I introduced in my previous post - don't miss it, the registration are open (and limited!) at: http://passnl-april2012.eventbrite.com/ Read More... Posted Saturday, April 14, 2012 2:45 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, BISM, SSAS, Tabular

• #SSAS #Tabular Workshop and Community Events in Netherlands and Denmark

  Next week I will finally start the roadshow of the SSAS Tabular Workshop , a 2-day seminar about the new BISM Tabular model for Analysis Services that has been introduced in SQL Server 2012. During these roadshows, we always try to arrange some speeches Read More... Posted Thursday, April 12, 2012 2:04 PM by Marco Russo (SQLBI) | 1 Comments Filed under: Analysis Services, BISM, Communities, Tabular

• Distinct Count of Customers in a SCD Type 2 in #DAX

  If you have a Slowly Changing Dimension (SCD) Type 2 for your customer and you want to calculate the number of distinct customers that bought a product, you cannot use the simple formula: Customers := DISTINCTCOUNT( FactTable[Customer Id] ) ) because Read More... Posted Monday, April 09, 2012 11:55 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, BISM, DAX, Tabular