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 » Analysis Servic... » DAX » Tabular » BISM   (RSS)
  • Basket Analysis with #dax in #powerpivot and #ssas #tabular

    A few days ago I published a new article on DAX Patterns web site describing how to implement Basket Analysis in DAX. This topic is a very classical one and is also covered in the many-to-many revolution white paper. It has been also discussed in several blog posts, listed here in historical order: Simple Basket Analysis in DAX by Chris Webb ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 12, 2014
  • 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