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 » MDX   (RSS)
Showing page 2 of 10 (92 total posts)
  • 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 know MDX, you might wonder how to “translate” your MDX knowledge in DAX. I think that this ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 7, 2011
  • Book Review: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

    As I mentioned in an earlier post, I first met Tomislav Piasevoli’s (blog|twitter) in 2008 at the PASS Summit in Seattle, and saw him again most recently again in Seattle at PASS Summit 2011. There I had the pleasure of telling him personally how much I liked his book. There are not many MDX books available, so when a new one arrives on the ...
    Posted to Stacia Misner (Weblog) by smisner on October 21, 2011
  • 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 in other scenarios. Here is a list of posts and reasons to read:Calculating Moving Averages in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 13, 2011
  • Back to the Future with MDX and PASS

    An interesting confluence of events this week takes me both back to the past as I ponder the future! What gives? Well, the recent release of Tomislav Piasevoli’s (blog|twitter) new book, MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook, reminded me of my first meeting with him at a PASS Summit event a few years ago. Alas, I don’t ...
    Posted to Stacia Misner (Weblog) by smisner on September 9, 2011
  • #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 been part of the technical reviewers of the new book from Tomislav Piasevoli, MDX with ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 25, 2011
  • 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, you cannot import the attribute key value. Only the attribute name is included in the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 19, 2011
  • #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 (previously it was two day) and you can find every other detail here. You might be wondering ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 29, 2011
  • 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 in Denali time, but I hope very soon...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 28, 2011
  • 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 2010 the announcement regarding the next version of SQL Server, codenamed ''Denali'', ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 18, 2011
  • 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 calculation engine is much more smart than you might think in certain conditions. I cannot ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 28, 2011
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement