THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Tabular » DAX » BISM » Analysis Services   (RSS)
  • SQLBits XI in May 2013 – many reasons to attend! #sqlbits #dax #tabular

    I and Alberto Ferrari will speak at SQLBits XI (Nottingham, UK – May 2-4, 2013) and there are many good reasons to join us there, especially if you are interested to DAX! Here are our sessions: Thursday, 02 May 2013 – Training Day - From 0 to DAX The entire day is dedicated to learning DAX, starting from the syntax and going forward ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 20, 2013
  • 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 it would return the number of distinct versions of customers. What you really want to do is to ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 9, 2012
  • #DAX Query Plan in SQL Server 2012 #Tabular

    The SQL Server Profiler provides you many information regarding the internal behavior of DAX queries sent to a BISM Tabular model. Similar to MDX, also in DAX there is a Formula Engine (FE) and a Storage Engine (SE). The SE is usually handled by Vertipaq (unless you are using DirectQuery mode) and Vertipaq SE Query classes of events gives you a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 21, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement