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   (RSS)
Showing page 2 of 3 (24 total posts)
  • End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI

    This year is going to end, Maya failed their predictions and while this is bad for predictive industry, it’s also good for all of us! We’ve seen many news in Microsoft BI stack: Excel 2013 has been RTM’d – its General Availability is expected in early 2013 but many early adopters are already using it daily (myself included) PowerPivot and ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 27, 2012
  • Meet SQLBI at PASS Summit 2012 #sqlpass

    Next week I and Alberto Ferrari will be in Seattle at PASS Summit 2012. You can meet us at our sessions, at a book signing and hopefully watching some other session during the conference. Here are our appointments: Thursday, November 08, 2012, 10:15 AM - 11:45 AM – Alberto Ferrari – Room 606-607 Querying and Optimizing DAX (BIA-321-S) ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 2, 2012
  • Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

    If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns, which compute their value within a filter context defined by the rows considered in the group that the SUMMARIZE uses ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 4, 2012
  • New videos available #dax #ssas #powerpivot

    The collaboration I and Alberto started with Project Botticelli is starting producing content. At this point we have three videos available: DAX in Action shows the power of DAX in PowerPivot solving common patterns not so easy or fast to solve in other languages DAX: Calculated Columns vs. Measures shows the difference between calculated ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 24, 2012
  • DAX Studio 1.0 beta available #dax #tabular #powerpivot

    Are you waiting for a usable and interactive DAX editor? Are you tired of using the MDX editor provided by SSMS as a temporary solution to write and execute a DAX query? The wait is over! DAX Studio is a free Excel add-in that enables you to write a DAX query in a small dialog box that offer a productive environment, with a tabular object browser ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 30, 2012
  • 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
  • The Many-to-Many Revolution 2.0 #ssas #mdx #dax #m2m

    In September 2006 I had announced in this blog the release of the first version of The Many-to-Many Revolution, a whitepaper that describes how to leverage the many-to-many dimension relationships feature that had being available since Analysis Services 2005. The paper contains many generic patterns that can be applied in many common data ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 9, 2011
  • First steps with #ssas #Tabular in #Denali #CTP3

    The Analysis Services team just posted a blog entry with a few useful links to jumpstart your experience with Tabular project in Analysis Services ''Denali''. In these early days I read several messages asking for clarification about the names and acronyms used in Denali. For a complete description I suggest you to read the Analysis Services - ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 14, 2011
  • DAX Deep Dive at #sqlbits9

    I and Alberto Ferrari will present a DAX Deep Dive training day at SQLBits 9 in Liverpool, on September 29th. The conference will continue on September 30th and October 1st. Registrations are not yet open, but you should definitely save the date for SQLBits! The goal of our session will be to cover all of the aspects of DAX, starting from the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 4, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement