Browse by Tags

• Analysis Services
• BI Developer Studio
• BIDS
• BISM
• Book
• Bug
• Business Intelligence
• Communities
• Conference
• CTP3
• DAX
• Denali
• Excel
• Excel 2007
• M2M
• PASS
• PivotTable
• PowePivot
• PowerPivot
• Reporting Services
• SQL Server 2008
• SQL Server 2012
• SSAS
• Tabular
• UDM

• SQLLunch on April 23 in London and Cardiff #sqlpass #dax #sqllunch

  On April 23 I will present DAX in Action in London and Cardiff at SQLLunch event. How is it possible I will be in two places at the same time? This will be a remote presentation delivered in two locations, where you can have lunch while watching the session. Read More... Posted Monday, April 15, 2013 11:52 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Communities, MDX, DAX, Tabular

• MDX Studio download #mdx #ssas

  Short version: the latest available version of MDX Studio can be downloaded from http://www.sqlbi.com/tools/mdx-studio/ Long version: Last week Stacia Misner twitted that the online version of MDX Studio was no longer available. It was hosted on http://mdx.mosha.com Read More... Posted Monday, September 24, 2012 2:52 PM by Marco Russo (SQLBI) | 16 Comments Filed under: Analysis Services, MDX, SQL Server 2008, UDM, SQL Server 2012

• Using SQL to query Multidimensional and Tabular models #dax #sql #mdx #ssas

  Analysis Services answers to query in MDX, in DAX (by now just for Tabular models) and has a limited capability to answer SQL queries. It is not useful for any development or client tool, but I wanted to write a blog post on it in order to be able to Read More... Posted Thursday, January 12, 2012 3:12 PM by Marco Russo (SQLBI) | 4 Comments Filed under: MDX, DAX, BISM, Tabular

• Analyze #DAX query plan with Profiler

  Jeffrey Wang started the 2012 (or finished the 2011, depending on your time zone) by publishing the first article dedicated to DAX Query plan . While I look forward to reading next articles, it is interesting the explanation of what is the relationship Read More... Posted Sunday, January 01, 2012 9:17 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX, DAX

• Learn more about MDX every day

  I started learning MDX in 1999 and after so many years of using it and teaching it to other people, I still discover something new every day. Not only because I use it in strange ways (well, this doesn’t happen every day, at least!) but because there Read More... Posted Wednesday, November 16, 2011 10:05 AM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, MDX

• 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 Read More... Posted Wednesday, November 09, 2011 2:17 PM by Marco Russo (SQLBI) | 0 Comments Filed under: M2M, SSAS, Analysis Services, MDX, DAX, BISM, UDM

• Converting #MDX to #DAX and PowerPivot Workshop online #ppws

  I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already Read More... Posted Monday, November 07, 2011 11:40 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX, PowerPivot, DAX, BISM

• Median, Moving Average, Quartile and Percentile calculations in #PowerPivot

  Javier Guillén wrote several blog post about how to implement certain common calculations in PowerPivot. It is interesting to read his posts not only because of the solutions he propose, but also because he uses several techniques that can be applied Read More... Posted Tuesday, September 13, 2011 7:18 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX, PowerPivot, DAX

• #MDX Cookbook : a new must read for #SSAS developers

  There are not so many books about MDX and it’s strange considering that it is a very sophisticated languages that requires years for learning (I’m not kidding). I started learning MDX in 1999 and after so many years, I still have to learn something. I’ve Read More... Posted Thursday, August 25, 2011 12:21 PM by Marco Russo (SQLBI) | 9 Comments Filed under: SSAS, MDX, Book

• Vote a bug and a missing feature in #powerpivot #denali #ctp3 on #connect

  If you have 30 seconds available, please vote the following items on Connect: https://connect.microsoft.com/SQLServer/feedback/details/679618/import-attribute-key-from-ssas-in-powerpivot When you import data coming from an Analysis Services cube in PowerPivot, Read More... Posted Tuesday, July 19, 2011 10:24 AM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services, MDX, BIDS, PowePivot, BISM, Denali, CTP3

• #MDX in London and speculation about future books

  Chris Webb, who wrote the Expert Cube Development with Microsoft SQL Server 2008 Analysis Services book with me and Alberto , is preparing another Introduction to MDX course in London, this time from October 26th to 28th. It is now a three day course Read More... Posted Wednesday, June 29, 2011 11:42 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX, Book

• IF and IIF statement in #mdx

  Jeffrey Wang wrote an interesting post about internals of IF statement in MDX script , describing how and when it is rewritten as a IIF statement. The interesting news in his post is also a possible query plan tool for MDX in the future. Probably not Read More... Posted Tuesday, June 28, 2011 11:37 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX

• Microsoft updates its BI Roadmap - #ssas #bism #teched #powerpivot

  During TechEd 2011, Microsoft announced an important update to its BI roadmap . The reason why this is important is related to the previous announcement, which I discussed in November 2010 by including links to several sources and comments. At PASS Summit Read More... Posted Wednesday, May 18, 2011 5:56 PM by Marco Russo (SQLBI) | 13 Comments Filed under: Business Intelligence, Analysis Services, MDX, PowerPivot, DAX, PowePivot, BISM, UDM

• Recursive calculations in MDX #ssas #mdx

  Jeffrey Wang wrote a very detailed blog post about recursive calculations in MDX with Analysis Services. In these days I'm doing some comparison between DAX and MDX (well, between Vertipaq/PowerPivot and OLAP/SSAS engines) and I'm discovering that MDX Read More... Posted Thursday, April 28, 2011 8:51 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Analysis Services, MDX, DAX, UDM

• The Last Ever Non Empty calculation in MDX

  Chris Webb posted a wonderful solution to the Last “ever” non empty calculation in MDX . I never thought to this solution and it is really a nice approach. I think that DAX might be faster in this scenario – a similar calculation has been shown in this Read More... Posted Monday, March 28, 2011 12:48 AM by Marco Russo (SQLBI) | 0 Comments Filed under: MDX, DAX